How to write query to add records name into main table

Question

0.00/5 (No votes)

See more:

i have one problem for writing query my problem is that i want write a query like this

in my database there is one main table "Contacts" in that there is two field Category1Code and Category2Code but i want to replace these Code into name.There is table for Category1Code and Category2Code.

table structure is like this
"Contacts"

ContactID Category1Code Category2Code FirstName LastName

C000001 C1018 C2025 ABC XYZ

the category1code table look like this

Category1Code CategoryName

C1018 PQR

the category2code table

Category2Code Category1Code Categoryname
C2001 C1018 TTT

i want replace these code into its name into Contact table.
Please give query
thnx in advance..

Finally i want output like this into Contact table

ContactID Category1Code Category2Code FirstName LastName

C000001 PQR TTT ABC XYZ

Posted 18-Mar-13 19:49pm

Ajinkya Ban

Updated 18-Mar-13 20:00pm

v2

Add a Solution

Comments

akee seth 19-Mar-13 3:57am

Can you give your query up to which you have tried. SO that it will be easy to help.

1 solution

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)

sainadh.chintha · Answer 1 · 2013-03-18T21:21:00

SQL

alter procedure sp_contacts
	(
		@Category1Code nvarchar(20), 
		@Category2Code nvarchar(20), 
		@FirstName nvarchar(20), 
		@LastName nvarchar(20)
	)
AS 
begin
	Declare @CategoryName1  varchar(20)
	Declare @CategoryName2  varchar(20)
	select @CategoryName1= CategoryName from Category1Code where Category1Code = @Category1Code 
	select @CategoryName2= CategoryName from Category2Code where Category2Code = @Category2Code and Category1Code = @Category1Code
   Insert Into contacts
	(
		Category1Code ,
		Category2Code ,
		FirstName,
		LastName
	)
	values
	(
		@Category1Code ,
		@Category2Code ,
		@FirstName,
		@LastName
	)
	update contacts set 
	Category1Code= @CategoryName1,Category2Code= @CategoryName2 where  Category1Code = @Category1Code and Category2Code = @Category2Code
end 
 
 exec sp_contacts 'C1018', 'C2001', 'ABC','XYZ'

i hope it helps.