Posts by Marcelo Arakaki • 1 point
2 posts
-
0
votes2
answers162
viewsA: Previous dates
If you do this by query here resolves, you will always get the start date and end date of the month before the current. Select Convert(DateTime, Convert(Varchar(6), DateAdd(Month, -1, GetDate()),…
-
0
votes3
answers204
viewsA: Order by or filter in Sql Server
What you want can’t be solved with Cross Apply? Here’s an example of how to use, you’re just not ordering, but then you edit for what applies to your case. SELECT Employee.EmployeeId , FirstName ,…