opc.three (5/13/2011)

---

I figure you should get your money back! Anyone "managing"...

Tell me about it I've been arguing the a point with IBM over a particular security implementation we need to do for the last couple of weeks, they refuse to...

The reason I would stay clear of the CLR root is that a lot of DBA's and outsourcing partners (IBM etc) refuse to accept them as they alledge they...

Thanks for the feed back opc, especially on the Distinct vs Group By modification and the tips on XML escaping characters, based on the opening post I would have thought...

PHXHoward (5/10/2011)

---

Thanks Jason.

I gave the row a name 'test' and then it ran.

It adds a new row for each application.

instanceid application

417row test=",Application1

417row test=",Application2

418row test=",Application3

instead of

417 ...

What about

Select Distinct

InstanceId

,Substring(Replace

(Replace((Select ','+Name

From Application

where ApplicationId=appinst.ApplicationId

...

It appears that you're trying to flatten the parent child hierachy, I posted something similar here,

http://www.sqlservercentral.com/Forums/Topic1071035-392-1.aspx#bm1073147

Post 4 on the thread was the solution i finally implemented, It could be a...

In that case what you need to do is parse the Metadata in either the INFORMATION_SCHEMA.COLUMNS view or build your own script from the sys.Tables and sys.Columns that will construct...

Why not back up and restore the database?

Alternatively if you have shiny new empty database, why not use the Import data wizard under Tasks on the Target Database?

SSIS...

Charles Hearn (4/8/2011)

---

Before removing the order by, make sure that the SSIS package output is not sorted. You will probably be better off to leave the sort in the...

I forgot to ask if the Temp tables were indexed as that could improve the performance considerably.

I would be tempted to rewrite the query as follows

INSERT INTO ResultTable

SELECT t.field1_varchar_255

...

I take it the ones that run are using...

I trust you can log into the SQL Box using the sa account, and create things on the server?

Other issues could be with the Jobs, are they SSIS or...

Andy,

An intersting article and of great interest having being a DW developer for the last 8/9 years, and I would always describe version 0 as a Proof of Concept...