Viewing 12 posts - 1 through 12 (of 12 total)
data what i have
division 2012 2013 2016
xyz 1 0 10
abcd ...
January 15, 2013 at 2:03 am
Hi Ten,
thanks that one solved my problem
thanks
fairozkhan
March 7, 2011 at 12:30 am
yes it should return all the rows. by the way i am executing it in sql server management studio.
June 16, 2010 at 5:58 am
Hi SSC,
I tried ur sql and modified like below but it is giving me error incorrect syntax near '('
with ct(subject_id,time_in1)
(
select subject_id,
convert(datetime,left(History.Time_In,2) + ':' + substring(History.Time_In,3,2) + ':' + right(History.Time_In,2),108)
as...
August 25, 2009 at 3:59 am
Hi,
i got it, the problem was i was adding N only for one name infact it should be added to all the names.
Thanks All
June 11, 2009 at 11:24 am
Viewing 12 posts - 1 through 12 (of 12 total)