This is something I should know but for whatever reason today it is eluding my mind. I'm trying to query our database to provide me with data between March 2012 and March 2013. Initially, I had the following line:
where a.IPI_Ref_Date between '2012' and GETDATE()
and the output was from Jan-2012 to our most recent April 2013. The information request (IR) I received changed in that the person asking for the IR now wants the data to be from March to March but my statement is getting all messed up because I'm not querying this right. I'd show what I've tried but I don't see a point in offering bad SQL statements. Can someone please advise me so that I can do this right?