Posts by rafaedez • 41 points

• 1

  votes

  1

  answer

  1111

  views

  A: Modeling database table

  Create a table that contains all fields of all groups, realize that there is ICMS90 with all fields, which is just in case there is an exception. Then create your ICMS tax table based on ICMS90…

  sql sql-server modeling

  answered 8 years ago rafaedez 41

• 1

  votes

  1

  answer

  50

  views

  A: Search Records with Latest Date Using Condition

  Coalesce can solve: SELECT fm.FIELDCODE, fm.BLOCK_CODE, bl.BLOCK_DESC, cat.CATEGORY_CODE, cat.CATEGORY_ABBREV, fm.FIELD_AREA, fm.PLANTATION_DATE, fm.HARVEST_END_DATE FROM FM_BLOCK bl,…

  sql

  answered 8 years ago rafaedez 41

• 1

  votes

  3

  answers

  2181

  views

  A: Group periods of dates

  An efficient way to do this is to get the values per column instead of rows, since you already know beforehand the desired interval of hours. This way the query is fast, because it will be passed…

  sql database oracle select

  answered 8 years ago rafaedez 41

• 1

  votes

  2

  answers

  1032

  views

  A: Bring all records if parameter is different

  Use the "coalesce" (default in all sql databases) to save a "or" in case your parameter comes null as well. SELECT * FROM Contrato WHERE completed = parameter or coalesce(:parameter,-1) not in (0,…

  sql query

  answered 8 years ago rafaedez 41