Insert a row based on another row's data SQL Server 2008

Question

I made a schema example: http://sqlfiddle.com/#!3/6a134/1

Let's say I have a table called cart which contains customer_id's and item codes they want to buy.

I want to add Item "ZZZ" for any order currently in table cart that has item "ABC".

Is there a way to do with with a single SQL command?

The only way I know how to do this is if I wrote a stored procedure with a cursor and inserted a row for every customer id I find in the cart meeting my requirements.

Thanks!

Nathan · Accepted Answer · 2013-06-10 18:41:37Z

1

you can create a trigger that inserts the zzz item every single time an abc item is added... check this link:

answered Jun 10, 2013 at 18:41

Nathan

25.3k4 gold badges29 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DMoney Over a year ago

that would work, but what about existing rows in the table I want to update?

Nathan Over a year ago

inside queries use CASE THEN as the if statement... basically search (CASE), if found (THEN)...google CASE THEN statements

Collectives™ on Stack Overflow

Insert a row based on another row's data SQL Server 2008

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related