Like Rule is When first  cyclic references happen stop on that place.

Like

45218547  --> 54044082 --> 64349595 --> 59741694 -->54044082 so his parecnt_cif is ultimate parent 64349595

54044082 --> 64349595 --> 59741694...

That's my question. how i can insert into #SummaryTable. I want to insert row into summary table with SourceQueryRowCount, TargetQueryRowCount and DataDiffTotalCount and insert into summary table. As result are...

For all its same result for that reason I just give me and in query i just want to show i try with these options. As we are upgrading from...

one issue its create the role but not grant the permission like I create ROLE SP_EXECUTE and grant execute permission to this role. 

When I use this script...

Issue is DE not always "A","B","C"

Different values

thanks!

Issue with this approach is I have big data set and some time I have two type of Name like (LN, LT) and some time 3 (LN, LT, LC) and...

Thanks I hope its work in my condition.

like I'm validating before calling these function so for that reason I don't think so its invalid or null.

Thanks

Yes, I update #md table and its better now.

Thanks

I tried this and its work but its taking little bit time if there is no other way or best approach then I can use this one.

select a.* from #LD...