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

roger.plowman (2/5/2016)

---

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is missing a join...

Never noticed your avatar pic before: is that you playing a Strat?

PSB (2/5/2016)

---

Hi,

Integration: Error at server : XYZ. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

The sample URL used is :

https://teamspace.abc.com/sites/LLL/LLL-SAP/SARNew/Archive/_vti_bin/listdata.svc

We access the...