select * from tblsmcs_JobDetail order by startdate desc

This is list of work orders. Customer can select any one to view its status.
Work Order No.	Model	Make	Start Date	Status
1000010322	STEALTH	JACKSON	6/5/2008	Customer Completed
1000010321	LES PAUL	GIBSON	6/3/2008	Customer Completed
1000010320	LES PAUL	EPIPHONE	5/31/2008	Picked Up
1000010314	LES PAUL DELUXE	GIBSON	5/24/2008	Customer Completed
1000010315	DOVES IN FLIGHT	GIBSON	5/24/2008	Customer Completed
1000010316	DM18E4	TACOMA	5/24/2008	Waiting For Parts
1000010317	ROBOT LES PAUL	GIBSON	5/24/2008	In Progress
1000010311	MX STD STRAT	FENDER	5/22/2008	Picked Up
1000010312	MX STD STRAT	FENDER	5/22/2008	Picked Up
1000010310	SQ STD P BASS	FENDER	5/21/2008	Picked Up
1000010309	WOLFGANG	PEAVEY	5/20/2008	Picked Up
1000010308	LES PAUL	GIBSON	5/16/2008	Customer Completed
1000010306	SG	GIBSON	5/15/2008	Picked Up
1000010303	SPIDER III 75 1X12	LINE 6	5/14/2008	Customer Completed
1000010305	A14CE	TAYLOR	5/14/2008	Picked Up
1000010302	BFG LES PAUL	GIBSON	5/14/2008	Picked Up
1000010301	SPIDER VALVE 112	LINE 6	5/13/2008	Picked Up
1000010296	I	HAGSTROM	5/10/2008	Picked Up
1000010300	MH1000	LTD	5/10/2008	Picked Up
1000010293	JAZZ MASTER	FENDER	5/8/2008	Customer Completed
1000010290	SJ-180	YAMAHA	5/7/2008	Picked Up
1000010288	LES PAUL RAW POWER	GIBSON	5/7/2008	Customer Completed
1000010289	VERBZILLA	LINE 6	5/7/2008	Waiting For Parts
1000010291	AM DLX STRAT	FENDER	5/7/2008	Picked Up
1000010285	STD P BASS	FENDER	5/6/2008	Customer Completed
1000010283	STRAT	BEHRINGER	5/6/2008	Customer Completed
1000010287	PRO II	ARIA	5/6/2008	Customer Completed
1000010284	FIRST ACT STRAT	FENDER	5/6/2008	Customer Completed
1000010286	330	RICKENBACKER	5/6/2008	Customer Completed
1000010281	DG-11E BLK	FENDER	5/3/2008	Customer Completed
1000010280	WARLOCK	B.C. RICH	5/3/2008	Picked Up
1000010279	HELLFIRE	HALO	5/3/2008	Waiting For Parts
1000010277	ACOUSTIC	HOFNER	5/1/2008	Customer Completed
1000010270	AM STD STRAT	FENDER	4/26/2008	Picked Up
1000010269	WARRIOR	JACKSON	4/24/2008	Picked Up
1000010267	LES PAUL	GIBSON	4/23/2008	Customer Completed
1000010268	AC25/SM	BREEDLOVE	4/23/2008	Picked Up
1000010261	UBER METAL	LINE 6	4/16/2008	Picked Up
1000010262	S115V	YAMAHA	4/16/2008	Customer Completed
1000010257	AM STD STRAT	FENDER	4/15/2008	Picked Up
1000010259	CW118V	YAMAHA	4/15/2008	Picked Up
1000010260	AM STD STRAT	WARMOTH	4/15/2008	Picked Up
1000010258	CM15V	YAMAHA	4/15/2008	Picked Up
1000010255	SPIDER VALVE HD100	LINE 6	4/12/2008	Customer Completed
1000010256	HEARTFIELD DR4	FENDER	4/12/2008	Picked Up
1000010247	ERIC JOHNSON	FENDER	4/11/2008	Picked Up
1000010248	LES PAUL	GIBSON	4/11/2008	Picked Up
1000010252	MX STD STRAT	FENDER	4/11/2008	Picked Up
1000010251	SG	GIBSON	4/11/2008	Customer Completed
1000010246	DC AURA	MARTIN	4/11/2008	Picked Up
1000010245	SPECIAL	EPIPHONE	4/8/2008	Picked Up
1000010240	LPS	WARMOTH	4/5/2008	Customer Completed
1000010242	AM DLX STRAT	FENDER	4/5/2008	Picked Up
1000010232	SPIDER III 75 WATT	LINE 6	4/2/2008	Picked Up
1000010225	AM STD STRAT	FENDER	4/1/2008	Picked Up
1000010213	RG4EX1	IBANEZ	3/29/2008	Customer Completed
1000010215	5 STRING BASS	SALAS	3/29/2008	Picked Up
1000010214	HOLLOW BODY	GRETSCH	3/29/2008	Customer Completed
1000010216	MARCUS MILLER	FENDER	3/29/2008	Picked Up
1000010218	LES PAUL	GIBSON	3/29/2008	Picked Up
1000010217	LS 6 STRING	STR	3/29/2008	Picked Up
1000010230	513	PRS	3/28/2008	Picked Up
1000010211	12 STRING	TAKAMINE	3/28/2008	Picked Up
1000010212	MANDOLIN	FRANCISCAN	3/28/2008	Picked Up
1000010209	DIME V	WASHBURN	3/28/2008	Picked Up
1000010204	ALL PARTS STRAT	FENDER	3/28/2008	Picked Up
1000010210	RAPTOR	PEAVEY	3/28/2008	Picked Up
1000010208	VARIAX 600	LINE 6	3/27/2008	Picked Up
1000010206	RG350	RAVEN	3/26/2008	Received
10010010207	S520EX	IBANEZ	3/26/2008	Received
1000010195	L115	LYON	3/20/2008	Customer Completed
1000010191	SG	GIBSON	3/14/2008	Picked Up
1000010190	VARIAX 700	LINE 6	3/13/2008	Picked Up
1000010167	HERITAGE MOCKINGBIRD	B.C. RICH	3/12/2008	Picked Up
1000010166	LES PAUL 100	EPIPHONE	3/12/2008	Picked Up
1000010187	SG	GIBSON	3/12/2008	Customer Completed
1000010183	STARCASTER	FENDER	3/12/2008	In Progress
1000010184	LYON	WASHBURN	3/12/2008	Customer Completed
1000010181	SKYLINE	N/A	3/12/2008	Received
1000010182	VTG STD STRAT	FENDER	3/8/2008	In Progress
1000010179	LES PAUL CUSTOM	GIBSON	3/8/2008	Picked Up
1000010180	LES PAUL	EPIPHONE	3/8/2008	Customer Completed
1000010168	1769	OVATION	3/7/2008	Customer Completed
1000010171	ALLPARTS P BASS	FENDER	3/7/2008	Picked Up
1000010170	B-50	ESP	3/6/2008	Picked Up
1000010162	SG CLASSIC	GIBSON	3/5/2008	Customer Completed
1000010155	N/A	IBANEZ	3/5/2008	Picked Up
1000010164	307	TAYLOR	3/5/2008	Customer Completed
1000010149	LCT-250 / MERCURY	N/A	2/29/2008	Customer Completed
1000010148	RHOADES	JACKSON	2/29/2008	Customer Completed
1000010142	JAGUAR	FENDER	2/28/2008	Customer Completed
1000010147	DINKY	JACKSON	2/28/2008	Picked Up
1000010127	SLSMG	JACKSON	2/27/2008	Picked Up
1000010128	STRAT	N/A	2/27/2008	Received
10000101022	SPIDER III	LINE 6	2/20/2008	Delivered
1000010121	F-75	FENDER	2/20/2008	Picked Up
1000010122	714-CE	TAYLOR	2/20/2008	Picked Up
1000010233	SG	GIBSON	2/15/2008	Picked Up
1000010116	VARIAX	LINE	2/13/2008	Picked Up
1000010117	STRAT	FENDER	2/13/2008	Picked Up
1000010114	GEDDY LEE	FENDER	2/9/2008	Picked Up
1000010110	AX3000G	KORG	2/8/2008	Waiting For Parts
1000010112	STRAT 12STRING	FENDER	2/8/2008	Picked Up
1000010111	DAMIEN FR	SCHECTOR	2/8/2008	Picked Up
1000010113	C-40	YAMAHA	2/8/2008	Picked Up
1000010109	SG	GIBSON	2/7/2008	Customer Completed
1000010107	ARTCORE	IBANEZ	2/5/2008	Picked Up
1000010105	AMERICAN STRAT	FENDER	2/5/2008	Picked Up
1000010103	STRAT	FENDER   </