| ƒNƒGƒŠ–¼ | ‚r‚p‚k•¶ |
|---|---|
| S_ƒXƒPƒWƒ…[ƒ‹—\–ñŽžŠÔ | PARAMETERS [ŠúŠÔŽ©] DateTime, [ŠúŠÔŽŠ] DateTime, [ScheduleIDParam] Long; SELECT DISTINCTROW [ƒXƒPƒWƒ…[ƒ‹Ú×].[ŠJŽn—\’莞], [ƒXƒPƒWƒ…[ƒ‹Ú×].[I—¹—\’莞], [ƒXƒPƒWƒ…[ƒ‹].[ƒXƒPƒWƒ…[ƒ‹ID], [ƒXƒPƒWƒ…[ƒ‹].[ƒŒƒ“ƒ^ƒ‹¤•iID], [ƒXƒPƒWƒ…[ƒ‹].[—\’è“ú] FROM ƒXƒPƒWƒ…[ƒ‹ INNER JOIN ƒXƒPƒWƒ…[ƒ‹Ú× ON [ƒXƒPƒWƒ…[ƒ‹].[ƒXƒPƒWƒ…[ƒ‹ID] = [ƒXƒPƒWƒ…[ƒ‹Ú×].[ƒXƒPƒWƒ…[ƒ‹ID] WHERE ((([ƒXƒPƒWƒ…[ƒ‹].[ƒŒƒ“ƒ^ƒ‹¤•iID])=[ScheduleIDParam]) AND (([ƒXƒPƒWƒ…[ƒ‹].[—\’è“ú])>=[ŠúŠÔŽ©] And ([ƒXƒPƒWƒ…[ƒ‹].[—\’è“ú])<=[ŠúŠÔŽŠ])); |
| S_ŒÚ‹qID—p‘I‘ð | PARAMETERS ’Šo‚·‚éŒÚ‹qID Long; SELECT ŒÚ‹qƒ}ƒXƒ^.ŒÚ‹qID, ŒÚ‹qƒ}ƒXƒ^.ŒÚ‹q‚ÌŽ–¼, ŒÚ‹qƒ}ƒXƒ^.ŒÚ‹q‚̃VƒƒC, ŒÚ‹qƒ}ƒXƒ^.ŽxŽÐ–¼^Žx“X–¼, ŒÚ‹qƒ}ƒXƒ^.¿‹æZŠ, ŒÚ‹qƒ}ƒXƒ^.Žs‹æ’¬‘º, ŒÚ‹qƒ}ƒXƒ^.“s“¹•{Œ§, ŒÚ‹qƒ}ƒXƒ^.—X•Ö”Ô†, ŒÚ‹qƒ}ƒXƒ^.‘–¼, ŒÚ‹qƒ}ƒXƒ^.ŒÚ‹q‚Ì•”–¼, ŒÚ‹qƒ}ƒXƒ^.“d˜b”Ô†, ŒÚ‹qƒ}ƒXƒ^.“àü”Ô†, ŒÚ‹qƒ}ƒXƒ^.FAX”Ô† FROM ŒÚ‹qƒ}ƒXƒ^ WHERE (((ŒÚ‹qƒ}ƒXƒ^.ŒÚ‹qID)=[’Šo‚·‚éŒÚ‹qID])); |
| U_ƒXƒPƒWƒ…[ƒ‹ŽžˆêŠ‡XV | PARAMETERS XVŠJŽnŽž DateTime, XVI—¹Žž DateTime; UPDATE ƒXƒPƒWƒ…[ƒ‹Ú× SET ƒXƒPƒWƒ…[ƒ‹Ú×.ŠJŽn—\’莞 = [XVŠJŽnŽž], ƒXƒPƒWƒ…[ƒ‹Ú×.I—¹—\’莞 = [XVI—¹Žž]; |
| –ÚŽŸ‚É–ß‚é |