lmu92 (6/15/2010)

There are some...

To answer the question asked, the DateDiff will be more efficient than the convert. You might want to check out the "Common Date/Time Routines" link in my signature.

However, neither...

1. Identify duplicates.

2. For each duplicate, identify which one should be kept.

3. For each other table, update the duplicates with the value being kept.

4. Delete the duplicates.

I'd suggest a backup...

So, based on this, I've come up with:

-- set up and populate a "source" table

IF OBJECT_ID('tempdb..#OriginalData') IS NOT NULL DROP TABLE #OriginalData

CREATE TABLE #OriginalData (CustomerData XML)

insert into #OriginalData

values ('<customer...

Two things frustrate me about SSMS:

1. Intellisense gets in the way to the point I've got it turned off.

2. When working with a dual-monitor system, with SSMS on the secondary...

Fellow Threadizens... any help here would be grately appreciated! I'd really like to know what went wrong, and what to check to ensure that it doesn't happen again!

Steve,

Thanks for the comparison.

Note that I include the in-line tally table so that it will run for folks without a real one. If you have a permanent one, yank out...

See my clarification in bold. Sessions CAN affect GLOBAL temp tables...

Does any of that code...

Once you create a temp table, it is available to any code further down that procedure, and to any procedures that the initial procedure may call after the table has...

You can go back and edit it and make it, well, unmessy.

Miss.Delinda,

This does not update/insert the values into @SysRunno, but it does produce the results that you desire. You would need to dump this into a temp table and update/insert the...

A set-based approach (i.e. getting rid of those while loops) for doing this would be:

declare @Path1 varchar(100), @Path2 varchar(100), @PathLength int

select @Path1 = '\\server1\share1\apath1\abc',

...

Since you're on 2008, and dealing with file system paths, I'm wondering if you can do something with the new hierarchyid data type.

Hmm, I just did something similiar.

The way I did this was to use the BULK INSERT command to put the file into a staging table. I then get the first...