How about some more sample data then that more closely represents...

Luis Cazares (12/9/2015)

---

This should be safer.

declare @URL varchar(100) = 'http://www.mydomain.info/Customer.aspx?dcc=EUR&h_hmid=2907831&mobiredirect=no&cpn=3790'

SELECT *, LEFT( initial.pos, CHARINDEX( '&', initial.pos + '&') - 1)

FROM (VALUES (@URL)) AS x(url)

CROSS APPLY (SELECT SUBSTRING( x.url, CHARINDEX('h_hmid=', x.url)...

info 58414 (12/9/2015)

---

Hi,

i want to get the num-Value between the 2 Delimiters (h_hmid - and the End of the numeric Value)

in this case: 2907831 (var...

spam reported

Jeff Moden (12/9/2015)

---

Just making sure that I can post here. They had some major problems with my account. I couldn't even see this forum never mind post anything...

skilly2 (12/8/2015)

---

SQLBill (12/8/2015)

---

Now this is why I like these forums.....

Someone posts code that works but might not be the best way (me) and then others follow-up with their suggestions. ...

Here is the syntax for that.

exec spG_Update_EDPS_Staging_Status @Group, @NumRows OUTPUT

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the...

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column...

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column in excel specifically...

SQLBill (12/8/2015)

---

Now this is why I like these forums.....

Someone posts code that works but might not be the best way (me) and then others follow-up with their suggestions. No...

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column in excel specifically where values like...

ScottPletcher (12/8/2015)

---

Sean Lange (12/8/2015)

---

ScottPletcher (12/7/2015)

---

In this case, there's no real need for CTEs or UNIONs either, just standard FULL joins:

SELECT

COALESCE(t1.PRODUCTID, t2.PRODUCTID, t3.PRODUCTID) AS PRODUCTID,

...

Ed Wagner (12/8/2015)

---

Sean Lange (12/8/2015)

---

Ed Wagner (12/8/2015)

---

Sean Lange (12/7/2015)

---

Alan.B (12/7/2015)

---

Sean Lange (12/7/2015)

---

As of today I have only taken 4 days of PTO this year. REALLY looking forward to taking the...

ScottPletcher (12/7/2015)

---

In this case, there's no real need for CTEs or UNIONs either, just standard FULL joins:

SELECT

COALESCE(t1.PRODUCTID, t2.PRODUCTID, t3.PRODUCTID) AS PRODUCTID,

...