You can delete your post if you click the edit button. / then delete

Tag team strikes again .

NP.

select ...

into #T1

from Source

where 1 = 0

--this forces to create the table only without inserting any rows, therefore taking virtually no time and releasing the locks immediatly.

Why do they even do select into??? Can't a straight select be used to present the report?

Assuming that it can't be used, I'd strongly suggest creating a permanent reporting...

You're right... I was assuming a bit column but it could be something else... It's just that = usually works faster that because indexes can be used.

Also should...

How about this for faster solution :

GO

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number] PRIMARY KEY CLUSTERED

(

[PkNumber]

) ON [PRIMARY]

) ON [PRIMARY]

GO

Declare...

oh ok... This is why we usually ask people to send us the real query with real tables. That way our responses work right away.

Good luck with the rest...

Ya but with the gaz costs these days I'd keep it turned off .

You need the syntaxe to do the insert??

Insert into dbo.NewTempTable (Col1, col2...) Select Col1, Col2 from dbo.tempTable1

truncate tempTable1 to empty the main temp table.

Just like a wrestle tag team match... The ring is yours Noeld .

What did you change?

we're both making assumptions and without the code there's no point in continuing this discussion.. I'll wait for his answer before drawing any final conclusion.

It's pretty much the same thing I said. What else do you need to know?

Nah...

For the whole month... so it makes more sens .