it could be helps you, using MERGE without trigger

If Object_id('tempdb..#Table1') Is Not Null Drop Table #Table1

If Object_id('tempdb..#Table2') Is Not Null drop table #Table2

GO

----- output for a MERGE -----------

declare @OutputTable table(

[Action]...

how to get a first week day start on Monday ignore <Set DateFirst>

----- start week date on Monday

declare @CurrentDate datetime

set @CurrentDate = '2016-07-24'

set datefirst 3

select dateadd(day,case when ((DATEPART(dw, @CurrentDate)...

other way to make progress bar for each 10% only

declare

@max-2 decimal(10,3)

, @CNT decimal(10,3)

, @ProgressBar varchar(250)

, @Percentage int

, @PercentageStep int

set @max-2 = 8745.458

set @CNT = 1.0

set...