@Yin Halen, thanks for having us in your thread. My day wouldn't have been as much fun without it.

@jeff, your audience must be on a more advanced level than mine...

I know, the example was far fetched. And as I said: there are far better ways to implement the example. Still I don't share your idea that readability is always...

Jeff Moden (8/16/2011)

It can be usefull, but only in very specific situations. But then, when people get to those situations, they tend to use alternative solutions since they are not familiar with...

Sean Lange, I hadn't yet seen the additional requirement of skipping 0's when I wrote my reply. That is why yours looked over complicated to me. Sorry about that.

Of course...

Sean Lange (8/15/2011)

DECLARE @a int = 102733019,

@b-2 int = 102733019 ,

@c int = 0

select case when

(@a =...

The ALL operator might be helpfull too (I always wondered when it would be helpfull and this is when 🙂 ):

declare @a int;

declare @b-2 int;

declare @c int;

select @a = 1,...

I needed the iso week number too in SQL 2005. Looked for it in all the usual places (bol, forums, google, etc) and found many different implementations. Most however have...

As an example of Eugence's tip an excerpt of your query, but now using a left join (so you will still get an order listed even if its freight charge...

I've read from your request that you want one long string returned for the entire file: i.e. each row is stored in 47 characters with no row separator in between....

This has been answered above by skcadavre already? What don't you understand of it?

If you really...

select (

STUFF(

(select N', ' + cols.COLUMN_NAME as [text()]

from Razor_3_Snapshot.INFORMATION_SCHEMA.COLUMNS cols Where cols.TABLE_NAME= 'TradeContributionSummary'

order by cols.ORDINAL_POSITION

for xml path('')

)

,1,1,'')

) Probably you won't notice this as a problem, but this version also...

Not only is it missing the value(), it is also missing the ", type" clause on the for xml path(''). Adding ,type makes the for xml path() clause return a...

I think you intend to use LIKE to find all instances that have one of the 'invalid' characters and then use the replace sequence to 'fix' the issue. Is that...

And a tip: when constructing queries, you will want to investigate the quotename() function.