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

Ok , Jeff, what's with the throwing of pork chops ??? Is this some unique cultural reference of yours, or have I simply missed something that society has...

From what you've previously posted, you indicated you were going to need to use the snapshot feature. As that will require any filtering already be done, what's the...

Barry,

I wasn't convinced by the examples that your perception of it was necessarily so, which is why I asked, and also why I was looking for more information.

There's always a...

How about a subscription? You can even go "data-driven", to send the same, or even different results, to the users via e-mail.

Steve

(aka smunson)

:):):)

I'm wondering if it's really necessary to have separate tables for each group, because as things change, will there be more groups? Adding a table each time could...

Chris,

You might want to make mention that your function relies on a "tally table" called "Numbers", as the OP here may or may not be familiar with that or with...

Now that I know what a report snapshot is, there's no way to produce it without preconfigured parameters or at least default values for those parameters, and no way to...

What you appear to need to accomplish is the functional equivalent of the following invalid (my assumption) T-SQL code:

EXEC spWhatever @params

INTO #TEMP1

I remember seeing someone ask this question once before,...

If you account for the extra time to perform that update, I suspect there's a net loss in performance, but as I don't quite have a server just yet to...

I'm thinking perhaps the easiest way would be to just connect in from Excel and then do a pivot table on the data returned, so you can just query the...