sorry db has gone from 2000 to 2005 so no justification is needed. All I want is to insure that as a DBA I am making the most of the...

ALZDBA (7/14/2009)

---

set identity_insert is at session level !

So it will only be active with your session for your session !

Why are you trying to fill the gaps ?

Are you reaching...

HI Lamprey,

Sorry thanks for your help too.

Many thanks

HI Wayne,

Thats great that eactly it!! Thanks so much in future I will post a sample.

Many thanks

Its only a theory it should be applicable to things which match the condition

1 the cursor selects only distinct ID's

2 each steps it selects from a different table using that...

Hi thanks for that but I only want the oldest record for each ID. That is why I am using the cursor. get all the disinct IDs from table...

hi Its okay, i have used a temp table instead. Thanks for the help you got me going on the right track.

declare @DateTime datetime

declare @tablename varchar(100)

declare @sql varchar(8000)

create...

I get the following error

EXECUTE cannot be used as a source when inserting into a table variable.

Great help people. Many thanks

great many thanks

Erm you might want to copy and paste to notepad

|--Filter(WHERE:(([prvsp].[PROCA_REFNO]=202052 AND [prvsp].[DISCH_DTTM]<>NULL) AND isnull([prvsp].[ARCHV_FLAG], 'N')='N'))

...

No large data updates, Also the query runs in under a second when they exuction plan has been worked out.

Many thanks extremely helpful

Thank you so much