I have a SQL Query, which I want to use in VBA to load the data into Excel, the problem is that when the load is done the data in Excel is with the wrong type. For example, where it needs to be a date,…
Tag: sql
installing h3 python library on AWS Redshift for usage in an UDF
I was trying to install the python library from ubers H3 as a custom library for aws redshift by using this for the installation. I followed the process and created the following function: When executing it with: I receive the following error: OSError: /rdsdbdata/user_lib/0/0/1334190.zip/h3/out/libh3.so.1: ca…
SQL output parameter of varbinary to use as image on ASPX web form
I am trying to retrieve the logo stored into my table and display the image from the database to my aspx web page. I have output parameters in a SQL stored procedure which output the name and a …
How to use WHERE query at same column in same table?
I have this data. tbl_data id value 1 A 1 B 1 C 2 A 2 C I want to select id which have ‘A’ and ‘B’ as value. SELECT id FROM tbl_data WHERE value = ‘A’ AND value = ‘…
How to convert average time returened from sql query to minutes [closed]
I am running the following query SELECT SEC_TO_TIME(AVG(TIME_TO_SEC(Response_Time))) as avg_time FROM Case_report where Reporting_Time between “‘.$fromdate.’” and “‘.$todate.’” and …
Select data from Datagridview using checkedlistbox [closed]
I’ve got a datagridview in my form and also a checkedlistbox. I’ve written some code so that I can filter the datagridview with whatever is checked in the checkedlistbox. Although, it will only filter …
SQL if not null update
I have this query UPDATE users SET username = Param1,email = Param2,PASSWORD = Param3 WHERE id = Param4; this is updating my user row, but i want to say: If email OR password is not null update them …
Switch case with storing results into same table in SQL
I want to store the results into table with same name as per the condition. How to achieve the same ? Following is the code: While executing it throws error that #a already exists. IF @Input =’1′ …
The best way to store rows of the table of a document(SQL)?
I have a report that has a table. The report also has fields. For example(JSON): { company: Company, period: “3M2019”, typeReport: “type”, multiplicity: 1000 …
Search for many rows with many distinct values
I am looking to implement a cache in MySQL. I’m doing this because the app I’m developing needs a cache but has no persistence. I am keeping a collection of SHA-1 checksums for files. The user can …