Dale, do you mean the job we talked last time offline or is this now something different?

Well, my company has finally realized, that in times of worse economy it isn't...

Each time I read "generic", there's something rotten in the state of Denmark.

Like Antares said, what is your goal? And in the meantime, maybe this helps:

http://www.sommarskog.se/dynamic_sql.html

Well, seems to be still down

Adam is a regular visitor here. I dropped him a PM, but I would keep trying to reach...

Hey, exactly the opposite here.

My boss said, I should get some training this year. Last time was about 3 years ago. So, now...

Yes, that's another method. Did think of this, too. Well, guess it boils down now to a matter of preferences.

@sList VARCHAR without any dimensioning is equivalent to @sList VARCHAR(1).

There are subtle differences between COALESCE and ISNULL. Consider this:

CREATE TABLE #t

(

 c1 CHAR

)

INSERT INTO #t VALUES (NULL)

SELECT

 ISNULL(c1,'Frank')

 , COALESCE(c1,'Frank')

FROM

 #t

SELECT  ISNULL(c1,'Frank')

 , COALESCE(c1,'Frank')

 ,CASE WHEN c1 IS NULL THEN 'Frank' ELSE c1 END...

See, if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

While this will work, note that xp_dirtree is undocumented.

You can achieve the same result, if you pipe the result from a simple xp_cmdshell DIR... into a table like so:

create...

The fact, that this aggregate concatenation queries work, is amazingly enough when you consider this KB article http://support.microsoft.com/default.aspx?scid=kb;EN-US;287515 

SQL Server MVP Adam Machanic has a nice demonstration, that might give...

The sarcastic in me would say, change the colour scheme in Query Analyzer and then make a screenshot while me usual alter ego...

Have you seen today's article?

Okay, finally I see your point here. I don't think you can mix these both into one. I think you need a second...

I think another problem will be the datatype of 'age'. I suspect something numeric. And since CASE is trying to cast to the highest precendence among its arguments, this might...

If you want to sort descending and prefix Ms. Green with the prefix 'AAA', why do you expect her to show up on top?...