Hallo dear collegues,
I need help for a query.
I've already searched a little bit about the topic but nothing special the concerns what I'm really looking for.
I have this query:
SELECT loanNR, restcapital, eomonth(dateadd(mm,-1,getdate())) AS 'Restkapital in Vormonat'
FROM [dbo].[Loanplan]
This query delivers 3 columns, but i need only two columns.
I need the amount "restcapital" which is estimated at the end of the last month (eomonth).
Any suggestions?
Thanks in advance for the answer
Best regards
Johannes