Posts by Sergio Paiva • 15 points
4 posts
-
0
votes0
answers34
viewsQ: Take the contents of the columns that are inside a while
Good night! I’m trying to use the speakers of the second while to insert into a table, but I can’t get the value of the columns. I’ve used several combinations of quotation marks and nothing. This…
sqlasked Sergio Paiva 15 -
0
votes1
answer227
viewsQ: Select records between two dates with pre-established minute intervals
I have a table that stores data collected at five-minute intervals. I would like to select the records between an initial date/time and the final date/time. So far I can do it. Only that I would…
sqlasked Sergio Paiva 15 -
0
votes2
answers182
viewsQ: Write data to a based table and two other tables
Hello! I am new in sql Transact and would like and have the following situation. I have a table that contains the list of columns in a second table. That’s right! In table B the names of the columns…
sqlasked Sergio Paiva 15 -
1
votes1
answer1067
viewsQ: Difference between hours and minutes days in Sql Server?
I got two columns like datetime. I have tried in many ways to catch the difference between them, but the number of days is always incorrect. Example: Data1: 2018-01-17 17:00:00 Data2: 2018-01-18…