Calculate an Amount at the end of month

Giovanbattista Barra

7y792

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tamal Marick7y ago
SELECT loanNR, eomonth(dateadd(mm,-1,getdate())) AS restcapital
FROM [dbo].[Loanplan]

Write your condition in place of eomonth(dateadd(mm,-1,getdate())), whatever do you want.
0
Giovanbattista Barra7y ago
thanks for your reply Tamal.

The query must return two columns: loanNR and restcapital.
The restcapital must be calculated under a condition which is eomonth(dateadd(mm,-1,getdate()))

How can I build the query so that I get 2 columns, loanNR and restcapital under its condition eomonth?
0
Tamal Marick7y ago
Could you please clarify your question? What are you looking for? which two columns are you need to returns and in what's manner?
0