jonathan_blac15 (7/27/2014)

---

Hi all,

I'm hoping someone can help as I'm clueless 🙂

I'm looking for some TSQL script that filters the method field by A, except for the latest date which I need to filter by B. The script is run each month so the latest date varies each run.

Date method

01/05/2013 A

01/05/2013 B

01/05/2013 C

01/05/2013 D

02/05/2013 A

02/05/2013 B

02/05/2013 C

02/05/2013 D

03/05/2013 A

03/05/2013 B

03/05/2013 C

03/05/2013 D

07/08/2014 A

07/08/2014 B

05/09/2014 A

05/09/2014 B

Many thanks