Em Andamento

SQL STATEMENT NEEDED IMMEDIATELY

Greeting coders. I am stumped on a SQL statement that is driving me nuts. I have a sales table that I am trying to analyze for a client. The structure is as follows.

TRANSNO (unique identifier)

quant (int)

cat (varchar)

price (varchar)

TRANSNO has the following construction:

7 characters total

1st character is the store (a letter)

2nd character is the register # (a number)

remaining 5 are the transaction #

distinct first characters (stores) are M,T,P,S,K,G,F

here's what i'm wanting to do:

i want the sum of qty sold for each store to be returned in 1 record

This statement:

SELECT DISTINCT LEFT(transno, 1) AS Expr1, SUM(quant) AS storetot, SUM(quant * price) AS store_$

FROM dbo.bw_registers

GROUP BY LEFT(transno, 1)

is VERY close but it returns each store's TOTAL # PIECES SOLD, AND TOTAL DOLLARS SOLD information on a separate record. I want them all in one record.

This is a quick solution for an experience SQL programmer and your help is greatly appreciated. I need the sql statement asap ON 9/24/03.

## 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) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

SQL SERVER 2000

Habilidades: .NET, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: what is package in sql, the p.i.c. group, structure stores, sql programmer software, sql price, programmer sql, php sql programmer, php and sql programmer, needed visual basic programmer, 5 dollars store, t-sql in, sql experience, p sql, sql server programmer, t-sql;, sql work needed, m@sum, complete construction group, cat solution, cat character, statement structure sql, php sql 2000, statement letter, sql statement help, sql run package

Acerca do Empregador:
( 71 comentários ) maryville, United States

ID do Projeto: #2979613

Premiar a:

yenduttjain

See private message.

$2 USD em 1 dia
(117 Avaliações)
6.6

9 freelancers estão ofertando em média $4 para este trabalho

TakeRealUK

See private message.

$4.25 USD em 1 dia
(556 Comentários)
6.7
avichapman

See private message.

$3.4 USD em 1 dia
(28 Comentários)
4.5
arkinfotech

See private message.

$4.25 USD em 1 dia
(5 Comentários)
3.9
jspsenthilvw

See private message.

$4.25 USD em 1 dia
(22 Comentários)
3.9
notusinganymore

See private message.

$4.25 USD em 1 dia
(27 Comentários)
3.2
stolevw

See private message.

$4.25 USD em 1 dia
(28 Comentários)
2.6
soulcodervw

See private message.

$4.25 USD em 1 dia
(4 Comentários)
1.6
ishwargoyal79

See private message.

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

See private message.

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