I made a mistake, it is in the ON statement that must be conditional, and only on that one field. The data is too messy to get a good...

Actually I think I just found a solution, thank you vary much!

ah yes it does, that is because it is a time variable as one of the PK

it is stored in our system as 2011-05-16 11:50:29.000 (down to the second,...

I hope i did that correctly 🙂

OK so here are tables and sample data

Parts:

/****** Object: Table [dbo].[Parts] Script Date: 10/21/2013 15:10:45 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Parts](

[PartNo] [varchar](50) NOT...

when trying to export my test data, I am using the procedures from your signiture line, yet i am recieving some of the values as null, instead of the select...

thank you, i will create those test tables now