Skip to content

Instantly share code, notes, and snippets.

@yurivasconcelos
yurivasconcelos / sql.sql
Created May 14, 2020
query generated from new summary footer
View sql.sql
select
'' as "entityId",
'' as "rowTagTeamDeactivated",
'' as "entityName",
'' as "dp-val-0",
sum("dp-val-1") as "dp-val-1",
sum("dp-val-2") as "dp-val-2",
(sum("cal-dp-val-3-0-0") / nullif(sum("cal-dp-val-3-0-1"), 0)) * 100 as "dp-val-3",
sum("cal-dp-val-4-0") / nullif(sum("cal-dp-val-4-1"), 0) as "dp-val-4",
sum("cal-dp-val-5-0") + sum("cal-dp-val-5-1") + sum("cal-dp-val-5-2") as "dp-val-5"
View test.cs
public IActionResult(){
bool testing = true
while(testing == true){
i=i+1;
break;
}
return i;
}
You can’t perform that action at this time.