how to retrieve data from one table and insert into another table?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

HI,

I am doing an attendance system based on fingerprint.
When i put a finger on fingerprint reader,the system will identify the scanned fingerprint from database.
What i want to do is if the fingerprint is match, then get the related data like employeeID,employeeName,currentDate based on the fingerprint's ID from table Fingerprint and insert into table attendance.

May i know Is it use insert into select?

Thanks for help.

Posted 19-Dec-11 4:08am

gracewong88

Add a Solution

Comments

Amir Mahfoozi 20-Dec-11 6:00am

What do you mean by saying "May i know Is it use insert into select?" ?

4 solutions

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)

Pete O'Hanlon · Answer 1 · 2011-12-19T04:15:00

Solution 1

T-SQL allows you to use a SELECT as part of the INSERT statement, so you can do something like:

SQL

INSERT INTO MyTable(EmpID, EmpName, CurrentDate)
SELECT FullEmployeeID, EmployeeName, GETDATE()
FROM MyOtherTable
WHERE SomeCriteria = @PassedInCriteria

Posted 19-Dec-11 4:15am

Pete O'Hanlon

Comments

Member 6530594 27-Oct-13 4:02am

@PassedInCriteria, this Parameter, how to pass in the from vb code to SP?

Member 6530594 27-Oct-13 4:04am

@PassedInCriteria, this Parameter, how to pass in the from vb code to SP?
my e-mail, c.nath712gmail.com

D Anil Kumar · Answer 2 · 2011-12-19T04:35:00

Solution 2

write stored procedure for this.

declare local variable first.

select the data from 1st table and asssign then to the local variables

and write the insert query with the local variables

thats it..

Posted 19-Dec-11 4:35am

D Anil Kumar

Comments

Pete O'Hanlon 19-Dec-11 11:40am

Why? This is not the most efficient way of solving the problem, especially considering that T-SQL provides the tools built in to support what the OP needs to do without having to create temporary variables.

thatraja · Answer 3 · 2011-12-19T04:47:00

Solution 3

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE[^]

And a CP article for you.
A Framework in C# for Fingerprint Verification[^]

Posted 19-Dec-11 4:47am

thatraja

gvprabu · Answer 4 · 2011-12-19T23:36:00

Solution 4

Hi,

SQL

INSERT INTO dbo.table1 (Col1,Col2,col3)
SELECT Col1,Col2,col3
FROM Table2 
WHERE Conditions

So Table2 values will insert in Table1....

Posted 19-Dec-11 23:36pm

gvprabu

Updated 20-Dec-11 0:55am

v2

Comments

Karthik Harve 20-Dec-11 6:55am

[Edit] Added pre tags.

Pete O'Hanlon 20-Dec-11 6:58am

How is this any different to the solution I posted yesterday?