Posts by Marcelo Arakaki • 1 point

• 0

  votes

  2

  answers

  162

  views

  A: 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()),…

  sql sql-server

  answered 6 years, 9 months ago Marcelo Arakaki 1

• 0

  votes

  3

  answers

  204

  views

  A: 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 ,…

  sql sql-server tsql

  answered 6 years, 9 months ago Marcelo Arakaki 1