The Jez McKinley Wiki

select act_key from ld_actions where start_time is null

select prob_key from ld_problems where start_time is null

select sc_key from ld_shortcalls where log_time is null

select count(start_time) from ld_problems

truncate table ld_shortcalls truncate table ld_actions truncate table ld_problems

select reploc from ld_shortcalls where reploc is not null

select reploc from ld_actions where reploc is not null

select reploc from ld_problems where reploc is not null

insert into locations values ('Wallaby', 'AU', 'Australia', 'Wollongong')

select * from locations

select top 10 sc_key, call_date from ld_shortcalls

SELECT "reploc" FROM "dbo"."ld_problems"