I am new to SQL, So can you help me .

We have Primary Key in Both source and target tables but how only this field help to identify the changes ?

Please help to my post

Can anyone help to my previous post

-- column KeyProductControlDisplay is Primary Key where as KeyProductControlDisplayParent tells the parent

-- Step 1 : Foreach group of Parent and Child Records I need to compare Child FormOrder column...

Output of new sample data should be

CREATE TABLE [dbo].[xyzabc12](

[KeyProductControlDisplay] [int] NOT NULL,

[KeyProductControlDisplayParent] [int] NULL,

[FOrmOrder] [nvarchar](85) NULL

) ON [PRIMARY]

GO

INSERT [dbo].[xyzabc12] ([KeyProductControlDisplay], [KeyProductControlDisplayParent], [FOrmOrder]) VALUES (526, NULL, N'All Deal...

but why this is not working if we have many values in the table

CREATE TABLE [dbo].[xyzabc11](

[KeyProductControlDisplay] [int] NOT NULL,

[KeyProductControlDisplayParent] [int] NULL,

[FOrmOrder] [nvarchar](85) NULL

) ON [PRIMARY]

GO

INSERT [dbo].[xyzabc11] ([KeyProductControlDisplay],...

I have mentioned detailed explanation about the requirement

1. AS i mentioned previously we have to build the output result(Outputtest1) set based on inputtest1 and inputtest2

2. inputtest1 this result set contains...

declare @startdate datetime = '2015-03-31 23:59:59.097';

declare @enddate datetime = '2015-04-01 00:00:00.000';

returns 2

Awesome simplified solution with SELECT DATEDIFF(Year, @startdate, @enddate) + 1 AS QUARTER_DIFFERENCE

some of the thing s looks really complicated to me using TOP 110001 and also using sys.all_columns table, do you suggest any alternative simple approach, because my lead asking...

I just want the difference count. i am not sure why you are returning all data

even after creating clustered or non clustered it is not giving considerable performance gain, So is there any possible solution to rewire the same query without changes the output.

Any one can you please respond with solution

Cast and ROUND functions are not working for the Dynamically created PIVOT COlumns

Yes that is Really Working.

But i need to do additional join with deliveries to get few more records as mentioned in my post.