I have attached a spreadsheet that comes out of the machine as a CSV file.

I need to upload this data and then display on the screen.

I have attached an Excel...

So this works great! But now I need to add the constraint, so I started with a simple table

insert into gearmachining

(sMeasurementType,

...

In the second table I don't want duplicates and that is what the trigger does, it looks to see if the data already exists and if it doesn't it adds...

Yes I did learn.

But I have another question now. The gearmachining table I am inserting into has an index on it to create a unique key with

UnitNumber, OperationType, Location, TimeSTamp....

YOU ARE AWESOME! I have only used the Insert function simply that's why I thought you had to assign values.

I changed it so it inserts into my existing table and...

I am running 2005.

This worked great to pivot the data, I am losted how to do the insert.

This is what I have so far:

select

orig.idOP50AGD,

MeasurementType = 'REAL',

cast(orig.OrderNumber as varchar(9)) +...

Yes, yes! Good job, essentially pivot the table (guess I couldn't think of that wording).

What you put is what I started with but I need to put all the columns so it wouldn't be an OR.

This is where I am at:

--//////////////////////////////////////////////////////////

declare @UnitNumber varchar(40)

declare @UnitType...