Posted by --CELKO-- on 05/31/06 22:34

>> I see you use CTE, why don't you pull the results down into the application, CTE's are a form of formatting for display purposes, as is COALESCE on the SELECT clause, as is ORDER BY etc... Just where do you draw the line? <<

UNH? CTEs are virtual tables and have nothing to do with display. Do
ypou also think that VIEWs and derived tables are formatting for user
display? COALESCE is a function that works with NULLs and CAST() to
get another internal data type result.

Things like CONVERT() on dates or PRINT in T-SQL is formatting.

• Next in forum: Re: How can I conserve the initial zero when convert numeric to string using STR()
• Prev in forum: Re: How can I conserve the initial zero when convert numeric to string using STR()
• Thread view: Re: How can I conserve the initial zero when convert numeric to string using STR()

[Reply to this message]