Client want read/write access to all authenticated domain users on table in database .

Explain to them the potential problems with complying with such a request. There are good reasons...

If these are columns in your query...

[Ship To Dealer],[Car Line],Status,Count

SELECT [Ship To Dealer],[Car Line],[Status] As BadReservedWord, COUNT(*) AS LineCount

FROM MyTable

ORDER BY [Ship To Dealer],[Car Line],[Status]

GROUP BY [Ship To Dealer],[Car Line],[Status]

Post enough information so that people can help you.

1. Table definitions (right-click, script CREATE TABLE... to clipboard)... paste here.

2. Some data (a few records - enough so we know what...

Can't you go into SQL Server and create a job to run a bunch of them in sequence? Then schedule them using the Job?

Could you use Soundex for this? And any comparison that has a score within an "acceptable" range (open to interpretation) would automatically update. You could probably do most/all...

subclass? One table for Square, one for Circle. Get the entity ID from the parent table?

You can't create linked servers and do the union in your stored procedure?

I'm getting smarter finally!!!

Took long enough!

You might be able to use JOIN() in SSRS, but Sean's right... more details, please!!!

If you want a good answer, ask a good question! (enough details so we can reproduce...

Maybe someone more knowledgeable than I will chime in, but what if you did this with a cursor and scheduled it as a job? (so it runs in off hours)....

only thing i can think of is to do the iffy one inside a TRY/CATCH block and trap for the table not being available (if you can). Then use...

bad form. just post it.

the more eyes on your problem, the faster you get an answer.

http://technet.microsoft.com/en-us/library/ms190307.aspx

look up "sp_send_dbmail" in BOL, or read the article...

You mean you can't run as another user?

If you're an admin, surely you can create a dummy user, connect to the database as that user, and then run whatever code...

Any reason you're storing a number (a date) in an NVARCHAR field? If you can fix that, then the problem would go away.

Did you try casting the value as...