David.Poole (11/12/2010)

---

If you have to build application code to scrub nulls then surely it would have been better not to have them in the first place. Surely allowing nulls...

I threw "Microsoft SharePoint User Group" into Bing, and found a couple that way.

Not sure what you mean.

Something like this?

;WITH CTE (DR, PG, R) AS

(SELECT DateRequested, ProductGroup, DENSE_RANK() OVER (PARTITION BY ProductGroup ORDER BY DateRequested DESC)

FROM dbo.MyTable)

UPDATE ...

SET MyRankColumn = R

FROM ...

INNER JOIN CTE

ON ....DateRequested = CTE.DR

AND...

Do you have a specific question, or are you looking for a contractor to hire, or what?

In that case, you'll probably be better off on an Oracle forum. This site is dedicated mostly to MS SQL.

I'm not familiar with Oracle myself, but you could post...

Greg Edwards-268690 (11/12/2010)

---

Steve Jones - SSC Editor (11/12/2010)

---

GilaMonster (11/12/2010)

---

Not just. I've been getting change requests at about 2 mails per day (multiple...

WayneS (11/12/2010)

---

GSquared (11/12/2010)

---

Dave Ballantyne (11/12/2010)

---

Doesnt this just completely negate any advantage of table vars though ? .

The...

First, are you using Oracle? The "CASCADE CONSTRAINTS PURGE" is an Oracle extension for Drop Table, and isn't part of T-SQL.

If you're using MS SQL Server, you'll need to...

Mick Moses (11/12/2010)

---

I still think it's all "pie in the sky". Whilst there is technology that can handle the individual bits, like parking & keeping a given distance from...

RichardDouglas (11/12/2010)

---

True story this, I was on a business objects in-house training course and the instructor had to go through the needless task of explaining relationships and joins using the...

Dave Ballantyne (11/12/2010)

---

Doesnt this just completely negate any advantage of table vars though ? .

The main reason...

Wasn't presupposing that you'd see anything there. Was asking if you'd tried that. You just did, and it worked as you said it would. I hadn't had...

In the final (outer) query, you can join to the products table and do the count that way. That will give you the number of products per TopCategoryID. ...

You're welcome.