Correct, I'm well aware of the problem with @@identity, in fact I was 'stung' by it at the last place.  Andy is right, the Scope_Identity is better, as Ident_current('tbl')...

/*

Excellent.  I tried to go back to the source tables as they always contain the 

latest record, but that goes against the grain of what we are trying to do.  

Your sugestion is spot on, and once again I learn something new. 

I followed BOLs advice and used the rowversion synonym, which until now I'd never heard of.

Cheers!

Dave J

*/

----------------------------------------------------

--table definition

IF OBJECT_ID('Tick_info_history') > 0

  DROP TABLE TICK_INFO_HISTORY

GO

CREATE TABLE TICK_INFO_HISTORY (

  TICKET_TXN_ID      INT  NOT NULL,...

I don't know ADO but I'd bet its a place holder. Look at this line

adoParameter.Value = vWhereValues.Items(queryParameterCount - 1)

That sets the value of the ? with whatever vWhereValues.Items(queryParameterCount -...

Is this from a DTS Package?  If so, it's a place holder for a parameter.

HTH

Dave J

I seem to post this a lot

Look at this thread, I had a very similar problem, which was soon worked out.

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

HTH

Dave J

I don't doubt it, but I did use a smiley

Dave J

The way I do it is

select Left(GetDate(),11)

simply because it's less typing

Dave J

Good catch Jeff.

Sorry Shane, I should have said "look *in* Books Online"

Dave J

Look at the topic "expanding hierarchies" on Books on Line.  I have adapted this to my particular problem myself and it works well.

HTH

Dave J

Hello Sergiy

As for me there is nothing good in not having education essential for the job.

...

I hope you not gonna let this situation stay for long. Best luck to you...

US Ascent training?  Do you mean US Accent training?  And if you do, that's bizzare!

Happy Independance day you backstabbers.