SQL 2000 VIEWS

Migrate ONE MS Access 2000 query to a MS Sql 2000 view. Or you can add those calculated fields to the treatment attendance table to create those field on the fly. This is basically a copy and paste job. It can be done in 10 minutes, If you know how to work with formulas and functions. I need only ONE query to be migrated to sql. What I require from you is the view's scripts to test the view in my sql server. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform all windows platforms, MS SQL 2000