@JLS

Thanks but I needed to be more precise over the ordering than just using date.

@chrism-2

Genius!

Definately is giving me the right results for the #tmp sample data set....

@lowell Good effort but not quite.

Your results set picks up the recod with a time stamp of 41287 which is the first in a pair.

@chrism-2

Same answer...

@lowell,

Thats the challenge, when you use LEFT OUTER JOIN, seq#3 will join to both seq#2 and seq#4

In theory you have to traverse the entire tree to find out...

Clark,

Welcome to the board. Please google for set theory. Basically, in all RDBMS a group of records (a set) has no inherent order: You cannot guarantee that the...

The blank lines may be because it starts the insert from the end of the Excel file. Although there was no data in the excel file, the xlCellTypeLastUsedCell property...

Do you need to set up a ODBC DSN on the machine. My experience is with Progress rather than Teradata but I think it is the same for most...

To clarify what I think you are saying.

SSIS Master package runs execute SQLAgent task.

The constraint for this is satisfied when the task starts, not when it ends (which...

Which is sort of annoying!

It means that home developers and/or people trying to 'break in' to SQL development have a huge barrier to entry. I understand why Microsoft do...

annoying isnt it!

I use 2005 and sometimes have the same problems, especially if the design surface has been extended beyond it's current dimensions. Any new tasks added end off...

+1 for the File Wather on SQLIS. We use it all over the place. The 2005 version does not have a pretty config interface but still gets the...

please share

interface error between the chair and keyboard :w00t:

how about "Mr, Generator Van De Graf"?

or

"Rt Hon Wg Cdr Rev Dr Michael Jones III" (He is a member of the UK House of Commons, a decomissioned Wing...

Try this. It will generate two columns which give you a group (x) and a row in the group (q)

I have based it on an autoincrementing field, but you...

I use ID fields to provide me with an absolutely unique (to the table) value that can be used as the Foriegn key to other tables. Its value has...