If you will run the queries 1, 2 and 4 another day than thanksgiving day it will return another number of days. It's not OK. :hehe:

You should use if..begin..else..end or case..end instead of iif because iif is used only for versions of sql server upper of 2012.

You have a bug in your code here: SET @strend = @strend + ' SET @intloopCounter=@intloopCounter+1 END '

and the variable should be @intLoopCounter, case letters depends. With your code on...

OK, thank you.

Hi Gila,

First time, the stored procedure was built with temp tables and was slowest than with table variables because of IO contention. As I said earlier, with temp tables (#stocfifo)...

Soryy, I forgot to put the exec plan.

Tables and indexes are described in the attachement.

yeah, I know it, but my users want to use excel2007 because of its capacity to store records (much greater than versions 2000-2003 of excel - 32768 rows)

maybe rs2005 has the option to export to excel2007.

yap, each report has a stored procedure or sql statement behind it. you will find it in .rdl file.

and execute on sql server, of course.

I execute the stored procedure behind the report and the result I copy it into Excel2007.

It is all about education. When I was a child, my family's politics was no smoking anyway. My family's friends were selected as non-smokers. I remember that I have an...

Oh, I hate smoking and its effect!! There are many peoples here where I am working who go out of the building and smoke. This is wasting of time....

I am level-headed in all things about health. I am not drinking so much coffee. I am eating vegetables and meat proportionally. And at the dinner I am drinking a...

I just expected that it should be built a new rendering engine for Excel 2007, maybe in RS 2005. This isn't a solution to tell to a bussiness-like people to...