Then that sounds really dangerous as the number is going to...

You may find that dynamically generating the AuditNumber to report on using the ROW_NUMBER() function will be best then.

How is this number used in the real world ?

Is it simply...

Heres some simple code to demonstrate an insert select..

Create table #t1

(

col1 char(1)

)

go

insert into #t1 values('A')

insert into #t1 values('B')

insert into #t1 values('C')

insert into #t1 values('D')

go

Create table #t2

(

t2Id integer identity,

col1 char(1)

)

go

insert into...

You have already a date column , if you make that a date/time column does that not serve the same purpose ?

Why is it important to you to have a...

Please post the Create table statement and the Create index statement for the table and indexes involved. I dont want to make incorrect assumptions.

Also, why are you not using...

There is no 'getting round' the issue, you need to ensure that the data you are updating / inserting does not violate the data integrity.

If you were to provide...

Data Driven subscriptions are an enterprise edition feature, so if you cant find the...

Hi , there is no magic wand to be waved here. Updating 2 million Primary Keys (clustered ?) will take a long time and the fact that you are having...

Not on purpose , i can assure you 🙂

A really lousy (and uncool) accident involving washing up a coffee cafetiere.

Thanks for the thoughts guys.

Bugger.

Sliced a nice inch long flap of skin off my thumb this morning.

Typing with one hand is a slow process 🙂

Into the plastic surgery clinic tommorrow

tvantonder-992012 (2/5/2010)

---

thanks for the replies. I did discuss these points with the developer of the report and they are unable to change the way it works. This is a KRONOS...

See this article (and the following discussion)

http://www.sqlservercentral.com/articles/T-SQL/66030/

Use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Could be related to http://support.microsoft.com/kb/973524 ?

As googling for 'usp_DeadlockNotification' revealed this proc which executes xp_readerrorlog. Is that the same as your 'usp_DeadlockNotification' ?

It will depend on your Ansi nulls setting

Consider this

set ansi_nulls on

declare @v-2 integer

select @v-2=null

if(@V=null) begin

select 'Equals'

end

go

set ansi_nulls off

declare @v-2 integer

select @v-2=null

if(@V=null) begin

...