Kevin,

Thanks so much. This is exactly the type of advice I need right now.

It is very likely that I will be needing some paid consultation on this. If...

Kevin,

I didn't provide report details, because the reports have not yet been designed. We are collecting details on requirements now.

I was looking for general opinions from, hopefully, experienced SQL...

Lamprey3,

Thanks for your reply.

Sharding is a $2.50 word for distributing data into multiple databases based upon some sort of logic that improves reporting performance.

I have been researching SSAS recently and...

Drew,

Thanks. I discovered that I had posted my original message into the wrong forum, but I didn't know how to delete or move it.

Sorry.

BT

Craig,

My deepest apologies for taking so long to review and test your code.

Your code put me really, really close to the desired output.

Thank you so much for taking the time...

Craig,

The quotations in your footer have peaked my interest. Who is Douglas Adams?

BT

Craig,

Thanks so much. I might be a couple of days before I can focus on this, since the week has reset back to Monday.

I scanned through it and I...

Craig,

...the record has a number of other UPCs on lines 83, 85, 89...

I assume your result table is merely a partial result set, or was there something particular

about...

Craig,

As I mentioned in a previous post, this is an older system and, unfortunately, there is no documentation (that I can find) so we are making an educated guess about...

Lowell,

Please see my next couple of posts. I believe I have included everything needed to create the raw and destination tables. You seem to have gotten darn close...

To all -

Now the code to create the destination table.

Thanks so much.

BT

--===================Create the destination table

/****** Object: Table [dbo].[tblDataSymScanDetail] Script Date: 06/03/2011 15:43:27 ******/

IF EXISTS...

To all -

Sorry it took me so long to understand what you were looking for.

Try this - it runs fine in SQL 2008:

/****** Object: Table [dbo].[tblDataSymRawImport] ...

Lowell,

Thanks. I believe you are correct about isolating the UPC number using the '#'. The challenge is in relating (in a single-record layout) the row after each UPC.

Thanks...

Craig,

The data sample included in my post is raw and real.

This is coming from an older, less sophisticated POS system. My company presently extracts data from 9 or 10...

opc.three

Help me out here. I have no DDL or DML. The sample data included in my post was captured from a raw-data/ ASCII file supplied by the point-of-sale...