Maybe not... since no records were inserted using identity function, doesn't it make sens that the seed didn't change??  I think MS most likely thaught about that which makes me...

Good point... but I think the poster was reffering to some generated code (most likely EM)!

Sorry I didn't express myself well.  I was reffering to ssms which is much slower and doesn't even support all the things EM supported.  But I can't say that 2005...

Thanx for catching this. I didn't know that system procedure .

Ya much better off doing this with DRI / TRIGGER than using a [system]...

So that thread is closed for you??

SELECT * INTO Temp_CurrTable FROM dbo.CurrTable WHERE 1 = 0

INSERT INTO (Col1, Col2) Temp_CurrTable SELECT Col1, Col2 FROM dbo.CurrTable where Week Between 41 and 46 (or use the date column, just...

That sounds like something I would do... but not Steve .

You can't sort the data in the table because tables have no order (this is the base idea of databases)... you can only sort the data in the selects and...

Alright... just keep us posted.  I'm curious to see how you'll solve this one .

I am not the expert on this one so I'll let others handle your request.  You can also search this site for pivot queries.

I just gave you a way.  But I have no idea how to execute it as I've never done it.

You can search for profiler and execution plan as a start. ...

I think you can save the query plan in a trace.  Then save the trace in a table and then search for the operator in question... No idea on how...

No idea of what you want to do.  Can you post the sample result you need from the selects in the inserts?

Can't lose data if you test the solution and have a backup before running the solution .

Also another solution I use to test something...

I see no need to use an intermediate table for this... The task is too simple.