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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ryanchapman
-
select only columns when two rows have the same value
Forgive my ignorance. Your suggestion does look alot cleaner. So the table should look like CREATE TABLE schedule ( userid int(10) NOT NULL, timeslot char(10) NOT NULL, available enum('Y','N') DEFAULT 'Y' NOT NULL ) Thanks again for the help!- ryanchapman
- Post #3
- Forum: ANSI_SQL
-
select only columns when two rows have the same value
Hi everyone, I have a simple question about a select statement that is-not-too-simple for me. I have one sql table, named 'schedule' which stores schedule info for all users. The table only stores scheduling data for mon-fri, 8am-5pm. Its only a prototype...- ryanchapman
- Thread
- Replies: 2
- Forum: ANSI_SQL
-
Small 66 block-cover?
Siemon makes two different types of covers for 66 blocks, hinged and snap-on. Hinged: http://www.siemon.com/e-catalogXML/familylist.asp?FAM=co_lastinhingecovers Snap-on: http://www.siemon.com/e-catalogXML/familylist.asp?FAM=co_snaponcovers When looking at the catalog, note that you'll need a...- ryanchapman
- Post #2
- Forum: Cabling
