Click here to Skip to main content
15,897,518 members

Comments by Tiwari Avinash (Top 42 by date)

Tiwari Avinash 21-Aug-17 7:53am View    
Nice solution :D
Tiwari Avinash 18-Jul-16 7:25am View    
Please be more specific about your error, and provide some more logical codes so that some one can help you.
Tiwari Avinash 19-Feb-15 0:27am View    
Why are you sending a data object reader to your business logic? I think if you have maintained a clear separation between data layer and business layer its not a good idea to send data reader to business layer.
Tiwari Avinash 29-Sep-14 5:36am View    
Why don't you use Join for selection i.e. in select statement and then try order by i think will work fine. Sorry I haven't checked this. please do let me know if tit worked.
Tiwari Avinash 29-Sep-14 5:24am View    
select right('00'+convert(varchar,datediff(HOUR,CONVERT(datetime,'18:00',103),CONVERT(datetime,'19:30',103))),2)
+':'+right('00'+
convert(varchar,datediff(MINUTE,CONVERT(datetime,'18:00',103),CONVERT(datetime,'17:30',103))),2)


if it helps please mark it as answer