hi...

But i am getting colb as 1 only not 2... I tried in 2008 and 2005..

I think the answer is 'E' only..

This is the script..

CREATE TABLE #TestUpdateA

(ColA CHAR(1),...

hi,

But there is a difference in normal sorting and this sorting when it comes on null values.

select top 10 * from Employee

order BY CASE

when @SortOrder...

hi,

But there is a difference in normal sorting and this sorting when it comes on null values.

select top 10 * from Employee

order BY CASE

when @SortOrder...

hi,

Check this link

http://www.sqlservercentral.com/Forums/Topic721835-338-1.aspx

What about ratings..

how ratings will be given...

hi,

u can try this..

SELECT [Emp_Id],[Shift_Date] FROM [Emp_Shift_Details] Where

cast(convert(datetime,Shift_Date,101) as datetime) = @StartDate;

Refer this link

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbrfen9/00000293.htm