I actually was fiddling with this, and came up with:

select DIVISION, (COUNT(DIVISION)) as DIVCOUNT

into #D1A

from #DIVISIONTABLE

group by DIVISION having COUNT(*) > 0

And it worked!

It looks like your solution would work,...

The difference that I find is formatting. Peter's does the up and down output, whereas yours (Jason) is right to left (or left to right, depending). It's all on one...

I'll try this too, to see if will be any easier to figure out, although I DID just figure out the other method (but I think my brain hurts, now,...

So if I do a pass before all of this, into #temp1, for instance, that just has the values for the product dollars in it, how would that relate to...

Maybe I'm NOT being dense. This is pretty hard to follow. I'll try to figure it out.

Thanks

Thanks a lot. That worked.

I was already far down the road of doing this without prompts, so I figured out how to do it, finally. My final approach was to put the variables (as...

This is very good information, thanks. I actually didn't think one could prompt for input in a(n) SP. I will try to figure out how to change the DTS (but...

If the prompting doesn't happen at the point that someone runs the DTS Package manually, then what is the point of setting up global variables at all? The user would...

Maybe I'm confused. I thought that if you run the DTS Package manually, from Enterprise Manager, it should prompt you, but if you run it from dtsrun, and pass variables...

OK, I tried the sample, and here's the error message I get:

Error string: The specified DTS Package ('Name = 'gvTest'; ID.VersionID = {[not specified]}.{[not specified]}')...

Not yet. I've been really busy this morning, but I have a window open with your example in it, so I just need to DO it. I'll post something when...

I had them check, and it has been determined that they are on SP4, so THAT'S not the issue. I have tried just running the package as 'dtsrun /F c:\mailing.dts'...

They have a go live date of 2/3 for this project, and they don't want to rock the boat beforehand, so the guy said that he would probably do any...

I copied the string from dtsrunui, and put the 'answers' to my parameters into it, so any redundancy is what it expected, apparently.

I can try your suggestion, but I think...