Posts by Rafael S. • 51 points

• 3

  votes

  1

  answer

  62

  views

  Q: View with many, but many case when’s

  I’m riding a view in the database that the view pai uses as another query view, which in turn calls again view (in that view is made the sum of several items and brings the total per line), in view…

  sql database view case

  asked 5 years, 5 months ago Rafael S. 51

• 2

  votes

  1

  answer

  235

  views

  Q: Pick up day of the week in a select

  I need to know how to get inside a select (with LEFT JOIN, INNER JOIN) take the day of the week from a field of a table, compare and see which day of the week, if it is 1 add 2, if it is 7 add 1?…

  sql sql-server query server

  asked 5 years, 10 months ago Rafael S. 51