Stefan Krzywicki (1/26/2012)

---

Brandie Tarvin (1/26/2012)

---

GilaMonster (1/26/2012)

---

Brandie Tarvin (1/26/2012)

---

GilaMonster (1/26/2012)

---

I've had that. It was followed by almost R10 000...

Don't you just hate it when a simple solution is staring you in the face and...

GSquared (1/25/2012)

---

jcrawf02 (1/25/2012)

---

Steve Jones - SSC Editor (1/25/2012)

---

SQL Kiwi (1/24/2012)

---

I tried snowboarding once (in a supervised inside environment[/url]) and that was enough...

SQLKnowItAll (1/19/2012)

---

The best way to do this is to fully qualify the table when you reference it in the stored proc. So databasename.schema.tablename or databasename..tablename if it is the...

Gianluca Sartori (1/16/2012)

---

Chad Crawford (1/16/2012)

---

I guess I should find it amusing...

... but my...

The problem was resolved, but I never got an answer to as to what was done. No longer with this employer so not sure if they would even remember...

SQL Kiwi (1/14/2012)

---

Lynn Pettis (1/14/2012)

---

You might want to drop the count to > 1 as there may only be two duplicate rows. The example provided in the original post...

ChrisM@home (1/14/2012)

---

Blimey! First post, and you've set up a ton of sample data! Top work!

I think this is what you're looking for:

SELECT

Date,

Price,

AskClient,

Dupes = COUNT(*)

FROM #trading

GROUP...

Have you looked up ALTER PARTITION SCHEME and ALTER PARTITION FUNCTION in Books Online?

I have to agree with codebyo, if this is a system table in Oracle, it doesn't exist in SQL Server (at least not with this name).

Could you explain what it...

Please do not cross post. You already have a thread started for this issue here, please continue using it while working the problem.

Please do not post responses on this...

Looks like some additional information may be provided here.

Please continue posting responses on this thread to keep everything together.

Just checking to see how things are going with this issue. Any updates?

Congrats Lowell!

There are two ways to write this as a function, as a scalar function or an inline table valued function. You may actually want it both ways. One...