spencer_robinson (2/28/2013)

---

Apologies - Lets try that again

--DROP TABLE IF IT EXISTS

IF OBJECT_ID('TempDB..#StoreItemWeeksHave','U') IS NOT NULL

BEGIN

DROP TABLE #StoreItemWeeksHave

END

IF OBJECT_ID('TempDB..#StoreItemWeeksNeed','U') IS NOT NULL

BEGIN

DROP TABLE #StoreItemWeeksNeed

END

IF OBJECT_ID('TempDB..#Weeks','U') IS NOT NULL

BEGIN

DROP TABLE #Weeks

END

--CREATE THE...

I like the CTE approach that Erin posted. Just a couple changes to it so that it will produce the desired output.

;with cte

as

(

select IndName

, Account

, AddressType

, AddressLine1

, AddressLine2

,...

Hi and welcome to SSC. Your post does not contain a whole lot of information. I cobbled together some stuff based on what you posted. I changed your column names...

Duplicate post. Direct all replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1425086-392-1.aspx

As Eugene already said it is far more helpful if you can provide ddl and data in a consumable format. I had a little time so I did this for...

There is nowhere near enough information to provide anything other than a shot in the dark. Please read the following article about what to post for performance problems. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

Glad you got it sorted out.

And thanks Jeff for the extra points. 😉

asco5 (2/27/2013)

---

Sean Lange (2/27/2013)

---

asco5 (2/26/2013)

---

hi thanks for your reply

this is a example of what i want to do

as you see i have my data base and i have...

jancas08 (2/27/2013)

---

Yup its just inserting a new row. I can't change the structure of the tables because I don't have the 'authority' to do so. I am just to implement...

You have the wrong wildcard in your LIKE. The asterisk is from Access. SQL Server use percent.

when ERRORMESSAGE LIKE 'ED%' then 'Education'

Sean Lange (2/27/2013)

---

This should cover the Updates and Deletes. I don't understand how the insert logic is supposed to work.

declare @sql varchar(max) = ''

--First is the updates

select @sql =...

Something like this should work.

select * from

(

select ID, SEQUECE, NOTE, ROW_NUMBER() OVER...

This should cover the Updates and Deletes. I don't understand how the insert logic is supposed to work.

declare @sql varchar(max) = ''

--First is the updates

select @sql = stuff ((

select...

OK then this will greatly benefit from a set based approach instead of a cursor. Thanks for the...

jancas08 (2/27/2013)

---

Okay I will simplify my steps:

The TEST ddl is the data that has commands that specify changes to the tables.

My objective is to do those specified commands which can...