Posts by Thiago Pereira • 179 points
8 posts
-
1
votes1
answer51
viewsQ: Add separate lines of a child table with values of a parent table without duplicating the values of the parent table
There is a SALE table that generated 2 records in the DOCUMENT table I needed to show the total sum of value fields of these two lines (showing row by row), but they need to add with some value…
-
0
votes1
answer25
viewsQ: Manipulate string with Substring
I’m trying to manipulate a string I’m running the code: string oldString = ",,,,,1001,1002,1003,1004,1005,1006,1007,1008"; string newString = oldString.Substring(oldString.IndexOf("1")); I want the…
c#asked Thiago Pereira 179 -
1
votes2
answers788
viewsQ: Problem with CASE WHEN SQL-SERVER
SELECT CASE WHEN VALOR > 0 THEN VALOR ELSE "Não tem" END AS NOMECOLUNA FROM BLABLABLA I am having an error where it is not possible to convert "has not" to int. The point is that I wanted it to…
-
4
votes2
answers1920
viewsQ: How to modify commits that were not pushed
I need to edit a commit message and add another file. I haven’t pushed the commit yet, there’s a way to fix it?
-
0
votes1
answer70
viewsA: Gives an error in the "if" but does not say which error is! visualg
algoritmo "tinder" var l, m, i, b, c, s: logico pri, seg, ter: logico andressa, monica, leticia, eduarda, maria, ana, clarisse, joana: logico formula: inteiro inicio escreval…
visualganswered Thiago Pereira 179 -
4
votes2
answers58
viewsA: Left Join in SQL
SELECT SUM(DOC.TAXAS) FROM DOCUMENTOS DOC LEFT JOIN PARCELAS PARCELA ON (PARCELA.CODE = DOC.CODE) WHERE PARCELAS.FATURADAS = 1 You put IN when it should be ON and it should be 1 instead of true This…
sql-serveranswered Thiago Pereira 179 -
2
votes1
answer94
viewsA: SQL Server JOINS vs Subquerys
I would use the first one, I know it’s not a rule and it depends a lot on the amount of records in addition to other things, but in many cases using sub-queries makes the query a little less…
-
2
votes1
answer213
viewsA: Performance with Exists
In some tables, when you use Joins, some values can be duplicated in some relationships, so he has to search multiple lines within that same guy, but if you use distinct, he’ll just look for the…