Insert value From One Table to Another and also with variable- via Store Procedure

Question

0.00/5 (No votes)

See more:

I am New in Store Procedure.
I have a Store Procedure to insert values from client at runtime and also from another table's ID column. My SP holds 3 Column:
SId
Name
Addess

Now How to insert from both area(User Input in ID and Name column and Address is From another table)?
Thanks in Advance.

Posted 29-Dec-13 19:07pm

SumitChandra

Add a Solution

Comments

Purna.N 30-Dec-13 1:19am

can you provide the 2 table structure

SumitChandra 30-Dec-13 1:57am

1st Master Table:Project_Header
[SId] [bigint] IDENTITY(1,1) NOT NULL,
[ProjectName] [varchar](100) NOT NULL,
[ProjectType] [varchar](50) NOT NULL,
[ProjectLocation] [varchar](50) NOT NULL

AND THE 2nd Table Where i want to insert:Money_Receipt
[SId] [bigint] NOT NULL,
[Name] [varchar](50) NOT NULL,
[Address] [varchar](100) NOT NULL

Now Sid will come from Project_Header Table
and Name and Address from user input through a Store Procedure

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2013-12-29T21:01:00

SQL

INSERT INTO insertTable (x, y, z)
SELECT x, y, z
FROM a INNER JOIN b ON a.id = b.id

This format will work fine. Do the Sql with the join and add the first line at the top to make an insert of it.

SQL

create table t1
( 
  id int,
  val varchar(5),
  dt datetime
)


create table t2 
(
  id int,
  val varchar(5)  
)

insert into t2 values(1,'test')
insert into t2 values(2,'check')

insert into t1
select id, val, getdate() from t2

select * from t1

This will output:

1 test 2013-12-30 21:17:42.117
2 check 2013-12-30 21:17:42.117

with what ever the time is there. You can replace getdate() with your parameters, in other words, all you need to do, is add them to the select list and this will work as you asked.