Link Details

Previous | Next

Surprise Me!
Link 22114 thumbnail
User 200929 avatar

By ahwulf
via thecodist.com
Published: May 15 2007 / 07:59

A Sql Challenge: Find Available Appointment Times
I am working on a service appointment application, where a user can choose a service taking some multiple of 30 minutes, and be given a set of possible appointment times. Can this be done in a single sql statement?
Vote up
Vote down
  • 8
  • 0
  • 1058
  • 401
SaveShareSend Tags:

Comments

Add your comment
User 227434 avatar

jsmith8858 replied ago:

0 votes Vote down Vote up Reply

Here's my response to the challenge. the solution is actually quite simple.

http://www.dzone.com/links/a_sql_challenge_response_finding_available_appoin.html

And yes, it can be done in a single SQL statement .... :)

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (8)



Voters Against This Link (0)