Posts by Marcilio Eloi • 325 points
11 posts
-
1
votes1
answer132
viewsA: Creation query using PIVOT in SQL
I was able to solve it, I created a row_number to number the beats that are 4, then I used them to create the columns and used it in the pivot, it worked out, thanks. SELECT CHAPA, NOME, SECAO,…
sqlanswered Marcilio Eloi 325 -
1
votes1
answer132
viewsQ: Creation query using PIVOT in SQL
Dear I need to display the result of this query in columns, each row represents an employee’s point marking on the day, I’m trying to use the pivot, but I’m not getting.…
sqlasked Marcilio Eloi 325 -
1
votes3
answers678
viewsQ: How to change the background of the radio button when it is selected
I have the following problem, I have in my form several questions that are treated using the radio button, as print attached. I am using jquery to change the color of the button when it is selected,…
-
2
votes4
answers2082
viewsQ: Compare a table field with another table
I am trying to create a query in SQL Server to know if the city that was filled in at the time of registration that the person did, is equal to a city field of another table that already has all the…
-
5
votes3
answers1988
viewsQ: How many days to a date
Does anyone have a query in sql server that returns how many days to a date? I have the employee’s admission date, I need to know, how many days are left to complete 45 days and how many days to…
-
1
votes1
answer324
viewsQ: Make Trigger run update after Procedure has been run
I would like to know how I do in SQL Server for a Trigger check if the trial was executed and if it was executed, this Rigger will do another update. Thanks for your attention. Att, Marcilio…
-
1
votes1
answer464
viewsQ: Procedure to delete and then insert data
Someone could guide me on how to build a database to delete data from a table (already created with SELECT INTO), every day such an hour and then fill it again. Thank you for your attention.
-
0
votes1
answer62
viewsA: Doubt Beginner SQL
The first query is returning the ID, is performing a sum and putting the result of this sum with integer, then these quotes and the + sign is concatenating (joining) joining the result with the…
-
2
votes3
answers2863
viewsA: Copy data from one table to another without entering field by field
I managed to solve using SELECT * INTO, I thank you all for your attention.
-
3
votes3
answers2863
viewsQ: Copy data from one table to another without entering field by field
Does anyone know the SQL command that copies the data from one table to another table, without having to clarify all the fields of the original table? I know there is a way but I forgot how it does…
-
2
votes2
answers10301
viewsQ: How to give a SELECT in multiple databases at once?
I have several databases on my server and I need to perform a query to return some information from a table that exists in all these other databases. How can I make a SELECT on several bases at the…