@jack-2: referring to your current avatar:

you might need to put the guitar aside for a moment. Looks like it would make typing a little complicated 😀

Or do you expect to...

To expand on Gus solution:

(please note I added employee_code to the internal table variable since I think it might be helpful to know what row the change refers to ;-)...

Please don't cross post. You're wasting resources by getting duplicate answers.

Original post: http://www.sqlservercentral.com/Forums/FindPost1231228.aspx

No further replies to this thread please!

Jeff Moden (1/8/2012)

---

LutzM (1/7/2012)

---

You'll need the DelimitedSplit8K function to split the data. If you don't have it in your tool box already, search this site for it (originally posted by...

SQL Kiwi (1/8/2012)

---

You're welcome (but removing the extra .query...

Combine the tweak Paul provided and the preload in a temp table and you should see a significant performance boost.

Based on that you should try whether an xml index will...

My first recommendation is to load the data from the file into a table before shredding it and then replace the OPENROWSET part in your query with that table reference....

There wasn't a missing part but rathe some confusion (there wasn't a table presented but two variables assigned with values and the first post did just include some plain values....)

Anyway,...

Please either post the expected result based on the first sample or the source data of your expected second result set.

Remember: we don't know the business case you're dealing with...

The xml structure has a declared namespace (xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" ) that needs to be referenced in the query:

;

WITH XMLNAMESPACES

(DEFAULT 'urn:schemas-microsoft-com:xml-analysis:rowset')

INSERT INTO Unit_Test ([End User Name], [Country Code], Units)

SELECT

X.OBI.query('C0').value('.', 'nvarchar(100)') AS...

The lack of responses might also be an indicator that we don't have enough information yet.

You're looking for a "resource group and associated teams" but neither is part of the...

Glad it finally worked out for you!! 🙂

And sorry for not getting there earlier... I've been on the wrong track at the beginning :blush:

duplicate post. no replies please.

Original post: http://www.sqlservercentral.com/Forums/FindPost1231214.aspx

You might find Buck Woody's blog helpful.

Hint: found using google search with "sql server schema change history report" 😉

I'm not sure if a linked server will help here (assuming you're talking about using service broker across servers).

The best SSSB resource I know of is Rusanus blog[/url]. I'm confident...