With 550 columns it's not possible to test every combination of 2 or more columns to see if they are unique. It's a combinatorial problem with a search space...

Yea right, it's super precise so it's...

If the number of candidate columns is small you could exhaustively test the possible combinations using a cursor and dynamic sql.

It seems like you're talking about two things here. Not sure what temporal tables have to do with the tokens. Usually you are hashing somehow to create this token...

Suppose you have 3 people and each has...

What Jeff wrote is enough to scare me away from even trying this approach.  Using internal locking could enable end-users to do things which produce unpredictable performance.  You wrote "users...

When there no uncommitted transactions do the EMpbasetable and  EmpIncTable have the same number of rows?

Here's a similar way that's maybe simpler.

with x_cte as (
select
  *,
  row_number() over (partition by recid order by docdate desc) row_num 
from 
  #tmptbl
where
...

Here is another option:

   With groupedDates
     As (
 Select t.recid
      , t.docdate
   ...

declare
  @docdatedate='2019-08-09';

with
range_cte(recid, docdate, nxt_dt, nxt_dt_diff) as (
select
  t.*,
  lead(t.docdate, 1) over (partition by recid order by docdate desc) nxt_dt,
  datediff(dd, lead(t.docdate, 1) over...

• This reply was modified 5 years, 10 months ago by Steve Collins. Reason: added sorted by recid, docdate descending
• This reply was modified 5 years, 10 months ago by Steve Collins. Reason: Wasn't giving the correct output in some cases

Ok issue is the initial nxt_dt_diff is not equal to 1.  Or the code doesn't handle that properly now.  I'll update it.

drop table if exists #tmptbl;
go
create table #tmptbl(
  recidint,
  docdatedate,
  constraint unq_tmptbl_recid_dt unique(recid, docdate));
go

insert into #tmptbl values 
(1, '11/16/19'),(1, '11/15/19'),(1, '11/14/19'),(1, '11/13/19'),(1, '10/29/19'),(1, '10/27/19'),
(1, '10/26/19'),(2,...

• This reply was modified 5 years, 10 months ago by Steve Collins. Reason: Got rid of unnecessary declared variable
• This reply was modified 5 years, 10 months ago by Steve Collins.

The two CTE's could be consolidated into one.

with
avg_cte as (
select
  t1.PID,
  t1.SID,
  avg(isnull(t1.TValue/T2.BPrice, 0)) avg_volume
from
  #tblData1 t1
 join
  #tblData2 t2 on t1.SID=t2.SID
...

• This reply was modified 5 years, 10 months ago by Steve Collins. Reason: fixed typo in code

The weighted average price is still the price.  Are you looking for average volumes?  Unique constraints on (SID, PID) to tables t2 and t3 are valid for your situation?  Assuming...

The article says: "The typical usage of collections is a multi-valued argument for functions and procedures."  True but other solutions exist and are quite useful in comparison to a spatial...