What Sacheen said is true, but, this error is on the report server, not the sql server, so I'd be more interested to hear more about the report server itself....

Yes, focus on making the stored proc use set-based commands rather than iterating through a result set using cursors. the database can handle data in sets much more efficiently than...

Is the field "email id" actually the column that...

Thats a great question for a sales rep, and a careful reading of the EULA; unless there is a Microsoft sales rep floating around on the forums I wouldn't rely...

Its really hard to tell the final product you are after given the information you provided, but you may be interested in reading up on the PIVOT syntax -

Yea, I dont think the "Allow Null" tick box shows up when you pull the parameters from a dataset, if I remember right. Anyhew, Yes try wording your dataset query...

You could create a temp table in the "outer" proc, and then have the "inner" proc ( the one called by the outer) insert into it. Since the inner proc...

Awesome! Thanks!

in 2008 (at least in mine), i have the domain name and spid in both the tab title and at the bottom info bar... are you saying that the bottom...

Doug Lane (10/11/2010)

---

Does the query return the date range as a column, for example "1/7 to 1/13" or does it simply pass the date and have RS do the grouping?...

looks like you are subtracting 2 weeks from today's date, not 2 days. try dateadd("d", -2, today()).

Well, in both cases the transaction gets rolled back. Kill would be better than restarting the entire sql server though... restarting the sql server seems kinda pointless to me in...

do you have a screenshot or something of what you are talking about? Not quite sure what you are after.

Is ct.name the companyname you wanted listed on the vertical axis?

So in the sql statement id group on ct.name, and a function like this - DATEADD(day, -1* Datepart(dw, GETDATE())...

Do you have an example url that won't process correctly that you can post so we can see what you are talking about?