I’m trying to calculate a value in a query and if I do it one way it works but when I do it the way i need it to work I always come up ..
Tag : sql
I’ve used the search function quite a bit on this topic but all results seem to differ a bit from what I am trying to achie..
I have this query but the max and avg don’t seem to work as exp..
I am trying to do a simple math equation in SQL Server and cannot figure out why the number is rounding to the nearest in..
I created a report in visual studio and the report has total of many columns. I need to export the report to excel and then If I delete any row from the excel sheet the excel should automatically calculate the t..
I’m trying to join 3 tables and somehow, I’m getting a duplicate record with a different variant in one of my date columns. for reference here is the sample content of the ..
We would like to provide our DBA team with the SELECT statements that the out of box reports from Guardium use when scanning our databases to validate the accuracy and completeness. Recently I have noticed that Guardium is not picking up on a set of users that our DBA is saying is present for a DB2 server that we are scanning. I would like to provide the DBA with the SELECT statements that were ran by the Guardium report to produce the entitlement details. The DBA can then analyze the SELECT statements for acc..
I’m developing a project where I need to store and manage a large amount of location data from devices sending their positions to a server. Currently, I’m using a MariaDB SQL database, where each data entry includes fields like user_id, run_id, latitude, longitude, and acc..
Closed 2 mins ago
I am using SQL Server. I have a problem where multiple products are packed in different quantities in different boxes. Each box is identified by its specif..