Sounds like a consultant job to me. It would start with clarification of the requirement:

Either rotation is random (as requested) or rule-based (as described), why would I need the insert_ProductNew...

Hey Lynn, congrats to Kassondra!! West Point sounds better than the places you've mentioned a few thousand posts back... A LOT better!!

Kassondra, you and your whole family can be very,...

ron5 (7/29/2010)

---

nice to hear.

do you by any chance know of some documentation on the various functions of sql Xml fields and how they are used.

for example , why...

What exactly is your expectation when using row versioning?

Based on the assumption you'e looking for a way to get the rows into separate columns, please have a look at the CrossTab article referenced in my signature.

How do you know which character needs to be considered as "special"?

E.g. space, ?, < or > might be considered valid or not...

Do you have a list of valid character...

You would need to use dynamic SQL.

Something like:

DECLARE @sql VARCHAR(500)

-- Insert statements for procedure here

SET @sql=

'SELECT CASE_NO

INTO [' +@TableName + ']

FROM SEHC

WHERE FIP = ' + @pCountyFIP +'''

EXEC(@sql)

Side...

You're welcome 😀

That's what you get when providing ready to use sample data, expected result and your current approach: a verified solution matching your requirement 😉

So, you did a great...

You were close.

All that's missing is a WHERE clause:

SELECT

b.header.value('Value[1]', 'varchar(20)') AS Typex2

FROM @bb.nodes('//ProcessTraceNode') AS b(header)

WHERE b.header.value('Caption[1]', 'varchar(20)') ='SUBFORMULA'

Please have a look at the CrossTab article referenced in my signature.

Based on that you should continue by reading the DynamicCrossTab article also referenced in my sig.

If you need a...

What would be your expected result based on the sample data?

What exactly do you want to extract?

A simple SELECT columns FROM table will give you the content of the table.

If you want to shred the XML data you should look...

There's (at least) one thing you can't get by simply reading books: experience!

Even if it's not directly SQL Server related experience. Over the years I've learned to stay calm while...

Ok, here's what I came up with:

Basically, I add a single row per database using UNION ALL and sort it as required.

The major downside (except for possible performance impacts due...

I had a look at the bmp file you posted. That's not what I expected.

Please provide table structure (CREATE TABLE) and some INSERT INTO ... SELECT ... UNION ALL statements...