mirzafahad1409 (7/31/2010)

---

Thanks jeff for the speedy reply.

First i will post my probs in details.

I have a Excel file.With columns HB_ID,Firstname,LastName,Phone_Numbers,E-mails,Companies.(This is my "Source" File).

Now i have to create a Destination...

You would need a split string function.

Search this site for "DelimitedSplit8K" for a very fast T-SQL solution.

Or have a look at Florian's blog for a comparison of different solutions including...

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...