Here's the RAW data:

Doc Number|Document Date|Rec Date|Book|Vol|Page|Doc Type|# of Pages|Related|Grantor|Grantee|Legal|Amount|Image ID

1994-00000001|12/27/1993 12:00:00 AM|01/03/1994|SL|16|33|STATE TAX LIEN|2|:OPR:1169:250|TEXAS STATE OF|KFC NATIONAL MANAGEMENT CO|::::::::::::FOR RELEASE SEE OR VOL 1169 PG 250 2/23/94 ...

I thought I WAS using set-based processing. I"m definitley not using a cursor.....

Pray tell... more feedback on what you're refering to...

BTW... RBAR.... LOL...

It has to be processed record by record due to nested delimiters. The data is being pushed through an SSIS package; however, we discovered that the data provider has...

Amen, GS.... I have to scale this up to about 5-6 tables with an est. million + rows each.... The results are going to be pumped to...

GS, I'm going to move this out of the Forum... I could stand to chat with you... LOL... I'll PM you.

I'm going to remember you guys (and gals) and ChristmaHoniQuanzika..... :crying::-D

GS, that's what I thought. I've seen that in a 2008 shop; however, I'm currently in a 2005 shop that is in mid-migration, thus my afore-mentioned quandry.

Again... My...

@Laurie, Mark, GSquared. I am humbled.

I was starting to lean towards Cross Join; however, I'd never had an opportunity to use it before. Seems like it behaves a...

Laurie,

Thanks for your reply. The "Values" reserved word didn't fly in 2005. Is that a 2008+ term?

Thanks

Crusty

Ok Volunteers... here's your script...

@ Sandeep,

I'm sorry, but I'm not quite sure what it is you're telling me; however, in regards to the data, it's correct. Let me get into some detail.

This is...

I will provide some DDL for the tables in the morning... Thanks for the positive reply... 🙂

I've seen some of the scuttle-butt about his posts... I'm honestly not the caliber of developer to be challenging his answers; however, I don't take them a face value....

I read Pinal periodicly. He's a good source.

I also went to Grant's link in...

Well... I've never interviewed a DBA before. So... I at least want to get pointed in the right direction...