Using Alan.B's table variable and sample data:

WITH orders AS -- add a rownumber to @orders

(

SELECT rn1=rn, rn2=rn+1, cust_id, order_date

FROM

...

Walton (4/7/2015)

---

Hello All,

I have one stored procedure being called by the job that runs everyday. It generally takes 2-3 minutes to run. But sometime, for some reason it hangs at...

This article is rather complicated but it is the only place that immediately comes to mind to show you how to do this. At least I'm pretty sure it...

Are you aware of what the difference in the...

I just posted this to "The Worst Comments" discussion thread:

dwain.c (4/7/2015)

---

-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar

-- gave me this code...

abatej (4/7/2015)

---

On the whole with SQL Server I've found that most behaviour of this ilk comes down to Microsoft, to their credit, handing us a DB engine and expecting us...

-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar

-- gave me this code on a SQL forum.

-- Call him if it doesn't work.

Now...

djblyth (4/7/2015)

---

All I can take from this article is the mantra "If you're going to write code then make make sure you write it properly, and test it properly"

If you're...

Sioban Krzywicki (4/3/2015)

---

Brandie Tarvin (4/3/2015)

---

djj (4/3/2015)

---

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the...

Brandie Tarvin (4/3/2015)

---

djj (4/3/2015)

---

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday...

Does An Easter SQL[/url] posted on or around April Fools day count?

CELKO (4/2/2015)

---

how about the McCracken books? His A Guide to Fortran Programming ,...

I cover...

Create table #t3 (id int, country varchar(max))

INSERT #t3 SELECT 1,' AU-Australia

MM-Myanmar

NZ-New Zealand

PG-Papua New Guinea

PH-Philippines'

SELECT id, Item

FROM #t3 a

CROSS APPLY dbo.DelimitedSplit8K(country, CHAR(10)) b;

GO

DROP TABLE #t3;

DelimitedSplit8K can be found here: Tally...

pietlinden (3/31/2015)

---

Took me a while to find it... and stop sitting on Itzik's book and actually read it. Got any good references for learning the hardert part of T-SQL...