Posts by Samuel Fales • 14 points

• -1

  votes

  1

  answer

  298

  views

  A: Query Union, group by and Count in the same query filtering by date range

  Create the initial structure as a table.. select * from ( select "Cliente"."Nome" as Conveniado, "Municipios"."Nome" as Cidade, "Estado"."Nome" as Estado, 'ATIVO' as status from ((((dbo.Pedidos prt…

  sql-server

  answered 7 years, 8 months ago Samuel Fales 14

• 0

  votes

  1

  answer

  70

  views

  A: Receive parameter and depending on the value run a specific process

  Create a single file and run this selection within the same Sql server. declare @typoagenda int set @gendoagenda = 1 if @typoagenda = 1 Begin print 'exec Verified Available' end Else if @typoagenda…

  sql-server asp

  answered 7 years, 9 months ago Samuel Fales 14