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 .

Thank you Anthony.

I ran SqlService under a domain privileged account and everything start working

I have reset local folder permissions and it worked for local rename. But to copy file from network path e.g. \\server\location , it is throwing access denied error.

Thank you Gail

Thank you Gail and Eirikur Eiriksson. I have enabled the trace on serve to capture execution plans and related details. So that I may able to compare slow and fast...

Thank you Chris. You are correct and initially I had same understanding, but I de-tracked 🙁

Thanks again