Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to install MSDE
Hi, My installer needs to install MSDE and then my application. I've been searching the web and found that the latest recommended way by MSFT is to create an application wrapper. MSFT provides a C++ sample. (...- pikachiu
- Thread
- Replies: 0
- Forum: Wise Solutions: Wise Installer
-
Scheduling SQL
This is what I did but it returns all the time slots for me even the gap (next StartDateTime - current EndDate Time) is less than the appointment duration time! Could someone please help? *** 240 is 4 hours duration SELECT EndDate FROM Appointments currentApp WHERE EXISTS (SELECT *...- pikachiu
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Scheduling SQL
Thank you. I think I got the idea. I will try to compose the scheduling query using the subquery. :-)- pikachiu
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Scheduling SQL
I have a problem I don't know if I can do it in the SQL server. I have an "Appointment" table that contains Name, StartDateTime and StopDateTime. Each row represents one appointment. When I want to schedule a new appointment, I want to find the next N available time slot. I think this is too...- pikachiu
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
