Try the following and see if it works for you:

declare @suppgroup varchar(50)

declare @suppgroups table(

suppnumber int PRIMARY KEY IDENTITY(1,1),

suppgroup varchar(50)

)

insert into @suppgroups (suppgroup)

select distinct suppgroup

from dbo.opencall

SELECT DISTINCT U.email, O.suppgroup

FROM dbo.userdb AS...

Yes, you need to have one single result set. What gets sent to each recipient can be controlled by virtue of being able to supply a unique set...

UPDATE and SOLUTION:

I did all kinds of things in trying to get where I needed to be, and it may have been a combination of multiple things. Here...

UPDATE: I've discovered that my report file (*.rdlc) had no connection string or data provider, and it was likely because I chose SQL Native Client, not thinking about...

Andrew,

Can you explain what reasons would be good reasons to choose to publish SQL Server info to AD? I'm relatively new to the administrative pieces of SQL...

Thanks Steve... I was going to try anonymous authentication last night, but later in my workday yesterday I happened across a way to make a report be all...

I'll try allowing an anonymous connection tonight just to see if that works, but I need to learn how to NOT have such things available, as could be expected were...

I guess I should have added a few of the caveats we had recognized...

Tivoli most certainly wasn't perfect, and I can recall getting more than 1 off-hours call at oh-god...

Just a few thoughts from my time at a large insurance company...

We never used any "self-monitoring" for a SQL Server instance, as that would always rely to some degree on...

Calculating the difference in hours, and then expecting to find a value for minutes and seconds isn't realistic, as DATEDIFF doesn't return non-integer values. Calculate the difference in...

I ended up having a different problem that caused me to have to reinstall the entire operating system twice, but once I got past THAT problem, I discovered that MS...

Assumptions, assumptions... Why would you bother with a rename option if you were going to delete the file at the same time? It's a really simple...

Ok, I've found SX.exe, which can at least output well-formed XML. Unfortunately, trying to import it's resultant XML is still a problem, as while all the tags are...

BUMP...

No one has ever imported a Quicken QFX file into SQL Server? I did manage to find a database program for MAC OS X that will import such...

On the basis of your stated usage of the numbers being generated, I'd then be motivated to interpolate. I'd also generate the number of missing values as a...