I wish i could but this is what i have to work with.

No this probabaly will not work as I am tyring to get all the records at once.i have tried with Rowcount but that doesnot work as the Id is created...

When an insert happens i am trying to get the result as below, so i am trying to copy the records form SomeID 1 into 2 but i want the records...

That does work, thank you so much. Is it possible assign what records are copied on someID so that if there are multiple someID we can change copy records based...

I tried the same insert approach and got a similar error. When the update happens the tables should have 9 records with someId=2 having six records i.e. the existing...

For some reason it doesnot want to store the results in the new table, So i am just getting the results. Thank you for the help.

That worked, thank you for the solution.

Jeff,

It is a UserId field with i.e. userID nvarchar(15). We have to have a unique alphanumeric values for all userID's.

thanks,

From the two time periods on Logdatetime itself

Data

137256931DisplayXXX2015-03-05 12:24:54.000

137257931DisplayXXX2015-03-05 12:43:04.000

137258931DisplayXXX2015-03-05 12:46:13.000

137358931DisplayXXX2015-03-05 15:03:18.000

137435931DisplayXXX2015-03-06 11:28:01.000

137437931DisplayXXX2015-03-06 11:40:48.000

137438931DisplayXXX2015-03-06 11:58:33.000

137441931DisplayXXX2015-03-06 12:01:17.000

137445931DisplayXXX2015-03-06 12:12:24.000

137448931DisplayXXX2015-03-06 12:15:57.000

137454931DisplayXXX2015-03-06 12:17:25.000

155638931DisplayXXX2016-02-17 12:48:40.000

155639931DisplayXXX2016-02-17 12:52:01.000

155640931Save XXX2016-02-17 12:52:50.000

155641931Save ...

/****** Object: Table [dbo].[CustomerArea] Script Date: 2/20/2015 1:59:37 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CustomerArea](

[CustoemerLocationID] [smallint] NULL,

[CustomerAreaID] [smallint] NULL,

[CustomerAreaName] [nvarchar](50) NULL

) ON [PRIMARY]

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE...

not allowed to change the structure, wish i could, A location can have multiple areas, a customer can be associated to only one location and one area. The concept is...

That did not do it

Thanks for the quick response, it is for a database server which is hosted but managed internally as of now, and signs are pointing towards giving full control to an...

I would like a spot if there is still a spot availabl