I'm not sure I understand your requirements. Can you include some data and expected results? If I enter April 22, 2009 (Wednesday) do you want the week to...

Sounds like you need to get Kerberos setup for the double-hop. Check out this article[/url] by K. Brian Kelley. Here is a good blog post by Kendal Van...

krombit,

I have seen this error. I get this error when I run the script in a database where the compatibility level is set to something other than SQL Server...

Nice one Wesley. Certainly truncate will be fast. Of course any indexes will affect the solutions as well.

This is definitely part of the plan. ...

I'm likely paying although my company may chip in some. I'm not counting on it though.

Still on the Summit. Where has everyone stayed when attending? How do you get around? This will be my first Summit and first trip to Seattle.

Can you post some DDL and sample data as suggested in the links in my signature line?

Here's a weak attempt to help:

;With cteDupes AS

(

...

I'd start with the tutorials in BOL.

Ah yes, the hidden code of triggers. I would recommend re-writing the trigger to handle a set based delete properly.

Please post the connection string you are using. Are you doing a desktop application or a web application?

Check out http://www.connectionstrings.com/ for connection string syntax and arguments.

I don't see anything wrong with the delete statement. Is there anything else in your batch?

Alex,

I also want to comment that, while I provided an alternate method, I do appreciate the article and the method it presents. As always "It depends" is the answer.

I would update the rows that exist and insert the ones that don't. Like this:

UPDATE Archive

SET COLUMN_list = T.Column_List

FROM

...

I would think you would want to filter that in your SQL Statement so you are not bring all the data across the wire and then filtering it. I...