Click here to Skip to main content
12,297,982 members (57,545 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-server-2005 C# ASP.NET , +
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 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.
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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160525.2 | Last Updated 3 Jan 2013
Copyright © CodeProject, 1999-2016
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