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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-30 : 13:58:15
|
| Vanisha writes "Hi,This is the question i am trying to work out,how would you retreive performers who would have bookings at more than one venue.Below are the following entities followed by the attributesEVENTEvent_idEvent_nameEvent_typeAGENTAgent_idAgent_nameAgent_locationFEEPerformer_codePerformer_typeFeeVENUEVenue_idVenue_nameVenue_locationPERFORMERPerformer_idPerforner_namePerformer_codePerformer_locationPerformer_ageBOOKINGBooking_IdPerformer_idAgent_idVenue_idEvent_idBooking_date" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-04-30 : 14:25:58
|
| select performer_idfrom Bookinggroup by performer_idhaving count(distinct Venue_id) > 1==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL queries using count functions