SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Help with a Select (Report)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

xrafo
Starting Member

1 Posts

Posted - 01/10/2012 :  16:59:32  Show Profile  Reply with Quote
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

USA
367 Posts

Posted - 01/10/2012 :  18:59:35  Show Profile  Reply with Quote
I'm having trouble understanding what you're looking for. Is there a problem with your query?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000