Hi for unmathced record will be handle like below syntax

Empkey = isnull(aa.empkey,(select empkey from dimemp where empid=-1)),

deptKey = isnull(bb.deptkey,(select deptkey from dimdept where deptid=-1))

it will work good.

when we go...

Hi its very close to my expected result.we need to handled unmatched empid and deptid related values also

example trantable empid=23 this empid related dimemp table do not have empid=23...

insert statement working fine with merge or with out merge statement.mine s trucked with update statement based conditions .here mainly trantable related transactionid is exist or not in facttran...

Thank you.

Hi Thank you very much. left join logic given good performance also to me.

all most very close to expected result.

I have small doubt in patient table: example :...

outer apply logic already I tested since 7 hours back.that query execution still running.so I mention approximately time .

Hi If I tested records for 1 or 2 patients that time execution taken less time only.when I ran 17 laksh + records to use outer apply that time its...

Hi , as per given status data we consider highest 2,4,3,1 only.here if we found multiple status values for same pn then we need to consider max(sdate).

please...