Em Andamento

SQL Statement to combine bit fields

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.

Thanks

Will

## 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

SQL

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: set bit in c, structure engineering, sql microsoft, MICROSOFT SQL SERVER, combine, statement structure sql, php sql 2000, sql statement help, sql run package, sql select select, sql select, php form sql, combine program, edit records sql php, package sql distribution, php file combine, sql 2000, php sql record, file combine, combine php, bit server, bid statement work, sql edit php, run sql file, edit record php code

Acerca do Empregador:
( 172 comentários ) United States

ID do Projeto: #2970844

Premiar a:

bonega

See private message.

$5 USD em 1 dia
(24 Avaliações)
6.5

7 freelancers estão ofertando em média $8 para este trabalho

softservicesvw

See private message.

$12.75 USD em 1 dia
(334 Comentários)
7.7
ekam

See private message.

$11.05 USD em 1 dia
(111 Comentários)
5.7
praveenmenonvw

See private message.

$4.25 USD em 1 dia
(88 Comentários)
5.7
danvlas

See private message.

$5.1 USD em 1 dia
(74 Comentários)
5.6
elogixtech

See private message.

$6.8 USD em 1 dia
(27 Comentários)
4.4
promisevw

See private message.

$10.2 USD em 1 dia
(0 Comentários)
0.0