Thanks for the comments guys. And yes, I was testing this using a UNION ALL, not a UNION

We have ~40000 rows so its not too massive.

I completely agree about SQL being for...

Ooo cutting

Well I didn't design it so I can pass the buck there. However I'll stick up for the designer by saying in...

Don't forget...EM will give you the T-SQL that will do this for you. If you dno't mind dropping table...it'll work.

If you want to request to be able to remove an...

I didn't put the smiley in there by the way!!! All I did was copy and paste!!!

Whoops!

Prior to issuing your INSERT statement, issue:

SET IDENTITY_INSERT <table_name> OFF

after your INSERT statement issue:

SET IDENTITY_INSERT <table_name> OFF

This only removes it for the duration of your session (I think).

It can't be...

OK, I've been misinformed then.

Thanks for the info.

Sorry for the digression.

Eralper,

Did you copy that straight out of BOL? I didn't think that syntax would work because it is a CTE and requires a semi-colon after:

SELECT *

FROM OrderedOrders

WHERE RowNumber...

The problem is that 'a.ReadingDate' is grouped in the outer query but not in the correlated sub-query. The correlated sub-query can't join to 'a.ReadingDate' in the outer query...

How is the table ordered? Without knowing this you can't know which are rows n & m.

If you just want all rows between n and m in an unordered set (can't...

Antares,

Exactly right, which is why I stated that we shouldn't be interested in lines of code. Also, I was only really referring to DB objects (which can be gotten from...

Antares,

Thanks again for the reply.

You are correct, the table is in another DB.

Putting the output into a temp table is exactly what I had in mind but I don't know...

OK, I've found the link now. Its: http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us

Now that I can't be entirely sure of but I would expect that you will still be able to do this.

Microsoft's mantra on this is "Never break existing functionality" so...

Ah, I had a feeling someone was going to ask that.

Thanks for the reply Antares but unfortunately my scenario isn't that simple.

Under normal...

Don't worry, there is an Execute Package task in SSIS that will execute DTS2000 packages.

The DTS2000 runtime is shipped with SSIS.