DeanORenO (1/11/2012)

---

you people on this forum are always complaining about the questions that are asked on the forums, either you complain that they are too simple, and that the poster...

Red Day (frown) Green Day (smile)

;WITH Groups AS (

SELECT GroupId = g.Id, g.GroupName, ga.ParentGroupId

FROM dbo.[group] g

LEFT JOIN GroupAssociations ga on g.Id = ga.GroupId

)

, rCTE AS (

SELECT...

Why not convert Jeff's function to use APPLY, like this:

SELECT ItemNumber, Item...

WayneS (1/10/2012)

---

SQLRNNR (1/9/2012)

---

SQL Kiwi (1/9/2012)

---

You don't think 'Aaron...

Yup[/url].

Try picking up all of the year values in one query:

SELECT d.Create_year, COUNT(*)

from blobs b

INNER JOIN (

Select blob_id, Create_year = year(Created_date)

from attachments a

INNER JOIN Purchase_orders P ON...

Who's Smith?

Jeff Moden (1/8/2012)

---

ChrisM@home (1/8/2012)

---

Why not do this in one step? Select the rows you want...

These are probably the simplest options:

insert into sales (ID,Sales_Jan,Sales_Feb,Sales_Mar,Sales_Apr,Sales_May)

values

(1, 100, 0,0,0 ,0 ),

(2, 120,0, 200, 300,0 ),

(3, 0, 100,0 , 300, 0 ),

(4, 100, 200, 100, 100, 100 ),

(5,...

SQL_By_Chance (1/9/2012)

---

ID Sales_Jan Sales_Feb Sales_Mar Sales_Apr Sales_May Sales_flag

1 100 1

2...

zwheeler (1/6/2012)

---

I have the following query and it works

I would like to rewrite this query as an outer join but i donot know how. I wouild like help in rewriting...

Why not do this in one step? Select the rows you want from the 80M,...

No kidding. What Paul's modestly neglected to mention is the 5-fold performance lift provided by removing the table spool from the...

Sorry about delay. Results from home lappy, specs posted earlier:

/* maxmem 3072:

Table 'StockMovements'. Scan count 1, logical reads 30947106, physical reads 7, read-ahead reads 70, lob logical reads 0, lob...