Check this awesome solution that Jonathan over at msdn helped me with.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/46f26f78-c56f-4e43-b4b2-47ce79b8bfe5

==================================================

CREATE TABLE [dbo].[Sheet2]( [0] [nvarchar](255) NULL, [12] [nvarchar](255) NULL,

[24] [nvarchar](255) NULL, [28] [nvarchar](255) NULL,...

Here is my first finish product...

Will have to just refine this over time, and maybe people on here will jump in and share their better experiences, but for now this...

Hey Jeff,

Did you have any ideas for me on this one...?

Or another article that will help me?

Thanks

Very nice article.... I can say that I truly got something valuable from that..

I need a little help here..

I need to a way to get that Width Column value into...

What I am doing is creating a table that has one row, and this row contains the WidthTo columns

Then I create a HeightTable and this table contains the all the...

Come to find out the window treatment supplier has this grid in an excel format.. Oh well,, live and learn..

Did I post enough info to loop that table and group...

Hey you guys I have just about got this thing down...

Just need a little more help..

What I am at now is when I scan that document in and import the...

Hey Toni,

Is the w_low, w_hi, h_low, h_hi, for better performance?

Erik

I just downloaded a trial version of ABBYY Fine Reader and that product actually let me scan that grid and place the data into an excel file for me..

From there...

Ok now that I am looking at this ..

I have to remember that the price is computed from the .% in the length width columns. SO my posted schema is...

----Database----------------------------------------------------

USE [master]

GO

/****** Object: Database [Testing] Script Date: 02/16/2009 12:38:19 ******/

CREATE DATABASE [Testing] ON PRIMARY

( NAME = N'Testing', FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Testing.mdf'...

I am making the tables right now....

I will post back shortly...

Thanks

Ok, School session is open..... 😉

select orderid, size, cost, case when size <= basemeasure then cost

...

Thank you Toni...

I would of posted a lot more; however, on this subject it is all blurry to me. On other types of schema like memberships, and simple products...

Yes.....

Now if it is blinds they are priced by width and height, "a grid"

I have attached an example grid that is used by the blind manufacturers and all blind companies...