Click here to Skip to main content
11,577,710 members (63,250 online)
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 7:59am
Edited 3-Jan-13 9: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 Peter Leow 180
1 Richard MacCutchan 175
2 DamithSL 150
3 OriginalGriff 135
4 Afzaal Ahmad Zeeshan 95
0 OriginalGriff 830
1 Sergey Alexandrovich Kryukov 701
2 Abhinav S 573
3 F-ES Sitecore 420
4 Dave Kreskowiak 374


Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 3 Jan 2013
Copyright © CodeProject, 1999-2015
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