More often than you think .

That must be it... that would also explain the size (come on I know you thaught about that one) .

I'm still learning everyday... maybe I have more ram though .

If you need more help, can you send some sample data and the required output so we know what you need?

= You'll be learning for a lifetime... in case you didn't know that just yet.

We don't have that much time Erik .

Nice tease .

This is the metadata of the table... You select data from a temp table just like you would do a regular table.

The new nickname you used for about 1 week when you tried to disappear.

convert the sp to a table function and it'll work.

Seriously Sue... 2 more characters in 13 minutes??? I think I can handle that.

You'll have to do a search engine... there's really no point in loading 1.5M record and expecting the person to read it all to find the match.

Check out http://www.acronymfinder.com

AFAIK means As Far As I Know

That's the proof that peeps don't always read long posts... that's why I overqualify objects sometimes .