Posts by Bcar • 31 points

• 2

  votes

  1

  answer

  81

  views

  Q: Count in Past Time Intervals

  Good morning ! I have a view with contracts, and in it there is a column for Dtiniciovigencia (DATE) and a column Dtfimvigencia (DATE). I needed to count the number of active contracts for each of…

  sql sql-server

  asked 4 years, 11 months ago Bcar 31

• 1

  votes

  1

  answer

  41

  views

  Q: Concatenate with specific format

  I need to concatenate two columns, a year and a month, but still keep a number of characters limited to six. And when the month is less than 10 the output brings the concatenation but only with 5…

  sql sql-server

  asked 5 years, 1 month ago Bcar 31