Lowell,

I guess it should be like this:

SELECT p.*, COALESCE(s.SalePrice, p.SalePrice) AS Price, COALESCE(s.SaleCost, p.SaleCost) AS Cost

FROM [#PROMO] p

LEFT JOIN [#sh] s

ON s.ClientOutletID = p.ClientOutletID

AND s.ClientProductID = p.ClientProductID

...

This is how I was able to do that :).

set nocount on

Create table #PromoHistory

(

WeekDate datetime NOT NULL, OutletId nvarchar(50) NOT NULL, ProductId nvarchar(50) NOT NULL,Price decimal(18,2) NOT NULL,Cost decimal(18,2) NOT...

No. Actually I was missing brackets that is exec(@sql) .

I made the changes and it worked for the first example.

But for example2 its giving the following erorr:

Server: Msg 137,...

Steve,

I am not a SQL expert. Please guide me how I can achieve this. First of all do you fully understand the problem?

I have created a script to create a...