No problems - I know the feeling.

At the time I thought Erland Sommarskog's post succinctly summed up the issues. I just re-posted it as I have found it to be...

The original question was about identities so I answered it.

I agree that you have to think very carefully before using identity as a Primary Key but quite often one has...

declare @t table(namestr varchar(50) not null)

insert @t

select 'Aardvark, Archie (1)' union all

select 'Baboon, Bob (2)' union all

select 'Chimp, Charlie (3)'

select ltrim(rtrim(left(namestr, commaPos - 1))) as LastName

 ,ltrim(rtrim(substring(namestr, commaPos + 1, bracket1Pos...

Use SCOPE_IDENTITY() after each insert. Something like:

declare @LastID int

insert table1(...) select ...

set @LastID = SCOPE_IDENTITY()

insert table2(Table1ID, ...) select @LastID, ...

set @LastID = SCOPE_IDENTITY()

insert table3(Table2ID, ...) select @LastID, ...

Ryan Randall's solution:

select cast('1 ' + 'February, 2004' as datetime)

On quickly looking at this, there is no join condition between ASP_MASTER and the other tables. This will produce a cartesian product; not at good idea!

You could probably optimise this...

If possible, try and get at least two example dates and values. Maybe 2006-08-09 = 732503 and 2006-08-08 = 732502

You should then be able to work out if it is a...

I have used application locks for this sort of proc. The idea is similar to using a table except everything is in memory. The outline code is:

-- start of proc

exec...

select datename(m, getdate())

Opps...

select ceiling(sum(datediff(minute, tStartTime, tEndTime))/60.0)

from ( select case when tStartTime < @reportStart

  then @reportStart

  else tStartTime

  end as tStartTime

  ,case when (tEndTime > @reportEnd OR tEndTime IS NULL) --!!!!!

  then @reportEnd

  else tEndTime

  end as tEndTime

 from @t

 where tEndTime >...

Answered recently:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=296735

or something like:

declare @t table

(

 nPK int not null

 ,nJobID int not null

 ,tStartTime datetime not null

 ,tEndTime datetime null

 ,lJobOpen bit not null -- is the needed if tEndTime is null?

)

insert @t

select 1, 1,...

When calling the function does explicit casting work?

eg Instead of  t1.seatloc_seat + 1 try cast(cast(t1.seatloc_seat as int) + 1 as nvarchar(50))

create trigger dbo.Assets_tiu

on dbo.Assets

after insert, update

as

set nocount on

-- Assuming table has PK of AssetID

update dbo.Assets

set LastUpdated = getdate()

where dbo.Assets.AssetID in (select I.AssetID from inserted I)

go

Sorry Ryan,

I did not really read the thread and had done something similar with a bitwise date format last week.

Your solution is very elegant.