You should be able to declare a @Variable and pass it into your recordset using the following: 

SELECT DATENAME( month, GETDATE()) + ', ' + DATENAME( year, GETDATE()) 

If you...

Probably most of it.  But I had to PM Frank 'cause I did not understand how modulo was working...  I am sure we used the same if not similar code...

I got this from Frank Kalis, (and because I am so thick headed he had to explain it to me more than once...).  It is a VERY slick way to...

It sounds like a scope issue.  I am not sure how this would work, but: 

BEGIN TRANSACTION A

     BEGIN TRANSACTION B

          DO SP C... (three iterations and then...

Salvatore,

We are at a real loss here until you can tell how these tables relate each other and just exactly how the dates matter. 

We probably won't search this down since we can get what need by going around the barn and this is not run on a regular basis.  But it was odd,...

Nah!  Her's are actually useful.   

I saw that, but I figured Bendan had all the information needed... Just kind'a talkin'..., I was....

Thanks Remi.  That's what I was trying to get at. 

This was VERY good to learn about BETWEEN.  Thanks all. 

I thought that too.  That would be a great citing to see.  Thanks Du Bois!   

Why are you converting your @DateFrom and @DateTo values?  Will this capture record one if you do not convert those? 

If you are converting them because the SP has the...

Go to the search page and type in "Cross Tab".  You will get more hits than I could post... 

Thank you!  This is not actually my query, but since I had this forum available to me I told them I would help.  The error, (I only got today) is...

Remi is right.  Plus, it has been a long time since I had to force an index (I think it was 6.5).  I will look, but it will take me...

Have you tried forcing the use of any of the Indexes?