Try this:

SELECT d.*, s.MaxUsage

FROM (

SELECT [Application], [1] AS Day1, [2] AS Day2, [3] AS Day3, [4] AS Day4, [5] AS Day5, [6] AS Day6

FROM

(SELECT [Application], [Lastname], Daynr

FROM...

What should happen to a deadline date of 28th February 2010 on 29th January 2010?

Can you please supply some sample data in a readily-consumable format? The...

davidandrews13 (12/4/2009)

---

Lynn Pettis (12/4/2009)

---

Please, when you get a chance, go back and eliminate the cursor. Since there is a set-based solution, you really should use that as it should...

davidandrews13 (12/4/2009)

---

OK. its a bit difficult for me to give some test data for this because the declaring of the temp tables and filling them would have to go into...

GSquared (12/4/2009)

---

I found out late yesterday that the CEO, the President, the Chairman, and the CFO, of the company I work for, all resigned late Wednesday, without prior notice, and...

Hey Grant, sorry I missed your recent trip over here - would have been a...

Top work, David. How about posting your solution for the curious?

mabud_ncc (12/4/2009)

---

table p [prod_id (pk) , name, status]

table o [oid (pk), prod_id(fk), status]

table p2p [p2pid (pk),path_id(fk), prod_id(fk), status]

table pv [path_id(fk), cat_id (fk), step]

table c [cat_id (pk), status,...

Some sample data showing the relationships between the tables would be great. There are a number of ways of structuring this type of query which has different aggregates hanging off...

Replacing the cursor code with this will simplify things for you.

DECLARE @cats varchar(1000)

SELECT @cats = ISNULL(@cats, '') + '[' + cat.catName + '], '

FROM #Categories cat

-- Display ...

Lynn beat me...

BaddaBing (12/3/2009)

---

The problem here is that if you want SQL Server to display that date in this format DD MMM YYYY (20 Dec 2009) then you need to convert it...

DROP TABLE #Guests

CREATE TABLE #Guests(

Firstname varchar(30),

Lastname varchar(30),

Birthdate datetime

)

INSERT INTO #Guests (Firstname,Lastname,Birthdate) VALUES ('Jim','Jones','1961-12-03 01:00:00.000')--Birthday in next 2wks

INSERT INTO #Guests (Firstname,Lastname,Birthdate) VALUES ('Joe','Bloggs','1961-12-03 02:00:00.000')--Birthday in next 2wks

INSERT INTO #Guests (Firstname,Lastname,Birthdate) VALUES...

DROP TABLE #Guests

CREATE TABLE #Guests(

Firstname varchar(30),

Lastname varchar(30),

Birthdate datetime

)

INSERT INTO #Guests (Firstname,Lastname,Birthdate) VALUES ('Jim','Jones','19611203')--Birthday in next 2wks

INSERT INTO #Guests (Firstname,Lastname,Birthdate) VALUES ('Joe','Bloggs','19621210')--Birthday in next 2wks

INSERT INTO #Guests (Firstname,Lastname,Birthdate) VALUES ('Dave','Thomas','19631212')--Birthday in...