To a very large extent, DR planning will depend on specific business needs, hardware availability, skillset availability, resources available/obtainable, and SLAs/SLRs.

Virtual machines can be part of a DR plan, but...

Koen Verbeeck (3/8/2011)

---

In the somewhat special case of ETL, I'd sometimes like to turn of logging.

If a data load fails, the destination table can be truncated and the load can...

You're welcome.

It looks to me like what you're looking for is something like this:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

IF OBJECT_ID(N'tempdb..#Rules') IS NOT NULL

...

Try something like this:

select INumber, Name, PortNumber, min(Account) as MinAccount

from MyTable -- put your table name here, obviously

group by INumber, Name, PortNumber;

Depending on the data types, you can either do this with a CTE and Row_Number trick, or with Min() and Group By.

What are the data types of the columns?

Break it down a bit.

First, select the rows where Runout = 1 and Qty = 0, and use Exists to test if there is another row with the same Peg...

I used to work for a company that insisted on long-term planning. Every project had to include data on which strategic initiatives it was meant to forward, before it...

Sean Lange (3/4/2011)

---

Gus, that may have just revolutionized how I handle those types of situations from this point on. I took your example and put together a quick proof of...

Haven't had time to read the whole thing yet, but it looks good so far.

Jeff Moden (3/4/2011)

---

Cool. Thanks, Gus. I'll give it a try and read up on it in BOL but simple examples like the one you provided go a very...

James Goodwin (3/4/2011)

---

Jay,

In your response you are assuming that the bureaucrat's job is to punish you. In truth the bureaucrat (who is, after all, just another office worker like...

Jeff Moden (3/4/2011)

---

If you get the chance, please, I'd love to see the code that you end up with...

Depending on what you're going to do with them, and if you're using SQL 2008 (as per the forum you posted in), you could probably use a single table-variable parameter,...

That will work as posted, but I bet what you're running into is passing a comma-delimited list as a single parameter and doing this kind of thing:

create proc MyProc

(@MyList varchar(100))

as

set...