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

I'm not sure how you would. PK/FK is basically enforcement of matching values and field types (and sizes) in 2 different tables. That said, I posted the only...

Not sure if I'm missing something, but without table definitions, sample data, and expected results it's hard to tell if I'm right...

use Test2;

GO

CREATE TABLE test (

ID INT,

ParentID INT,

ColX CHAR(7)

);

GO

INSERT INTO...

Not sure if I'm missing something, but without table definitions, sample data, and expected results it's hard to tell if I'm right...

use Test2;

GO

CREATE TABLE test (

ID INT,

ParentID INT,

ColX CHAR(7)

);

GO

INSERT INTO...