Use the following code as a template to prepare a CREATE TABLE and INSERT script, which when run will create the tables and populate them with some sample data.

CREATE TABLE...

So...how will you identify...

Hearty congratulations Mrs G!

WayneS (12/1/2010)

---

Chris Morris-439714 (12/1/2010)

---

WayneS (12/1/2010)

---

Chris Morris-439714 (12/1/2010)

---

Good Lord...

Looks like you were on the right track at the start - does this help?

;WITH RowPicker AS (

SELECT A, B, C, D, E,

Total = SUM(D) OVER (PARTITION BY A,...

Scurvy

WayneS (12/1/2010)

---

Chris Morris-439714 (12/1/2010)

---

Good Lord Wayne you're morphing...

I'd recommend that you hang around for a day or two. Often a piece of klunky code like this will be superceded by...

This is a horrible piece of code but it works:

DROP table #Emp

create table #Emp

(

empid int primary key,

empname varchar(50),

managerid int

)

INSERT INTO #Emp (empid, empname, managerid)

SELECT 1000, 'mani', 0 UNION ALL

SELECT...

You may have to delete in batches...

Here in Middle England the sun is shining through the office window. Horizontally of course but it's there and folks are brighter for it. Outside it's about 0C with a...

Jeff Moden (11/30/2010)

---

Grant Fritchey (11/30/2010)

---

Jeff Moden (11/30/2010)

---

Changing subjects, have you seen today's featured script? It comes under the category of "Are the featured scripts getting worse"? I try...

Good Lord Wayne you're morphing into Karthik :unsure:

GilaMonster (11/30/2010)

---

GSquared (11/30/2010)

---

If it were written:

SELECT ..

FROM T1

inner join T2

on T1.a >= T2.b

inner join T3

on T1.a <= T3.c;

Would you still question it? It's the same...

Query1, Query2 and Query3 are functionally the same. If you run these three queries and look at the actual plans for each one, they are very likely to be identical....