You do not need to remove anything.

Just don't copy it from staging to destination.

Add WHERE clause to the last INSERT statement.

UPDATE products

SET productdetail = @detail,

      productprice = ISNULL(@price, productprice)

WHERE productid = @id.

DATEADD(mm, 5, DATEADD(YY, 2005-1900, 0))

Than format this datetime value in a stile you want. See CAST in BOL.

SELECT H1.PhoneNum

FROM History H1

INNER JOIN History H2 on H1.ProjectID  = H2.ProjectID and H1.PhoneNum = H2.PhoneNum

WHERE H1.ProjectID IN (945, 1172)

AND CallDateTime > getdate() -7 AND AttResult = 5

GROUP BY H1.PhoneNum

HAVING COUNT(H2.PhoneNum) >...

read in BOL article about sp_executesql and using variables in dynamic SQL.

What is unique index 'User_Fields_Key0' ?

Update TableA

Set Number = 2, Type = 580

FROM TableB

where TableA.Email = TableB.2nd_Email

and TableA.Number = 0

Sorry, I updated my post too late.

Execute @X = dbo.SP  assigns to @X RETURN_VALUE, not anything from returning recordset.

By default RETURN_VALUE = Error code but you cann assign any...

1st dataset must come from dbo.SP.

Eliminate SELECT statement from that SP.

RETURN @Value is only thing you need.

You must have administrative privilages on \\<Servname> to read C$.

Probably user running you instance of SQLServer is not anymore.

Set up shared folder and access rights to it properly.

You need just LEFT JOIN.

That's all.

Just finish your script with

drop table #Temp

#Temp stays in tempdb until you close the connection.

It creates deadlock.

OSQL statement will wait for transaction to commit to read the data created within this transaction, and transaction will wait for xp_cmdshell to commit to proceed.

FYI

English is not only language on Earth.

I would suggest trigger on his table.

This trigger suppose to recreate view(s) after each INSERT/UPDATE/DELETE on this table.