Well you can have as many WHEN statements in a CASE as needed and you CAN nest CASE statements. This can get ugly and hard to maintain so you...

What does SELECT @@LANGUAGE return? Date Formats are set based on the server's language setting.

Can you share the actual offending code? The table definitions would help as well.

You have to use CASE in a select or update statement. I think what you want is something like this:

Update

tbl_UL

Set WR = vtbl_Combined.BW

From

...

This is a bit simpler and uses the newer objects in the SYS schema:

SELECT

SM.definition

FROM

sys.triggers AS T JOIN

sys.sql_modules AS...

There's no way I know of to do this in T-SQL as least not easily. I think it can be done using PowerShell. You should check out the...

I have this one in my office, and unfortunately the the second part is way to accurate for my office.

http://www.despair.com/ignorance.html

I'd agree that SSIS is probably the best way to go, depending on what the processing is that you need to do. Are all the databases on the same...

The easiest way to do this is to use something like SQL DataCompare.

The only way to do this without resorting to some type of dynamic SQL is something like this:

Select

...

So you only want to create the delete statements from the SSIS package?

Why not do the delete within the SSIS package? You can do an Execute SQL...

Can you post the table structures, including indexes?

It looks like the issue with the "slow" plan is because it is doing a NESTED LOOPS join.

I definitely think indexes can fix...

I believe, that because you are accessing other databases, you need to sign the procedure with a certificate. I don't think EXECUTE AS will work. See this article...

rushi.reddy (9/22/2010)

---

Hi Jacks,

Thnx a lot, the link of Glenn Berry's u have given is really useful for me. Can you please send me the same for sql server 2000...

CirquedeSQLeil (9/21/2010)

---

don't even need to go...

That script returns any dropped objects. The ObjectType column tells you what type of object was dropped.

No, the database does not need to be in the Full...

ricardo_chicas (9/21/2010)

---

Actually I didn't post that info on purpose, I just wanted to show a case where the best practices aren't the bes, and the question at the final part...