They're also a good way to...

Not confusing for me.  You have existing data and you have new data.  He want's a way to compare the data that changed.

I do absolutely agree that he needs to...

small sample of data, and the output desired.

Row 2 is written as a delta to a new table since acctgrp and channel changed.

Output: Old:display yesterday's record New:display today's record

Just...

My table as a PK(unique) of:

[InvoiceNbr] ASC, [Line] ASC, [SubLine] ASC, [InvoiceDate] ASC, [ShipDate] ASC

The process that creates the file to load to SQL does a FULL refresh of...

There are many ways to display the "Diffs".  Please provide and explicit example of what you'd like to see for your...

I'd prefer to split the file normally, with simple delimiter '|'.

After it's done we can manipulate the resulting data set to shuffle the items into proper slots, defined by...

I'm thinking the OP may have gotten an answer from somewhere else and so may no longer be interest in an answer from this thread and certainly not one where...

Hi Jeff.

your tally table approach to parsing is the best i've seen.   i have a real world problem;  wondering if you have any thoughts.

i need to parse a large...

Exceptionally busy next few days coming, but I did rebuild this morning, set a trace, and did check once to find 0.04% fragmentation - not the usual leap to...

Hello,

I have a code that suppose to give me weekly(summed) payments, but instead, it gives me random points, not (1*7, 2*7,...)

I suspect it maybe because it doesn't include the...

Hi Jeff.

your tally table approach to parsing is the best i've seen.   i have a real world problem;  wondering if you have any thoughts.

i need to parse a large...

There are some caveats to that should've been mentioned.  The string is declared as NVARCHAR(MAX) because I don't know that that's not appropriate.  The ordinal splitter is name '%8K_LEAD'...

Ah, be careful.  He may not be correct here.

Hi Jeff.

your tally table approach to parsing is the best i've seen.   i have a real world problem;  wondering if you have any thoughts.

i need to parse a...

FWIW: This is not a end of the world scenario - this is a rarely used - 1 select every few minutes or so.

I just got curious when I...