Posts by W.S. Silva • 5 points

• 0

  votes

  1

  answer

  858

  views

  Q: Convert to decimal without adding zeros - SQL Server

  I am converting a number from varchar to decimal. This number already has the boxes after the comma, and when I convert it adds 2 more zeros. Example: 12.345,67 ---> 1234567,00 The code I’m using…

  sql sql-server type-conversion conversion

  asked 6 years, 4 months ago W.S. Silva 5

• 0

  votes

  2

  answers

  1867

  views

  Q: View with double SELECT from the same table

  I need to build a VIEW with three fields, but one depends on the other to be calculated (two of them are from the same table on different lines need "link them"), how do I aggregate these fields in…

  sql sql-server select select-sql sql-view

  asked 6 years, 7 months ago W.S. Silva 5