ÇóÒ»SQLÓï¾ä

±í½á¹¹ÈçÏÂ
guest_no emp_no    bdate                    edate    remark  cb      hdb      ColLevel
018 0056 2010-01-18 00:00:00 NULL NULL H 14.00 A
018 0071 2009-09-19 00:00:00 NULL NULL Y 22.00 B
018 0071 2009-10-27 00:00:00 NULL NULL K 26.00 A
080 0020 2009-07-28 00:00:00 2009-07-31 00:00:00 NULL H 20.00 A
080 0020 2009-07-28 00:00:00 2009-07-31 00:00:00 NULL K 10.00 A
080 0035 2002-01-01 00:00:00 NULL NULL Y 10.00 B
080 0096 2009-08-01 00:00:00 NULL NULL H 17.00 A
080 0096 2009-08-01 00:00:00 NULL NULL K 27.00 A
080 0107 2007-03-28 00:00:00 2009-07-27 00:00:00 NULL H 20.00 B
080 0107 2007-08-23 00:00:00 2009-07-27 00:00:00 NULL K 10.00 A
171      0056 2009-06-09 00:00:00 NULL NULL H 14.00 A
171 0071 2009-03-13 00:00:00 NULL NULL K 25.00 A
171      0071 2009-03-24 00:00:00 NULL NULL Y 22.00 A
Ñ¡³öºìÉ«À¸,¼´bdate´óÓÚ2009-02-25×îСÈÕÆÚÇÒ֮ǰÎ޼ǼµÄÊý¾Ý.

---

SQL code:
----------------------------------------------------------------
-- Author :SQL77(ֻΪ˼ÆëÀÏ)
-- Date :2010-02-25 16:21:05
-- Version:
-- Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
-- Aug 6 2000 00:57:48
-- Copyright (c