If following is as per suggestion, it return all...

No. It return all rows all time.

I have updated description

because if table2 has Reference_No, i want to display only these. Left join will display table1 data all the time

Thank you Gail for updated information.

I am studying these event and will get back if any other issue arises.

But just for knowledge, what could be the reason with the approach...

no one is willing to pay much 🙂

Yes, I have same impression that this lead us to develop custom ETL. but due to referential integrity and number of table it is always impossible to manage. Also DDL...

Yes, it is crazy requirement. I can write custom ETL to sync few tables but write routine for all tables and specially if you have 50+ databases , it is...

sturner (5/15/2009)

---

I've always built my own log shipping mechanisms and they are easier to manage and more robust since they have more intelligence and robustness into the design than the...

This is the only thing left.

Case-1

DECLARE @ProdId varchar(10) = 'Prod1',

@color varchar(max) = NULL, -- Will make it optional and logic will work on all available color for...

Thank you Sean , it worked.

How can we make color and Size optional ? if either one or both provided it should return on input . If both not provide...

sean, I want to get output like following

-- If color invalid status should be 100

-- if color is valid but size is invalid status should be 101

-- if valid status...

Thank you Jacob , I will test them .