For posterity : having had a look around and read many (at least 3 possibly 4 ;)) discussions and thinking it through - I'll go for the option of putting...

Thanks very much for the replies! @SteveJones,  thanks for the explanation about how sql server deals with time, that explains a few inconsistencies I observed!

Thanks Thom!
I tried your approach on my actual data set and that seems to work great!
I see you went straight for creating an enddate in the CTE .....

Hi Mark,

thanks for that! that worked quite well.

Cheers,

B

To 'complete' this thread, this is some of the stuff that I've done with it:

- download your gpx files from runkeeper (will be a whole bunch of files, one for...

Thanks a lot Eirikur! This is what I needed.

And I really like your choice of fun! this is exactly the kind of stuff I want to do with it 🙂

B

What about adding 1 column to the small table that would contain RIGHT(smallTable.toid,13), create an index on that and then do your join?

B

TextPad for me ... most favourite of all - reloads on change, allows for searching in multiple files, special characters, HEX display format for binary files, etc etc

In addition to the comment above, you can also have the situation that your sales person is also a customer - what do you do then? this is why you...

A little confused by your post ...

How can SELECT id,item FROM mytable ORDER BY somefield where id = 5

result in:

id Item

1 poor

2 ugly

3 evil

4 bad

5 God

???

did you misss out a...

Hi Jeff,

I read the article after receiving those links and it is very good stuff and would indeed respond to my requirement very well - thank you very much for...

This does do the trick! thanks for that 🙂

I would still love to have a method using SELECT only (i.e. not a SP) that would work regardless of the number...

thanks for that link!

Thinking of it, I do need to get it to work as a single sql SELECT statement as opposed to SP, so I'll have a go on...

Thanks Braindonor - the issue is that I don't have access to a sql server just now so I little stuck when it comes to trying stuff out :crying:

I was...

I guess that SQL refers to the ANSI SQL language.

T-SQL to the Microsoft implementation of that language including the programming aspects.

There's also P/L-SQL which is Oracle's implementation of that same...