I need help with Microsoft SQL Server 2000 SQL statement that will select the following:
SELECT Edit FROM ObjectPermissions
WHERE ContactID=1 and UserGroupdID in (1,5,6)
The twist is this - I want the result set to return only one row. The Edit should be 1 if any record has Edit = 1 or Edit should be 0 if all records have Edit=0.
The table structure is in the include file.
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.