Viewing 4 posts - 1 through 4 (of 4 total)
SELECT * into
#TEMP_TRAN FROM
(select distinct
TLR_Br_Num as Branch,
TLR_Emp_Num as Employe,
TLR_Trn_Dt as Tran_Date,
TLR_Trn_Tm,
(Left (TLR_Trn_TM, 2) + ':' + RIGHT (TLR_Trn_TM,2)) as Tran_Time,
count (TLR_ID) as Num_Trans
From dbo.TLR
WHERE TLR_BR_Num = '00001'
and...
March 5, 2015 at 5:02 pm
@david-2 thank you but it didn't work and run for almost 1 hours, my intentions were to get a time comparison between the last record from a same...
February 27, 2015 at 3:18 pm
Great article and easy to follow along - even for rookie like me. Thanks again.
February 24, 2015 at 9:41 am
Thank you very much and I know is was a lot to ask for the first time around.
March 10, 2011 at 5:43 pm
Viewing 4 posts - 1 through 4 (of 4 total)