How to write a SQL query to present values horizontally sql server 2005

[Tridip Bhattacharjee]

Suppose I have one table called Jobs: CREATE TABLE [Jobs] ( [JOBID] [int] IDENTITY(1,1) NOT NULL, [PARTDESC] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OrderPlacedBy] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SpecialistName] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Priority] [int] NOT NULL, [Symptoms] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CustomerNotes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ShopNotes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [JobType] [nvarchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [JobState] [nvarchar](32) COLLATE Latin1_General_CI_AS NULL, [JobAddedDate] [datetime] NOT NULL, [JobStartedDate] [datetime] NULL, [JobFinishedDate] [datetime] NULL, [JobShippedDate] [datetime] NULL, [RecievedDate] [datetime] NULL ) I want to see the specialist name and his jobs IDs horizontally. ANA 201,502,605,701,774 BEN 102,103,051 JEN 705,401,402,509,409,408 A specialist may have n jobs. Suppose specialist ANA has 10 jobs where BEN has 5 jobs. In this way I want to show specialist his jobs horizontally where the number of jobs may vary per specialist. How can I do this in SQL?

tbhattacharjee

[Jorgen Andersson]

Make a search on Pivot[^].

List of common misconceptions

[Mycroft Holmes]

There are some excellent articles [^]here on CP (blatant self promotion here)

Never underestimate the power of human stupidity RAH

[PIEBALDconsult]

With Sql Server, you can write your own aggregate function[^]. And you spelled received wrong.

[Wendelius]

Must say that you found an excellent article for this issue ! :)

The need to optimize rises from a bad design.My articles[^]