SELECT dbo.RE80_MOVSCHPUNTI.RE80_DATAMOV, dbo.RE80_MOVSCHPUNTI.RE80_VALORE, dbo.RE80_MOVSCHPUNTI.RE80_INDTIPOMOVSCH

+dbo.RE80_MOVSCHPUNTI.RE80_DATAMOV(DateValue),

+dbo.RE80_MOVSCHPUNTI.RE80_VALORE(nvarchar),

+ dbo.RE80_MOVSCHPUNTI.RE80_INDTIPOMOVSCH(INT),

+ dbo.RE14_DOCTESTATA.RE14_IDNEGOZIO_RE05 (INT)

FROM dbo.RE80_MOVSCHPUNTI INNER JOIN

dbo.RE14_DOCTESTATA ON dbo.RE80_MOVSCHPUNTI.RE80_IDDOCTESTATA_RE14 = dbo.RE14_DOCTESTATA.RE14_ID

WHERE (dbo.RE80_MOVSCHPUNTI.RE80_INDTIPOMOVSCH = 1) AND (dbo.RE80_MOVSCHPUNTI.RE80_DATAMOV = CONVERT(DATETIME, 'DATA RANGE', 102)) AND

(dbo.RE14_DOCTESTATA.RE14_IDNEGOZIO_RE05 = 1)

Result that i need...

Thanks Antony i'm trying to explaine

i Have table RE80_MOVSCHPUNTI

in table A (RE80_VALORE) have value in NVARCHAR

in Table B (RE80_DATAMOV) have date for extract the value of Table A

and Table C...

Have to sum value in RE80_VALORE selecting determinate date range using RE80_DATAMOV

ok it' correct, i want to add other column to select,

it's RE80_DATAMOV i need it for select period to check this value

• This reply was modified 4 years, 9 months ago by  ibrahimovich87.
• This reply was modified 4 years, 9 months ago by  ibrahimovich87.

Hi john haven't only tried to see wich values have in this table, need only to check and SUM all Values until first number after  decimal point

Hi jhon can you explain me how do it?? In thi table have all values that it's "numeric" like this (i0m sorry but i'm really newbie with sql)

0,38

12,90

13,05

15,00