Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: edilsoneto
- Order by date
-
SUM SQL
DDR, quero fazer a soma dos valores do select. Pela função SUM, aqui estao os selects e a estrutura das tabelas. SELECT ROUND((TITULO.VR_PAGO/TITULO.VR_PAGAR-1) *ISNULL ((SELECT ISNULL (SUM(VR_LANCAMENTO),0) FROM LANCAMENTO_RECIBO WHERE LANCAMENTO_RECIBO.CD_IMOVEL = RECIBO.CD_IMOVEL AND...- edilsoneto
- Post #7
- Forum: Microsoft SQL Server: Programming
-
SUM SQL
Table LANCAMENTO_RECIBO CREATE TABLE [dbo].[LANCAMENTO_RECIBO] ( [NR_LANCAMENTO] [decimal](18, 0) NOT NULL , [CD_TP_LANCAMENTO] [int] NULL , [VR_LANCAMENTO] [decimal](15, 2) NULL , [DS_HISTORICO] [char] (100) NULL , [DT_COMPETENCIA] [datetime] NULL , [CD_PESSOA_FUNCIONARIO] [decimal](7...- edilsoneto
- Post #5
- Forum: Microsoft SQL Server: Programming
-
SUM SQL
See Tables. CREATE TABLE [dbo].[TITULO] ( [NR_TITULO] [decimal](12, 0) NOT NULL , [NR_BORDERO] [int] NULL , [NT_TITULO] [char] (1) NULL , [CD_CATEGORIA] [int] NULL , [CD_PESSOA] [decimal](7, 0) NULL , [CD_AGENTE] [int] NULL , [CD_TP_TITULO] [char] (1) NULL , [CD_TP_COBRANCA] [int] NULL...- edilsoneto
- Post #4
- Forum: Microsoft SQL Server: Programming
-
SUM SQL
Where write SUM?? VALOR ---------------------------------------- 5.540000 .000000 .000000 .000000 6.360000 (5 row(s) affected) not!!! VALOR ??????????? ---------------------------------------- ??????? 11.900000 ???????? ((((((((???))))))))sum(valor) SELECT...- edilsoneto
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
