Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 8:59am
Edited 3-Jan-13 10:10am
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Member 9693583 at 3-Jan-13 14:10pm
   
Can u pls write detail query... i m very much confusing....
 
Thanks & regards,
Kshitija
Christian Graus at 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.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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.
  Permalink  
v2

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

  Print Answers RSS
0 OriginalGriff 436
1 Maciej Los 249
2 BillWoodruff 199
3 /\jmot 180
4 Suraj Sahoo | Coding Passion 170
0 OriginalGriff 8,484
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,639
3 Maciej Los 5,159
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 3 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100