Query help - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Query help

Author

Topic

ranjan3838
Starting Member

2 Posts

Posted - 2007-12-03 : 07:50:58

hii
can any one help mee i had write a query the out put is comming write but i want comma's seperator values in a single field.
thank's in advance
byee

SELECT
---TOP 100 PERCENT
dbo.Events.Event_Id,
dbo.Events.Event_Title,
dbo.Events.Event_Date,
dbo.Events.Event_Venue,
dbo.Events.Event_StartTime,
dbo.Event_Type.Type,
dbo.Event_Producer.PName,
dbo.Events.Printed_Program ,
dbo.Composers.Composer_Name,
dbo.Event_Individuals.Uniform_Title,
dbo.Event_Individuals.Title_Given,
dbo.Event_Individuals.Premiere,
dbo.Event_Individuals.Lang,
dbo.Event_Individuals.Individual_Notes ,
dbo.Performer_Individuals.Performers,
dbo.Creative_Participants.Participant_Name,
dbo.Performer_Groups.PG_Name,
dbo.Performers_All.Performer_Notes,
dbo.Recordings.Rec_Locations,
dbo.Recordings.Rec_Format
FROM
dbo.Events left outer JOIN
dbo.Event_Type ON dbo.Events.Event_Type = dbo.Event_Type.TyId left outer JOIN
dbo.Event_Producer ON dbo.Events.Event_Producer = dbo.Event_Producer.PId left outer JOIN
dbo.Event_Individuals ON dbo.Events.Event_Id = dbo.Event_Individuals.Event_Id left outer JOIN
dbo.Composers ON dbo.Event_Individuals.Composer = dbo.Composers.CID left outer JOIN
dbo.Performers_All ON dbo.Events.Event_Id = dbo.Performers_All.Event_Id left outer JOIN
dbo.Performer_Individuals ON dbo.Performers_All.Performer_Individual = dbo.Performer_Individuals.PerfId left outer JOIN
dbo.Performer_Groups ON dbo.Performers_All.Performer_Groups = dbo.Performer_Groups.PGId left outer JOIN
dbo.Recordings ON dbo.Events.Event_Id = dbo.Recordings.Event_Id left outer join
dbo.Creative_Participants on cpid = dbo.performers_all.creative_participants

where
event_venue in ('')
----------or event_title like '%Violin%'
--or event_title in ('Event 1')
--or event_date in ('10/31/2007')
--or event_venue in ('Clark Theater','Avery Fisher Hall')
or event_starttime in ('2:00 pm')
--or type in ('Drama Scenes')
--or pname in ('Juilliard School','Juilliard Graduate School')
--or composer_name in ('Abbott, Alan','Acker, Dieter')
--or uniform_title in ('violin')
--or title_given in ('1st Event','Dance Performance 2')
--or premiere in ('Juilliard','New York')
--or lang in ('English','Czech')
--or individual_notes like '%First Individual Event%'
--or performers in ('Anderer, Joseph')
--or participant_name in ('Zeger, Brian, piano','Corsaro, Frank, director')
--or pg_name in ('Juilliard Jazz Ensembles','Juilliard String Quartet (1969-1974)')
--or performer_notes like '%dsfasdaf%'
--or Rec_locations in ('Library & Recording Studio','Recording Studio')
--or Rec_Format in ('dvd')
order by Events.Event_Id

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-12-03 : 07:59:37

Not clear what it is that you want really?

This maybe:

SELECT 
---TOP 100 PERCENT 
dbo.Events.Event_Id + ',' + dbo.Events.Event_Title + ',' + ... as SomeCol
From Table
....

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-03 : 08:37:38

Where do you want to show comma seperated values?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources