Because you said it needs to start over at the beginning of each year, I added in more rows for 2011 to test/demonstrate the results of that.

IF OBJECT_ID('tempdb..#Totals') IS NOT...

There are columns with different data, in my results:

user_seeks, user_scans, user_lookups, and user_updates

If you don't want the values you listed to repeat, you need to either exclude the above columns...

Andrew in WV (6/21/2012)

---

ColdCoffee (2/16/2012)

---

THere is something called as Output Parameters while defining a Stored Procedures. Thats what you are looking for .

Here is the link : CREATE PROCEDURE

To...

ChrisM@Work (6/21/2012)

---

jeffem (6/21/2012)

---

... if order of results creates uniqueness (for example, "1 2 3" is distinct from "2 3 1"). If order of results does NOT create uniqueness, then you...

ChrisM@Work (6/21/2012)

---

jeffem (6/21/2012)

---

ChrisM@Work (6/21/2012)

---

David Webb-200187 (6/19/2012)

---

Hmmmm....

Let's say you had 50 rows, all with a quantity of 1. The target quantity was 5.

How would you want that brought back? ...

ChrisM@Work (6/21/2012)

---

David Webb-200187 (6/19/2012)

---

Hmmmm....

Let's say you had 50 rows, all with a quantity of 1. The target quantity was 5.

How would you want that brought back? All the...

In the vein of being pedantic (because that's the only way I can...

Thanks to both of you for the replies!

And for the excellent personal service, I'll get my company to spring for the published version of the book, instead of just...

ChrisM@Work (6/13/2012)

---

Only...

Though the answers have already been shared, it can be useful to have the options for CONVERT() available at your disposal. This link[/url] can be a useful primer...

David Moutray (6/5/2012)

---

An acronym is always unknown to someone. Think of the new guy who might never have heard or seen it before.

Also, Google is fallible. There are...

Ew.

I want to clarify something that misled you here, since you're using CASE statements.

See, the...

adonetok (6/7/2012)

---

Thak you very much.

It works.

Since the date is controled by @CSV I deleted the following statement in @SQL.

AND OrderDate BETWEEN ''' +

...

Try this...

DECLARE @CSV VARCHAR(4000)

DECLARE @SQL VARCHAR(8000)

DECLARE @StartDate DATE

DECLARE @EndDate DATE

SET @StartDate...