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...

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...

Hmmm... an interesting problem. My question is, what's the reason behind choosing 10 as the sum, and also, are there any limits on the value of the tickets...

If you're hoping for a tested solution on the basis of what's been provided, you're going to be disappointed. While what you did provide does help clarify...

Interesting... although in cases like that, I'm amazed that anyone thought that a "suggestion" was ever going to do much. Seems to me that simply telling the...

Well there, Seth, he did say "high-speed" pork chops, but I interpreted that as relative to the pork chop, as chances are, the fastest you can "launch" such a thing...

Bump... Any help here, folks? I know that trial by fire can often be very "educational", but I prefer to take learned guidance to heart. ...