Thanks to both of you. I should get sometime to work on this again today, when I get this I am going to have to remember to write it down...

This is all interesting so far! I would dig having a QA group here, I keep trying to sell the need, so far, no go.

Yeah, I would not...

Thanks! I will have to test out the order by on the bulk insert. As far as the output sort, I am sorting on an int field (Double checked the...

Hi Jack, I am using bulk insert to import the files, and a DTS transform to output to a text file.

The only place I am not using an explicit...

Yes, those do make sense. Definately on a different path of thinking than I was heading down, which is very helpful.

I can work with this thinking. I actually think...

Well, the issue is as this is a front end for roughly 30 standardized reports, which will be all generated with the same criteria set, I have set up a...

Hmm.. I started as a developer, and moved to DB's which I enjoy far more.

For personal satisfaction, I would work on being an author, with more seriousness.

For paying bills......

Jeff, very very true. It is so much more fun to be the squeaking wheel when one is given it as a continuing goal each year. Ahh, all the...

That is great Jeff, yes the data would have a space lower case character, I missed that pattern.

Oh, I so wish the source database was normalized and data corrected....

Thanks, I had also reached the conclusion I would have to have a way to know the entry was a person vs not a person. It occured to me...

That is great code, I am curious if that can be adapted to a mild annoyance I have daily. We have situations where two fields need to be concatenated to...

Will this work for what you are trying to accomplish? This code essentially condenses down span records to one record for each continuously enrolled period, from there it is just...

Are you trying to get 3 different result sets with the queries?

Or

One table with the results from 3 different queries in it?

I have had a similar problem in the past.

We had a developer who using the Enterprise Manager from his machine could not open the DTS, and would generate a...

Thanks Jack!

Good points, I will have to look into the trace idea. I have not had cause yet to learn much about traces, time to learn now.

It is...