foxjazz (3/23/2009)

---

problem with this is the last subquery seems to take forever on the server.

Take a look at the code posted above, and work it as setbased. Should be simple...

There's a DELETE...FROM lurking in here:

SELECT DISTINCT a.ApplicationID, n.PN, p.PartNumber, c.GenCategoryID

FROM ApplicationProduct ap (nolock)

INNER JOIN Application a

ON ap.ApplicationID = a.ApplicationID

INNER JOIN Product p

ON ap.ProductControlID = p.ProductControlID

INNER JOIN...

If you group by salary alone, you're saying "return one row per salary...

mazzz (3/21/2009)

---

Well, the beer festival was much fun (although my head would disagree this morning). I partook in Ale Caesar, Mad March Bear, Black Dog, Dark Brains among others, but...

Hyperdata (3/20/2009)

---

Oddly enough, vitamins! For some reason, I get distracted easily, by the internet & emails(SSC). I forget which of the 10 to 15 things I was...

very funny!

One of my favourites - namewise anyway...

Please provide table creation scripts, some relevant easily-consumed sample data and a table showing your expected output. If you're not sure how to do this, read the link below.

mazzz (3/20/2009)

---

I think the mere...

mazzz (3/20/2009)

---

Leeds-based, so I'm off here this evening: Leeds beer festival[/url] 😀

And...

Yep and if you're London-based it gets better 😎

Derek Dongray (3/20/2009)

---

Lynn Pettis (3/19/2009)

---

Derek Dongray (3/19/2009)

---

Anyway, while I'm willing to offer some 'keyhole' fixes, I don't want to argue over a redesign of someone else's system (especially as they...

Lynn Pettis (3/18/2009)

---

I wrap my entire store procedures in a BEGIN END block, why? It clearly delineates the stored procedure for one. Also, somewhere in another thread, I...

Heh quite possibly - but the count of BEGIN - END pairs goes right down once people...

A separate case for each expression will do the trick:

SET colMask = ISNULL(NULLIF(

CASE WHEN ((b.col3 % 8) /4) >= 1 THEN 'Submit ' ELSE '' END +

CASE WHEN ((b.col3...

In the article which Gail referred you to earlier, this is described as "The Wrong Way to Post Data". Please read the article, it will only take three or four...