Thanks Guys.

Created a stored procedure which is called from a batch file using SQLCMD as currently this is a development machine with SQL Express installed so no SQL Agent feature.

Please ignore last note - was being an idiot I just needed to change the code to :

with cteNotes

as(

select *,ROW_NUMBER() over (partition by Account order by Date desc,Time...

Just checked the extracted table and found that there is a TIME element field (new table attached)

Can this be used to ensure the youngest NOTE is returned?

Thanks for all your...

Great Thanks - will run the code and let you know the outcome.

As for John's valid point - I don't think we will be able to as the data exported...

Brilliant, thank you very much for your help.

Hi

Attached are the tables that I have used in this View and some sample data.

This is being picked up by BIDS and then displayed in SSRS. My end goal...

Thanks Bru - thats sorted it.:-)

OK

So I have tried this :

SELECT DATEADD(YEAR, - 2, GETDATE()) AS Expr1, DATE

FROM dbo.SalesHistory

WHERE ...

Had already attempted to use DATEADD but unsuccessfully!

I can add some code into my SELECT like

SELECT DATEADD(MONTH, -24, GETDATE())

But I am not sure how I then edit my WHERE...