I want to update parent_id of business_table???

this...

Updated. they are same some other columns are having null and data subsequently

Check if there are any filters on Dataset and report itself.

DELETE Top(100000) FROM [dbo].[EncounterSignOff]

FROM [dbo].[User] INNER JOIN [dbo].[EncounterSignOff] ON [User].[UserID] = [EncounterSignOff].[UserId]

WHERE [User].PracticeID = '55';

It works perfectly.

i hv return logic but i m not sure about it

-- Insert duplicate

;with CTE (id,name,age) as

(

Select id,name,age from stage

Intersect

Select id,name,age from master

)

INSERT INTO History

Select id,name,age from cte

-- New record

insert into...

This nested Case is in Select list

Thanks

find simple way

SET @getdate-2 = Convert(Varchar,@getDate,101)+' 01:00:00.000'

Yes i want to fetch data 1 am to 1 Am yesterdays date

Thanks for replay still its taking lot of time. Is there any other way around ?