Posts by Alvaro Vieira • 51 points

• 0

  votes

  1

  answer

  198

  views

  Q: fill in combobox with data from other combobox

  I have a table City where has the fields City, Status, Idpais, besides the tables State and Country. I’m making an application in c# where I use 3 combobox. When selecting the first combobox…

  c# sql

  asked 6 years, 11 months ago Alvaro Vieira 51

• 0

  votes

  1

  answer

  1538

  views

  Q: Select min() returning value other than 0

  I need to make one select where you take the lowest value found, other than 0 (zero), SELECT MIN(VALORTARIFA) MENORTARIFA FROM TABELA In the above command, if there is some value 0.00, it will…

  sql sql-server

  asked 8 years, 10 months ago Alvaro Vieira 51

• 1

  votes

  1

  answer

  468

  views

  Q: Select Comparing Periods

  I need to make one select comparing two periods of sales, totalling by product. Today I have this select that does this, but only for a period (01/09/2014 to 30/09/2014) SELECT ACC.PRODUTODESC…

  mysql sql sql-server

  asked 8 years, 10 months ago Alvaro Vieira 51

• 2

  votes

  1

  answer

  70

  views

  Q: Select checking a condition

  I need to make a select where a condition is checked. Ex: If the value of a given field is < 0 assign the sum of that field to column "PerdaGerada" otherwise assign the column "LucroGerado".…

  sql sql-server

  asked 8 years, 10 months ago Alvaro Vieira 51