Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Help with a Select (Report)

Author  Topic 

xrafo
Starting Member

1 Post

Posted - 2012-01-10 : 16:59:32
Hi All, i have this data:
declare @vartable TABLE(
PAY_CYCLE varchar(50),
PAY_CYCLE_SEQ_NUM INT,
VOUCHER_ID varchar(50),
VENDOR_ID FLOAT,
NAME1 varchar(150),
TXN_CURRENCY_CD VARCHAR(50),
GROSS_AMT FLOAT,
PYMNT_GROSS_AMT FLOAT,
PRCNT_WTHHLD FLOAT,
CO_DSCTO_RETEN FLOAT,
CO_DSCTO_DETRAC FLOAT,
CO_DSCTO_OTROS FLOAT,
CO_A_PAGAR FLOAT,
PYMNT_RATE_MULT varchar(50),
PYMNT_RATE_DIV varchar(50),
EXPR varchar(50),
VOUCHER_ID2 varchar(50),
PYMNT_SEPARATE varchar(50),
DOC_TYPE varchar(50)
)
INSERT INTO @tabla
SELECT 'PTSOL',38,'SCE04753',0000000015,'CATERPILLAR LEASING CHILE SA','PEN',3570.000,1791.960,6.00,134.010,0.000,0.000,1791.960,1.00000000,1.00000000,'0000000015','SCE04753','N','01' UNION ALL
SELECT 'PTSOL',38,'SCE04900',0000008798,'VCI CONSTRUYE S.A.C.','PEN',1180.000,1038.000,12.00,0.000,142.000,0.000,1038.000,1.00000000,1.00000000,'0000008798','SCE04900','N','01' UNION ALL
SELECT 'PTSOL',38,'SCE04901',0000008798,'VCI CONSTRUYE S.A.C.','PEN',1180.000,988.000,12.00,0.000,142.000,50.000,988.000,1.00000000,1.00000000,'0000008798','SCE04901','N','01' UNION ALL
SELECT 'PTSOL',38,'SCE03132',0000010035,'S.A DE COMERCIO Y SERV. DE INGENIERIA','PEN',214.200,214.200,0.00,0.000,0.000,0.000,214.200,1.00000000,1.00000000,'0000010035SCE03132','SCE03132','Y','01' UNION ALL
SELECT 'PTSOL',38,'SCE04751',0000010035,'S.A DE COMERCIO Y SERV. DE INGENIERIA','PEN',11800.000,5059.930,6.00,322.970,0.000,0.000,5059.930,1.00000000,1.00000000,'0000010035','SCE04751','N','01' UNION ALL
SELECT 'PTSOL',38,'SCE04899',0000010035,'S.A DE COMERCIO Y SERV. DE INGENIERIA','PEN',1000.000,780.750,6.00,49.830,0.000,0.000,780.750,1.00000000,1.00000000,'0000010035SCE04899','SCE04899','Y','AP_PAGOS'

select * from @vartable


and the report it's:
vendor_id <voucher_value> caterpillar leasing chile
voucher txn_currency gross_amt prcnt_wthhld co_dscto CO_DSCTO_DETRAC CO_DSCTO_OTROS CO_A_PAGAR
SCE04753 PEN 3570 6 134,01 0 0 1791,96

total 3570
co_dscto 134,01
CO_DSCTO_DETRAC 0
CO_DSCTO_OTROS 0
CO_A_PAGAR 1791,96

In the report data is grouped by vendor_id and then the voucher_id

conditions exist, if the voucher value is 'N' go together on the same sheet and the total sum, and when they are separated with Y .. (not in the same block)

Any recommendations please!

influent
Constraint Violating Yak Guru

367 Posts

Posted - 2012-01-10 : 18:59:35
I'm having trouble understanding what you're looking for. Is there a problem with your query?
Go to Top of Page
   

- Advertisement -