Posts by Vinicius Haninec Silva • 96 points
10 posts
-
1
votes3
answers933
viewsA: grade table
I see that you are using to get the values the getElementsByName method. Try using the getElementById method, which will always return only one value. I modified your Html to behave with Id instead…
javascriptanswered Vinicius Haninec Silva 96 -
0
votes3
answers944
viewsA: Return the Id of table 1 and insert in table 2 in the same code
Hello, Junior there are a few ways I would do it. See if any of these help you: Use the @@IDENTITY: @IDENTITY returns the last ID inserted in the database, independent of the table. If you are sure…
-
0
votes3
answers727
viewsA: Problem with INSERT INTO
I believe the problem is in your user’s default schema which is not dbo. To check if this is so, just put [dbo]. [Visitors] in INSERT INTO and see the result. If it works as expected, you can leave…
-
1
votes1
answer742
viewsA: Select Gridview line with checkbox
Willian, it is not calling the function again. The stretch you are doubting means: Should there be the event of click in the element, then call the Select(this, color) method again. The parameter…
-
0
votes1
answer663
viewsA: LEFT JOIN with WHERE in the field of the first table OR field of the second table
Hello, Baldner Check if this helps you: /* Adquirindo os registros da tb1 que possuem registros na tb2, ou seja, os 5% */ SELECT tb2.numero_novo AS numero FROM tb2 INNER JOIN tb1 ON tb1.id = tb2.id…
-
2
votes1
answer2617
viewsA: How to use the current date in a trial?
Hello, André Try to remove the GETDATE() function from the Procedure call. A solution would be to leave it in a variable and use this variable instead. Getting kind of like this: DECLARE @DataAtual…
-
1
votes3
answers12716
viewsA: SQL Grouping by name, date and quantity by month
Hello, Rafael, You need to group by date as well. Remember to delete PAPELETA_DATA date days, otherwise you will have data grouped by days. This is why you use functions MONTH and YEAR. This is more…
-
1
votes2
answers175
viewsA: Doubt in query mount with INNER JOIN
Your answer is in UNION. Briefly you can insert other queries in the return but they should return the same number of columns being of the same type. Concatenate the following passage: UNION SELECT…
-
1
votes1
answer505
viewsA: Begin transaction is blocking my entire database
Bruno, When we open a transaction all the tables involved in your script will be locked for use until the transaction is completed. SQL Server, and other Dbms, use this technique to prevent others…
-
1
votes1
answer611
viewsA: Select from two tables and insert into two other at the same time
Joelias, As commented, it is not possible to accomplish what you want with just one INSERT because we have two destinations to be inserted (B, D) but I believe that its objective is to avoid the use…