Thank you Fire Drill!

Please try this:

SET @vchrIsNumeric='$NAME',

Is Numeric or Is not Numeric?

Thank for the question,

I am not sure the definitions for "Infinite loop" and "nesting" and "Recurring" in sql server.

Basic SQLCMD Utilities? or Basic SQL CMD Utilities? or Basic SQL CoMmanD Utilities, or Basic SQL Utilities?

Anyway, good question!

Please try:

declare @k int;

select

case when @k=0 OR NOT (@k = 0)

then cast(0 as date)

else cast('2012-04-01T10:00:00' as...

I totally agree with you, it is nice to have all aliases listed just for maintainability.

Aliases are not for columns where there is only one column possible.

Thanks for all comments. we use aliases in joins. Aliases are not for columns where there is only one column possible. But it is nice to have...

good and easy question, thanks