int * int = int

int * float = float

So that's not really a shortcut, but a mathematical truth .

What's wrong with the hardcoded values in my demo script??

There's no first or last row in a table. To get the first something you MUST use order by in combinaison with top 1.

You could also check out the...

I think a simple solution would be to clear the cached plan altogether. That would ensure that all plans be dropped and recreated.

check out DBCC FREEPROCCACHE.

Don't know what you're talking about .

Sorry for the non response.. was out from 5 to 3 last night .

Not gonna let that happen again... untill next wednesday

Check in the top menu (the blue one like in the forums). There's a search option. That one, however more basic, enables you to search the discussions, the...

You could also very well do this in vb... just replace the select with a while Month(date) = me.cboMonth

DECLARE @Sunday AS SMALLDATETIME

DECLARE @Year AS INT

DECLARE @Month AS INT

DECLARE @FirstSunday AS...

Damn, the police got here too late .

Sorry, didn't meant it to come out that way.

Resume -

Avoid cursors like the pest on sql server. SS is built to work with sets and is optimized for...

Can't you just kill that process (assuming it's not vital to sql server)?

Not in a hurry here... Got a job to do and I just know it's gonna happen .

Now that I think of it, I could probably teach my dog to read and fetch that info from me...

Guess which one is faster between the 2?

The dog, by...

I see now... I thaught he was reffering to the other search and I didn't even know that this one existed . ...

The only problem is that you can't see the question before the day it is published .