Posts by Layla Comparin • 553 points
20 posts
-
2
votes2
answers203
viewsQ: Query data with mask - SQL Server
I have the following structure: http://sqlfiddle.com/#! 9/29027c4/1 CREATE TABLE PATRIMONIO ( NUM_PATRIMONIO VARCHAR(100), DESCRICAO_PATRIMONIO VARCHAR(100) ); INSERT INTO PATRIMONIO VALUES…
sqlasked Layla Comparin 553 -
0
votes1
answer31
viewsQ: Upload data to Azure
Does anyone know if there is a possibility of uploading data from a file to a Datalake in Azure? For example, a Datatools service would run and it would access a repository within a user machine,…
-
1
votes3
answers1103
viewsQ: Align button on the left side of a div
The problem is that I have a button that sits above a field input it should be on the left side. So, instead of showing like this: He shows himself so: Code The code of the button in question is:…
-
1
votes2
answers131
viewsQ: How to adjust an anchor button to stand next to a`select`field in Bootstrap?
The problem is that I have a button that eventually expands down a field select and should stand on the right side of it. So, instead of looking like this: Him looks like this: Code The code of the…
-
1
votes1
answer46
viewsQ: "Less" value is removed in R
I have a df that contains negative times, for example: -1:-14:-56 I would like to take all times that were less than 00:00:00 and put 00:00:00 in place. I am currently doing a very manual job in…
rasked Layla Comparin 553 -
0
votes2
answers253
viewsA: File Import in R - Taking only part of the name
I managed to solve with the following command: setwd("C:/tmp/") vetor = grep("report-R041", dir(), value = T) df041 = readxl::read_xlsx(vetor [length(vetor)], skip = 7) :)…
ranswered Layla Comparin 553 -
3
votes2
answers253
viewsQ: File Import in R - Taking only part of the name
To with a local file xlsx, only that the file name is random (changes date and time at the end of the file name), and wanted to know if you can read the file only by the beginning of the name.…
rasked Layla Comparin 553 -
8
votes2
answers1771
viewsQ: Turn columns into rows
I have the following structure: http://sqlfiddle.com/#! 9/738aa6/1 CREATE TABLE Viagem ( Idasemvolta int, Idacomvolta int ); INSERT INTO Viagem VALUES (64, 39) With the following select: select…
-
0
votes1
answer93
viewsA: How to merge several updates into different tables?
I was able to solve it with Reginaldo Rigo’s help as follows: update reference_bankaccount set internalid = v.internal_id from contract_reference v where v.external_id = externalid and internalid =…
-
2
votes1
answer299
viewsQ: Extract column text from a table
I have the following table structure: The field metadata is like text type, but I believe it is actually a JSON. When I do: SELECT metadata FROM maxpay.mp_pay_orders; The result is:…
mysqlasked Layla Comparin 553 -
4
votes2
answers66
viewsQ: Search two numbers at once
Maybe that question has even been answered already, but I don’t know how to do it, and I fell into the typical XY problem. I have a table that has several ids, and I need to search two id’s, 34 e 5.…
mysqlasked Layla Comparin 553 -
1
votes1
answer32
viewsQ: Pick up a user’s first and last entry
I have the following query: Sqlfiddle The question is as follows. In this table there are several interactions of several users in the same transaction. What I need is to take the last user’s…
mysqlasked Layla Comparin 553 -
4
votes2
answers58
viewsQ: Difference between two dates with time greater than 24 hours?
I have the following query: Sqlfiddle Past 24 hours, it Zera the time and starts counting again. I need to draw the difference between the hours, as long as they have to pass 24 hours. For example,…
mysqlasked Layla Comparin 553 -
0
votes4
answers169
viewsA: I can’t convert seconds into minutes
I was able to solve the problem with the following query: SELECT TIME_FORMAT((TIMESTAMP(SEC_TO_TIME(round(SUM(TIMESTAMPDIFF(second,DATEFIM,DATEINI))/count(*),0)))),'%H:%i:%s') as `Tempo Médio de…
mysqlanswered Layla Comparin 553 -
0
votes4
answers169
viewsQ: I can’t convert seconds into minutes
I’m doing the following query: SELECT SEC_TO_TIME(sum(Total_Segundos_Consumidos)/count(distinct IDTRANSACTIONS)) AS `Tempo Médio` FROM (SELECT IDTRANSACTIONS,…
mysqlasked Layla Comparin 553 -
5
votes1
answer322
viewsQ: Concatenate columns into rows
I’m trying to take several columns and turn them into a single row, but without success. That’s the select I’m trying to make: SELECT (`dias2produto`+`dias4produto`) as 'Até 4 dias',…
-
3
votes1
answer93
viewsQ: How to merge several updates into different tables?
I have 3 updates, and the tables that I have to give the updates have over 2 million records, so it would be impossible to do one by one, since each takes more than half an hour to run, and waiting…
-
2
votes1
answer664
viewsQ: Problem in a simple Inner Join Update
I’m running a simple update on my base, however set which I am giving, is being replicated for all rows of the table. Follow the script executed: update reference_vendor set internalid =…
-
1
votes1
answer95
viewsQ: How to take the variation with respect to the number of days of the date difference in R
I have a table in csv with 5 information, two with dates, two with prices, and one with the difference between dates. I have date 1 fixed on a date and date 2 varying. For example: 10/01/2018 >…
-
1
votes1
answer123
viewsQ: Is there any way to get the standard deviation (R) percentage?
For example.. I have a number of values (prices) related to a product on several different dates. I need to get the percentage change of that amount. Currently, prices are giving a standard…
rasked Layla Comparin 553