I have to agree with Gail (GilaMonster) here, as all too often, companies operating a 24x7 website "buy in" to the idea that you can just keep everything going 24x7...

Just to provide a syntactically correct set of T-SQL:

SELECT QUESTION_ID, POSSIBLE_ANSWERS, PARENT,

CASE

...

bendaia,

You have to first tie a control on your report to a specific dataset, as otherwise, only aggregate functions for a given dataset are available in Reporting Services. ...

UPDATE:

I called Microsoft on the driver problem last night, and all they could suggest was to try a different drive. I have one on order, so I...

You might also want to investigate the SQL Server Migration Assistant, which is available free from the Microsoft website. Investigate ALL the options before migration, but it makes...

As CLR should in most cases just not be necessary, one way to help with it's memory usage would be to ensure it's only used for scalar functionality, which means...

Just out of curiousity, could the sproc "store" the current state in a table somewhere, with enough detail to avoid having to leave the transaction open, such that subsequent calls...

The ability to use more RAM has more to do with the operating system, as 32-bit versions of Windows Server products cannot allocate more than 2 GB to any one...

Well, I WAS planning to get Vista Ultimate 64-bit installed... now I seem to be stuck trying to find a device driver for my optical drive, a Panasonic LF-PB271...

Thanks very much for that info, as I'm hoping to start my Vista x64 build this evening on an 8GB Quad-Core machine, and then I'll be looking to put both...

Dynamically adding another matrix control isn't possible. What you need is a way to bring all the log table data into a common field structure, with the log...

Jeff,

I don't think you're quite taking into account the entire scope of the problem. This is most likely for an online website where people are going to be...

Here's some code that you could adapt to your circumstances, although without more details, I can't determine the performance in your situation.

DECLARE @data TABLE(

RN int,

ALLRN int,

DATAVALUE int,

DATAGROUP char(1),

MINROW int,

MAXROW int,

HALFDIFFLOW...

Well, you still haven't mentioned how often this process has to take place. After all, if you do this only once a month, then a large number of...

Ok, I understand more about the background, but I don't really see anything that tells me the ultimate objective. This new info actually raises more questions than it...