Posts by Ariel Gonçalves • 81 points
7 posts
-
0
votes2
answers133
viewsQ: Unify multiple worksheets from different workbooks
I have 800 Excel folders containing 1 sheet each, I need to unify these sheets into a single... I only need the columns A and B of each sheet and that it always paste the columns in the next free…
-
1
votes0
answers708
viewsQ: How to send the result of a query via email
I wonder if anyone could tell me how I can perform the below query correctly. I need this to be sent to the email showing the result that in the case would be Name : Ariel [select rtstr1 as hostname…
-
0
votes3
answers928
viewsA: Update in a field that cannot be negative
That’s how it’s really in the field but on a different record…
-
0
votes3
answers928
viewsQ: Update in a field that cannot be negative
I need to make a update in a given field, where it should reach at least up to "zero" cannot be negative. And when it reaches zero I need it to give the update of the remaining quantity in the next…
-
2
votes0
answers201
viewsQ: Turn Column into "Pivot" row
I’m trying to turn the column "prtnum" branded yellow in Line, I’m trying to use the PIVOT but I’m not succeeding I’ve tried some ways and not right: Select Distinct (ORD_LINE.ordnum),…
sqlasked Ariel Gonçalves 81 -
3
votes0
answers143
viewsQ: How to fix intersection points to calculate the distance between points?
I need to calculate the distance between points within the place where I work, so I calculated the coordinates of each location in X and Y and I launched the coordinates into the system. I’m making…
oracleasked Ariel Gonçalves 81 -
2
votes1
answer231
viewsQ: How to calculate the distance between X and Y with Intersection points
In the image above I have mapped the separation positions within the warehouse where I work. I need to calculate how far the person you’re separating travels inside the warehouse. For example if the…