If your input is as what Chris Morris said, then this would help you

DECLARE @CSV VARCHAR(100)

SELECT @CSV = '1,2,3,4,5'

SELECT x.i.value('(./text())[1]','INT') AS IDs

FROM (

SELECT...

Ok, take this:

select ValueOfCols from

(

SELECT 1 col1, 2 col2, 3 col3, 4 col4, 5 col5

) Pivot_Table

UNPIVOT

(

ValueOfCols FOR Cols IN ([col1],[col2],[col3],[col4],[col5])

) Pivot_Hanle

Take a gander at the first post of this thread: http://www.sqlservercentral.com/Forums/Topic988784-391-1.aspx

Why would xyz come to 2 and abcde be at 1 ?

WebTechie38 (9/20/2010)

---

Whoa!

I am so blown away. Thank you.

It is going to take me a bit to go through this. I would say pretty advanced coding here.

Some of the...

Chris Morris-439714 (9/20/2010)

---

keith-710920 (9/20/2010)

---

Perhaps I'm missing something here, but no where in Dave's original query did he mention anything about parsing folder structures, parsing multiple strings or anything like that....

Jeff, here is my test results for the AdventureWorks JOIN query you asked to give results for. this is run in my slowest environment (Env2)

Hi there, your request made me sweat for 2 hrs 😉

Take this, this will allocate the employees your boss chose in replacement of the departing employee.. this maintains randomness ;...

This seems to be a good challenge, but dint provide us any sample data to get started readily.. Hmmm.. i take it on mine, and here are the sample data...

How would you identify the employees to whom the guests-of-parting-employee will be handed ? Is there an algorithm for that? Say if Employee ID 1 quits, how will u finalize...

Will, why not try BCP for pulling data into a text file ?? using that you can control the NCHAR or VCHAR character sets...

Our pleasure, WRACK..One more thing i want to add is, just look at how Craig set up the base for others to work on with his...

How about this :

Thanks Craig for the wonderful test-setup..

DECLARE @COLS VARCHAR(MAX);

DECLARE @SQL_CASE_STMT VARCHAR(MAX);

DECLARE @SQL_FINAL ...

Jeff, here are the other 3 environment's results (Note : This result set is not the results of the AdventureWorks JOIN code test rig ; this is of the first...

Jeff, this is from environment 2..

~Edit : all my tests will be over the desktop machines, i dont have laptop yet, Jeff.. Rest of the eonvironments, i will give u...