Or this?

-- Populate the AssetAddress Table with the relevant data

IF @Address IS NOT NULL

INSERT INTO AssetAddress ( AssetId, AddressId, EffectiveFromDate )

VALUES ...

ankithimmatlalshah (2/9/2016)

---

Hello everyone,

I’m working on one of the existing Extract package.

Our customer would like to move the complete extract logic, implemented in this package to SQL stored procedure(s) as they...

patla4u (2/10/2016)

---

Hi All,

I have total 460 million row in the table. I am running query for year 2016 and month = 7 and we have total 8 millions records. query...

VastSQL (2/10/2016)

---

Hi Experts,

We have a powershell which we need to run from one of our SQL Servers. The script checks for a particular service in 4 servers and if it...

kavithaje (2/10/2016)

---

Hi Allen,

The query is returning duplicate rows. i have same MachineID and InstanceKey in both tables. only Account. Schema class and time key is different. I mean Work_Station_Admin_1 got...

Aha, I just assumed it was an unorthodox way of referring to SELECT INTO.

Lynn Pettis (2/9/2016)

---

Who has the Crystal Ball??

Silver Spoon(2/9/2016)

---

I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine

ServerName\Instance Cannot be configured for publishing and distribution....

What was the point of this?

The response marked as a solution does not reference your table at all.

The simplest way I can think of doing this is using an SSIS package to submit the queries in parallel via...

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