Yes, I took care of that by putting the order by clause.

Thanks,

Murthy

Well business wants it. IT is there is to provide it.  I do not have the authority to ask why.

Its a long story.   I need to achieve it.  I...

Try this,

The usage of case was wrong.  The case can return only one value.

SELECT * FROM TABLE1 WHERE COL1 = 'SOMETHING' AND

COL2 IN ( CASE WHEN @x = 'SQL' THEN...

You can use the rowcount option

SET ROWCOUNT {number | @number_var}

Set it to 1 and issue the delete statement it will delete only one row(incase you...

Try this

SELECT  cast(6/cast(141 as decimal) * 100 as decimal(5,2))

You need to convert on of the value to decimal to show the result in decimal format.

Thanks,

Murthy