Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Hi AllI would like to write a query that will return all requests from Customer_infor table where the eligthrudate is someday between the month and not first and last day of the monthSample Datarequestid EligThruDate218584 12/27/12221328 09/01/10221340 12/31/09221355 07/24/12My query should not return becasue the eligthrudates are on the first or last day of the month and any other requests with other dates should be ignored221328 09/01/10221340 12/31/09Need helpthanks
Lamprey
Master Smack Fu Yak Hacker
4614 Posts
Posted - 2013-04-26 : 12:42:23
Please put your data in a consumable format so you can run queries against it. Here is one (poor) solution: