SQL Question

Encerrado Postado Nov 24, 2004 Pago na entrega
Encerrado Pago na entrega

I have a quick question on SQL Server. I need to check 10 fields Code1 thru Code10. I'm using the following SQL statement with a subquery as an example. I can get this work by building several subqueries for each code fields (1 - 10.

SELECT *

FROM Transaction_Detl

WHERE (Code1 IN

(SELECT Code

FROM Code_List

WHERE Code_Type = 'T'))

I would like to rewrite the SQL code listed above to check for the following fields in one statement without writting subqueries for each code. Is there a lookup function in SQL Server 2000. Please bid if this can be achived without subqueries.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows 2000, SQL Server 2000

Engenharia MySQL PHP Arquitetura de software Teste de Software SQL

ID do Projeto: #3448658

Sobre o projeto

22 propostas Projeto remoto Ativo em Dec 3, 2004

22 freelancers estão ofertando em média $6 nesse trabalho

softservicesvw

See private message.

$8.5 USD em 1 dia
(334 Comentários)
7.7
jeffreymcarthur

See private message.

$8.5 USD em 1 dia
(13 Comentários)
5.5
Return0Projects

See private message.

$4.25 USD em 1 dia
(91 Comentários)
5.3
santon

See private message.

$8.5 USD em 1 dia
(40 Comentários)
4.8
vw1202301vw

See private message.

$6.8 USD em 1 dia
(23 Comentários)
4.5
adlivw

See private message.

$8.5 USD em 1 dia
(26 Comentários)
3.9
blexvw

See private message.

$4.25 USD em 1 dia
(17 Comentários)
3.9
jacobneill

See private message.

$8.5 USD em 1 dia
(9 Comentários)
3.1
leofsiegeent

See private message.

$6.8 USD em 1 dia
(1 Comentário)
2.8
aaronfvw

See private message.

$3.4 USD em 1 dia
(4 Comentários)
2.5
vw569064vw

See private message.

$8.5 USD em 1 dia
(5 Comentários)
1.9
alibekvw

See private message.

$4.25 USD em 1 dia
(8 Comentários)
1.8
sanjogitavw

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

$5.1 USD em 1 dia
(5 Comentários)
0.0
bogdanpopescu81

See private message.

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