Have you got the table structure and maybe some test data that we could play with ?

Ok I see what you want now

Create a copy of the table with the identity field set

Copy all of the data across from the old table

Drop the foreign...

Unfortunately Matt that wouldn't work - cos when you add the extra days you may go over another holiday and or weekend

Another flaw with this solution is it doesn't handle adding a negative number of days which is just as important in my eyes

The foreign key won't make any difference

Just go into management studio into the table design and set the Identity Specification and it should work just fine

I did this without a loop using a recursive function just take the start date add the number of work days that you want and then count how many non...

SQL Compare form Redgate is very easy to use and will generate whatever scripts you want to align the 2 databases - If i remember right though it's not cheap...

I think that a lot of us would like just that

Unfortunately as far as i know there is no way of doing this without using Profiler

Or obviously if you wanted to reverse the data so top level name first you could use

WITH CTE AS (

SELECT id,name,parent_id, 1 AS Level, CAST(name AS VARCHAR(MAX)) AS FullPath

FROM...

Sorry used the tab key

Like

Fred John, Bert, Andy

Bert ...

So you basically want a list of who person a manages all nicely concatenated together like

Fred

It might be worth looking at one of Kalen Delaney's books on SQL Server Internals - Just running Profiler won't (I believe) give you the information that you need

The database wouldn't be in a position for you to restore any other way other than from scratch

We need much more info to answer this question. Where is the temp table created, structure etc

Cheers

Andy