Guys may be the calculated column is not availabe inside the CASE..soo instead of referring it by the name recalculate it everytime inside every condition or use a function for...

Thanks Kelly

As far as I dug out SQL server,I think that we will not be able to Get the return Type for a SP.i tried out the following and got...

thats really great to read thru all those people think about the never ending RDBMS war.I have something to add on ..

SQL server is exclusively for Windows platform.so it inherently...