Use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Estimates differ a lot from actual row counts.

Are your statistics upto date? You have a few query hints to , i would recommend removing those at this stage, unless you...

something like this ?

select * from <your tab> outer apply (Select top(1)

...

Please post DDL and sample data

My initial instinct is to believe that the stored procedure(s) cannot be found.

So really that would only leave that the connection is pointing to another server / database.

You could add...

Here you go

http://tinyurl.com/y8u2z7o

GilaMonster (1/6/2010)

---

Why are there so many 'if you don't help me I'll lose my job' posts all over the place? I just got one by PM. Frankly, seeing that in...

lmu92 (1/5/2010)

---

It seems like...

CirquedeSQLeil (1/4/2010)

---

That comment just reminded me of a movie I watched over the Holidays.

English humor about teeny boppers.[/url] It is more of a chick flick - but has some...

Adi Cohn-120898 (1/5/2010)

---

How do you define drop out of scope? My definition is leaving the code that the variable was declared in because it finished running (either because it...

Please see the CASE statement in BOL (Books on line)

then use MIN(Name) or MAX(Name) , your choice, to return a single 'name',

when you use GROUP BY, all returned columns have to be aggregate functions of contained in the GROUP...

SQLServer doesnt destroy the variable when it drops out of scope, for instance this works

declare @l integer

select @l = 1

while(@l<10) begin

declare @x integer

...

Would i be correct in assuming that this is course/school work ?

What exactly do you mean by 'dynamic' stored procedure ? How does that differ from a normal stored procedure.

Very Zen like, wasnt that a line in Karate Kid II ? 😀