Question Locked

Microsoft Visual Studio 2005 Reporting Services

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi everyone! I had a question about the query side of the reporting services...
I'm tying to develop a comparison between the most recent entry and the second most recent entry in our database... the first part would go something like this...

SELECT TOP (1) Invoice.InvoiceID
FROM Invoice INNER JOIN
WorkOrder AS InnerWorkOrder ON Invoice.WorkOrderID = InnerWorkOrder.WorkOrderID
WHERE (InnerWorkOrder.AffiliateID = Affiliate.AffiliateID) AND

//**
and this is where I need the comparison...

(DATEDIFF(m, "SECOND FROM TOP ORDER", "FIRST ORDER ON LIST") <= 13)

**//

Anyone who can help me with this I would greatly appreciate it... thank you in advance

1 reply

This discussion is closed to new replies.