Have you tried this?  If you import a text file using DTS there is a field called 'Text Qualifier' - set this to be " (the default) and DTS will...

First of all - if you have a long message, I suggest that you type it in Notepad or Word first, to avoid the time-out that you experienced (we've all...

Getting weirder.  Have you tried backing up the db and restoring it as another db, then running the query on that?  If that fails, try restoring onto a different SQL...

So the sad face wasn't part of the plan then?

When things like this start happening, you start suspecting the integrity and consistency of...

"How would I get the next to last date from the Dates Table? (Would the Top Function work?) "

select max(date) from dates where date < (select max(d1.date) from dates d1)

It will be something to do with the structure of the tables and the way that you have joined them - there will probably be a many-to-many relationship somewhere that...

This grim-looking piece of code should get you heading in the right direction!

select id, col1, col2, col3, rtrim(left(col4, charindex('Departure',Col4)-1))  [Desc]

from table

union

select id, '', '', '', ltrim(right(col4, len(col4) - charindex('Departure',Col4)+2))

from table

order...

I can think of a query that will give you this, but it would depend on the display of the primary key in the table (for sorting - to keep the...

Aah!  So you are trying to detect series of consecutive numbers that do not contain gaps?

So you want output like this:

Min   Max   Count

107   112    6

?

So you want the min, max and count, subject to a filter on the data that is being analysed?  Like this?

select count(field), min(field), max(field) from table where field between 107...

If you always know the first few letters, you could try left(column,2) = 'aa' instead of like 'aa%'.  An index on the column that you are searching will also help...

I suggest that you use a reporting tool (Access, Crystal etc) to achieve this sort of formatting.  What are you going to do with the output?

Regards

I agree - DTS is the way to go.  Why make things harder for yourself??

Difficult to tell from the way that the stuff's been formatted for display.  What is the field delimiter (ie which character appears between the fields and nowhere else)?

I've had a quick look, but can't find where this alias is appearing - please direct me to it!

Phil