etl2016 (2/9/2016)

---

Hi,

I have 10 CTAS statements creating temp tables. Once they are created, they are LEFT OUTER JOINED.

Is there a way, a parallel execution of these 10...

Strikes me as an example of very bizarre ordering. Still waiting to hear what the logic is.

First question: do you need to solve all of the problems in the same piece of SQL, or should they be addressed separately?

It's probably easiest if you change your tack...

Take a look at this: 'Stairway to BIML[/url]'

It will take an investment of your time to get up to speed, but sounds like it might be ideal in your case.

Does table 'a' have one row, or seven?

Why does 8 come before 9 ... what is the ordering logic?

Another way (uses Luis' temp table) (thanks, Luis)

SELECT *

, replace(LEFT(Somestring, charindex('||', Somestring, CHARINDEX('||',Somestring) + 1)-1),'||','-')

FROM #Sample

cheshirefox (2/8/2016)

---

I have SQL instances deployed in 3 data centers with increment ID columns. In each SQL instance, these columns must remain unique.

Is there a native way in SQL...

FunkyDexter (2/8/2016)

---

It's a strong driver but not an absolute imperative. I want to keep as much in SSIS as...

OK, but this does not answer my questions.

dndaughtery (2/5/2016)

---

I have a For Each Loop that contains a process task where Im calling 7 Zip to create a zip file which contains several txt files. Sometimes it runs...

FunkyDexter (2/8/2016)

---

Hi

I'm using SSIS 2008 R2. I have two datasets on which I want to do a full outer join based on a match string, no problem there, I've...

Did you use the project deployment model? If yes, the packages are held in the database in encrypted form.

I'm no DBA, but maybe turning on IFI might help you.

Sean Lange (2/5/2016)

---

Looks like a bass to me. Notice the right hand is playing with the fingers....

Jack Corbett (2/5/2016)

---

No that's Fender Milestone Bass.

I tried to play guitar but I couldn't get...