Hello,

Thankyou for the bottom solution, it seems to work well, there are just a few instances were there is still a null start date and null end date. Its turns...

Huge Learning curve...

I have got to start somewhere:

See below:

/****Child Table ****/

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildDetails2]') AND type...

/****Child Table ****/

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildDetails]') AND type in (N'U'))

DROP TABLE [dbo].[ChildDetails]

GO

/****** Object: Table [dbo].[ChildDetails] Script...

/****Child Table ****/

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildDetails]') AND type in (N'U'))

DROP TABLE [dbo].[ChildDetails]

GO

/****** Object: Table [dbo].[ChildDetails] Script...

Yes?!

Cheers

J

Take 3 🙂

/****Child Table ****/

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildDetails]') AND type in (N'U'))

DROP TABLE [dbo].[ChildDetails]

GO

/****** Object: Table...

Hello,

I am sorry for my first post, here is some more detail:

Child Table

USE [LLMigration]

GO

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/

IF EXISTS (SELECT *...