if object_id('Tempdb..#temp') > 0

DROP TABLE #temp

GO

Create table #temp

(

id int not null identity (1,1) primary key clustered,

SSN CHAR(9) not null

)

GO

Insert into #temp (ssn) values ('123456789')

Insert into #temp (ssn) values ('987654321')

Insert into...

Well you can create a temp table with identity instead of the current id column, set identity_insert on for that table, ship all your current data to this table,...

update the whole table for the field id = 20 or the field id = 20 and is in this query?

I wish I knew...

remove , DateCol and ,@DateCol

You know how to do an insert statement right??

hmm not exactly,

(assuming you're gonna create a stored proc to do the insert) :

Insert into dbo.YourTable (Col1, Col2, DateCol, DateBefore, DateAfter) values (@Col1, @Col2, DateCol, dateadd(m, -6, Datefield), dateadd(m,...

See my other answer in the other thread.

I've given you what I found... But I don't see how this can be done in vba. I suspect it can be...

Yup, there it is :

DECLARE @Temp TABLE

(RowId int NOT NULL IDENTITY(1, 1),

Col1 varchar(20) NULL,

PRIMARY KEY...

yes :

StmtText ...

earlier : dateadd(m, -6, DateField)

later : dateadd(m, 6, DateField)

I'd just copy the statement, or make it into a view and use it in both sps.... there's just no need for a temp table in this case, the statement...

the where seems to force and index seek (removing a scan.. which is probabely the longest operation of the query).

However I can't really be sure without the relative cost to...

Just don't start another one .

Why can't you use a select to do this already?

It doesn't guarantee that you will catch all the databases in use.