Thursday, October 28, 2010

Update A (without using join)


UPDATE DailyAttendanceTable SET DailyAttendanceTable.Class = B.Class ,DailyAttendanceTable.[Division] = B.[Division],DailyAttendanceTable.[RouteNo] = B.[RouteNo],DailyAttendanceTable.[PickUpPoint] = B.[PickUpPoint],DailyAttendanceTable.[DropRouteNo] = B.[DropRouteNo],DailyAttendanceTable
.[DropDownPoint] = B.[DropDownPoint]FROM SCHULE_STUDENTDETAILS BWHERE DailyAttendanceTable.StudentId = B.StudentId
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Loop Engineering: Designing the Systems That Prompt Your Agents

Loop Engineering For the last couple of years, the core skill in working with AI was writing a good prompt. You'd craft careful instru...