t-sql insert - select - with parameters

Question

I have a 4 tables. One of the tables we are going to be inserting data into (Table A). Table A is going to receive misc data from Table B, C, D and also some unknown variable parameter data.

How do I set up the INSERT with a SELECT with also receiving parameters?

Abe Miessler · Accepted Answer · 2012-08-16 22:55:01Z

4

Something like this?

Insert INTO TableA (col1, col2,col3,col4)
  SELECT b.col1, c.col2, d.col3, @myparam
  FROM TableB as b
  INNER JOIN TableC as c
    ON b.id = c.id
  INNER JOIN TableD as d
    on c.id = d.id

answered Aug 16, 2012 at 22:55

Abe Miessler

85.6k104 gold badges323 silver badges496 bronze badges

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

3 Comments

Argyle Ghost Over a year ago

But there are going to be parameters to be inserted in to TableA as well, not just based on a where clause. TableA (col1 = value from parameter, col2 = value from tableb, col3 = value from table c)

Abe Miessler Over a year ago

Just put it in the select. See my updated. You can just throw a parameter into any select statement, it does not need to somehow be part of the table.

Argyle Ghost Over a year ago

Thank you so much. I believe I see where your coming from now. I will try in the morning and give you kudos and checkmarks :D I cant thank you enough. This was my last task for the day and was not getting anywhere with it until you come along. A big thank you to you :)

Bridge · Accepted Answer · 2012-08-16 22:55:53Z

0

Something like this:

DECLARE @a int, @b int
SET @a = 5
SET @b = 7

INSERT INTO TableA(Column1, Column2)
SELECT SomeOtherColumn, @a
FROM TableB
UNION
SELECT YetAnotherColumn, @b
FROM TableC

answered Aug 16, 2012 at 22:55

Bridge

30.9k10 gold badges64 silver badges85 bronze badges

2 Comments

Argyle Ghost Over a year ago

Yes but, @a is coming from a web service not from tableB. Maybe Im missing something. Ive been programming for over 12 hours straight today and sort of hallucinating right now, LOL

Bridge Over a year ago

@ArgyleGhost No @a and @b aren't coming from the tables, they're the variables I declared above. I was just demonstrating how they could be used whilst mixing them with the columns selected from one of your other tables!

Collectives™ on Stack Overflow

t-sql insert - select - with parameters

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related