how to create nested query using 'insert' as parent & 'select' as child

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I want to insert data into Tech_allocation table where tech_name which is in dropdownlist are from New_tech table(bind from new_tech table).

AND

Complaint_no selected from another dropdownlist(bind from Call_reg table) which is from table Call_reg table

So I want to select complaint_no (from Call_reg table), Tech_name(New_Tech table) & on button click insert into Tech_allocation table..

can somebody pls help...

Posted 3-Jan-13 7:59am

Member 9693583

Updated 3-Jan-13 9:10am

fjdiewornncalwe

v2

Add a Solution

2 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)

Christian Graus · Answer 1 · 2013-01-03T08:07:00

Solution 1

Insert using select[^]

Posted 3-Jan-13 8:07am

Christian Graus

Comments

Member 9693583 3-Jan-13 14:10pm

Can u pls write detail query... i m very much confusing....

Thanks & regards,
Kshitija

Christian Graus 3-Jan-13 14:12pm

If you think we can write your query for you based on your question then yes, you are confused. We'd need to know the table structures, the relationships and so on. And then we'd need to be willing to do all your work on the basis that you have a job but don't even know how to attempt to do it, even when given detailed instructions.

Reza Alipour Fard · Answer 2 · 2013-01-03T11:21:00

Hi
I think bellow query can help you:

-----------------------------------------------------------------------------------
Insert	[DestinationTable](FirstColumn, ...)
Select	[SourceTable].[FirstColumn], ...
	From	[SourceTable]
	Where	Not Exists	
		(Select	*
			From	[DestinationTable]
			Where	[IdentityColumn] = [SourceTable].[IdentityColumn]
		)
-----------------------------------------------------------------------------------

I hope it's helpful.