Click here to Skip to main content
15,504,703 members
Home / Discussions / Database
   

Database

 
GeneralRe: SSRS Report not allowing to edit name of the field Pin
indian14318-Mar-15 13:46
indian14318-Mar-15 13:46 
QuestionHelp with SSAS project Pin
rafael.avaria16-Mar-15 8:10
rafael.avaria16-Mar-15 8:10 
QuestionProblem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 7:38
delgaillo12-Mar-15 7:38 
AnswerRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 15:51
professionalMycroft Holmes12-Mar-15 15:51 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 23:12
delgaillo12-Mar-15 23:12 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 23:14
professionalMycroft Holmes12-Mar-15 23:14 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo28-Sep-15 1:17
delgaillo28-Sep-15 1:17 
QuestionCreating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:25
Member 115083508-Mar-15 15:25 
I'm being asked to create a couple of SQL statements to retrieve information about a Luxury Hotel Database.

List all the rooms in each hotel that have never been reserved in order by hotel number.
I have the SQL statement retrieved the rooms what have been reserved but my problem is retrieving those that have not been reserved.
SQL
SELECT RoomNo FROM RESERVATION WHERE RoomNo ORDER BY HotelNo


List the guests by name and the number of times each has reserved a room at one of our hotels. Arrange the list in order from most-frequent to least-frequent guest.

Here are the tables we are working on.

HOTEL (HotelNo, HotelName, City)

ROOM_TYPE (RoomType, Descr, RoomRate)

ROOM (HotelNo, RoomNo, RoomType, PhoneExt)
FK1: Foreign key HotelNo references HOTEL
FK2: Foreign key RoomType references ROOM_TYPE
GUEST (GuestNo, FirstName, LastName, Address, City, State, ZipCode)
GUEST_PHONE (PhoneNumber, GuestNo, PhoneType)
FK: Foreign key GuestNo references GUEST

RESERVATION (ResNum, HotelNo, RoomNo, GuestNo, ArrivalDate, DepartureDate, NumPersons)
FK1: Foreign Key (HotelNo, RoomNo) references ROOM
FK2: Foreign Key GuestNo references GUEST
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 16:33
professionalRichard Andrew x648-Mar-15 16:33 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:42
Member 115083508-Mar-15 16:42 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 16:48
professionalRichard Andrew x648-Mar-15 16:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:59
Member 115083508-Mar-15 16:59 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 17:21
professionalRichard Andrew x648-Mar-15 17:21 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:25
Member 115083508-Mar-15 17:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:56
Member 115083508-Mar-15 17:56 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 18:18
Member 115083508-Mar-15 18:18 
GeneralRe: Creating SQL statements in Access Databases Pin
Chris Quinn8-Mar-15 23:07
Chris Quinn8-Mar-15 23:07 
AnswerRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 7:51
Abdulnazark9-Mar-15 7:51 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 18:01
Member 115083509-Mar-15 18:01 
GeneralRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 22:06
Abdulnazark9-Mar-15 22:06 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 17:48
Member 115083509-Mar-15 17:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 18:59
Member 115083509-Mar-15 18:59 
QuestionVB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE28-Feb-15 23:01
KipkoechE28-Feb-15 23:01 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
manchanx1-Mar-15 2:01
professionalmanchanx1-Mar-15 2:01 
GeneralRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE3-Mar-15 20:48
KipkoechE3-Mar-15 20:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.