Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sql server concatenation of output vertically

Author  Topic 

pkuchaliya
Starting Member

49 Posts
Posted - 2008-07-10 : 03:44:10
Hi

I have write the query in sql server 2005 :-

select nkjob.job_id,nkjob.employer_profile_id,nkjob.designation,nkjob.key_skill
,ncity.city_name,nfarea.functional_type ,nkinds.industry_type,nspcl.specialization_type
from nk_employer_post_job_ nkjob
join nk_city_ ncity on nkjob.job_location like '%'+ncity.city_id+'%'
join nk_fuctional_area_ nfarea on nkjob.functional_area like '%'+nfarea.functional_id+'%'
join nk_industry_type_ nkinds on nkjob.type_of_industry like '%'+nkinds.industry_id+'%'
join nk_specialization_ nspcl on nkjob. area_of_specialization like '%'+nspcl.specialization_id+'%'

and i got the output like this :-

PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Agent Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Agent Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Agent Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Agent Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Banking/Insurance Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Banking/Insurance Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Banking/Insurance Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Banking/Insurance Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Client Server Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Client Server Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Client Server Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Client Server Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Mainframe Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Mainframe Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Mainframe Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Mainframe Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Middleware Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Middleware Accounting/Taxation/Finance System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Middleware Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Middleware Accounting/Taxation/Finance Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Agent BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Agent BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Agent BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Agent BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Banking/Insurance BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Banking/Insurance BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Banking/Insurance BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Banking/Insurance BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Client Server BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Client Server BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Client Server BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Client Server BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Mainframe BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Mainframe BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Mainframe BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Mainframe BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Middleware BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Middleware BPO/ITES/CRM/Transcription System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Middleware BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Middleware BPO/ITES/CRM/Transcription Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Agent Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Agent Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Agent Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Agent Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Banking/Insurance Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Banking/Insurance Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi Banking/Insurance Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai Banking/Insurance Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Client Server Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Client Server Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Client Server Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Client Server Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Mainframe Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Mainframe Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Mainframe Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Mainframe Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Middleware Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Middleware Education/Teaching/Training System
PANJOB000000000001 pankaj Sr. Devp asp.net,c# New Delhi IT Software - Middleware Education/Teaching/Training Computers
PANJOB000000000001 pankaj Sr. Devp asp.net,c# Mumbai IT Software - Middleware Education/Teaching/Training Computers
PANJOB000000000002 pankaj Sr.Eng java New Delhi Agent Accounting/Taxation/Finance Marketing
PANJOB000000000002 pankaj Sr.Eng java Mumbai Agent Accounting/Taxation/Finance Marketing
PANJOB000000000002 pankaj Sr.Eng java New Delhi Architecture / Interior Design Accounting/Taxation/Finance Marketing
PANJOB000000000002 pankaj Sr.Eng java Mumbai Architecture / Interior Design Accounting/Taxation/Finance Marketing
PANJOB000000000002 pankaj Sr.Eng java New Delhi Agent Advertising/PR/MR/Events Marketing
PANJOB000000000002 pankaj Sr.Eng java Mumbai Agent Advertising/PR/MR/Events Marketing
PANJOB000000000002 pankaj Sr.Eng java New Delhi Architecture / Interior Design Advertising/PR/MR/Events Marketing
PANJOB000000000002 pankaj Sr.Eng java Mumbai Architecture / Interior Design Advertising/PR/MR/Events Marketing


I have to find the

PANJOB000000000001:- in single row with all detail
PANJOB000000000002:- in single row with all detail

Please Help


pankaj

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2008-07-10 : 03:58:15
http://www.projectdmx.com/tsql/rowconcatenate.aspx
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site