ALT + E + F + P does wonders. 😛

As far as a SQL approach, here is something we use that you might find helpfull.

1. You'll need a Tally table (we call it dbo.numbers ) ** search this site...

Sorry, one last change...

EXEC [Myserver].db.dbo.DeleteUniqueKeys #DeleteKeys;

Try this instead.....

---- on server B ([Myserver].db)

---- create a table type

CREATE TYPE DeleteKeys AS TABLE

(UniqueKey VARCHAR(10) PRIMARY KEY CLUSTERED)

GO

---- create the procedure to accept the table valued parameter

CREATE...

UniqueKey is not your problem.

Think of it this way. Server A doesn't know anything about Server B's indexes or stats. A proper query plan can not be built because of...

mishrakanchan86 (8/5/2014)

---

Is there anyway to improve performance of below linked query

Delete from [Myserver].db.dbo.z2t where UniqueKey in (Select UniqueKey from #DeleteKeys where CAST(ZipCode AS INT) < 9999 )

This takes more...

I do wish that questions were at least reviewed before being posted.

Questions like this completely invalidate the point system. IMHO 😀

I can't verify, but try this ...

=REPLACE(Fields!Email.Value,"@", vbCrLf & "@")

Thanks for the sample data. Next time (if you would please) try to provide it in a way similar to what I've done. This will, in more complex questions, save...

Wrap your conditions in parenthesis and add an OR

CREATE TABLE CheckConstraintTest

(

CTId INT NOT NULL ,

...

Not saying...

Jack Corbett (7/16/2014)

---

I also think leveraging ROW_NUMBER to get to the most recent status row may be faster. I've seen examples where using row_number instead of MAX...

and another possible approach. ** although without test data I can't be sure. 🙂

I'd also recommend coming up with another way to identify the data_set_nbr. That is what is really...

For those of you that would like a single procedure that doesn't depend upon the Extended Properties and will work for a single table.

Here's what we use:

/****** Object: StoredProcedure...

Read up on STUFF .. http://msdn.microsoft.com/en-us/library/ms188043.aspx