Thanks Jeff

I like it and will give it a try and also look into the full text search feature.

Bill

Thanks Jeff

Sleep well

Bill

Hi Jeff

I didn't think about using DTS, how dumb of me. So, I didn't see an easy way to just give some of the columns, so it's the whole...

Hi Jeff

Give this a try

Bill

Well Jeff, I hope this helps. The SP is going to be called by an ASP program and this is the note that I sent to the programmer.

For similar...

Hi Jeff

Nice to hear from you again. Hope you are taking the time to enjoy summer some.

Looking at the idea at 30,000 feet is to search a book table...

Yup, sure did. I found where to quote and how many to quote to be a pain. What helped the was adding a print @sql to acutally see...

Thanks and for the most part that works. Now I realize the the date in the form of DD/MM/YYYY. So, looking at other posting, I thought that I...

Hi Jeff, I got the Tally table thing worked out from finding on another post of yours. WOW!!!! The data looks great!! Do you ever get...

Hi Jeff:

So, I'm playing with this now and it complains about a "Tally" object. When searching to find out more about this "Tally" object, I'm finding "Karthik, if you...

Hi Jeff:

A lot of fun ideas there!!!! Thank you very very much. Yes SQL 2005 for the question. I'll be working on this in about 2 hours...

I really don't know if this can be accomplished without a program. If I were to write programming specs for this, it would be as follows. I also...

Hi Jeff

Hum, you are right, it's pretty messed up. I'll attach a zip file of the orginal and see if that works.

Thanks

Bill

Thanks Jeff:

The select statement is:

Select reservationID, invoice from reservations

The attached file is eastlake.txt which is a csv

Thanks again for your help

Bill

Hi Jeff:

I know what you are saying and I appreciate it fully. I read the atricle that you suggested and I fully agree. I'm finding it difficult to...