Lengkap

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

Kemahiran: .NET, Kejuruteraan, MySQL, PHP, Kejuruteraan Perisian, Ujian Perisian, SQL, Visual Basic, Pengehosan Web, Pengurusan Laman Web, Ujian Laman Web

Lihat lagi: 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

Tentang Majikan:
( 71 ulasan ) maryville, United States

ID Projek: #2979613

Dianugerahkan kepada:

yenduttjain

See private message.

$2 USD dalam sehari
(117 Ulasan)
6.6

9 pekerja bebas membida secara purata $4 untuk pekerjaan ini

TakeRealUK

See private message.

$4.25 USD dalam sehari
(556 Ulasan)
6.7
avichapman

See private message.

$3.4 USD dalam sehari
(28 Ulasan)
4.5
arkinfotech

See private message.

$4.25 USD dalam sehari
(5 Ulasan)
3.9
jspsenthilvw

See private message.

$4.25 USD dalam sehari
(22 Ulasan)
3.9
notusinganymore

See private message.

$4.25 USD dalam sehari
(27 Ulasan)
3.2
stolevw

See private message.

$4.25 USD dalam sehari
(28 Ulasan)
2.6
soulcodervw

See private message.

$4.25 USD dalam sehari
(4 Ulasan)
1.6
ishwargoyal79

See private message.

$4.25 USD dalam sehari
(0 Ulasan)
0.0
vw971268vw

See private message.

$4.25 USD dalam sehari
(0 Ulasan)
0.0