This question already has an answer here:
I am extremely new to SQL. I am operating on SQL Server 2012.
I am working with an Inventory file that contains the Date the Inventory was taken, item #, and quantity. The first and last day of each month of the data set is wrong. My goal is to remove just the rows that contain the first and last day of each month. Any help/ideas would be greatly appreciated.