Is there any way to migrate multiple columns data of table to only one column of other? I need to migrate the data of table 1 subject varchar(45) body
Problem background I am trying to pin down to what condition(s) are causing no records / rows the most, so to allow me to find the root cause of what data in th
I'm looking for the efficient way to store week days and times of each event. How do I achieve the following result Events table id name dates rel_id 1 hello w
i'm inserting multiple rows into a table using a single insert statement. The table has an auto increment field as the primary key. Like so: INSERT INTO MyTabl
I am referring to this article in order to lookup IP addresses to country: https://cloud.google.com/blog/products/data-analytics/geolocation-with-bigquery-de-id
I have a table which looks like this: ID money_earned days_since_start 1 1000 1 1 2000 2 1 null 3 1 3000 4 1 2000 5 2 1000 1 2 null 2 2 100 3 I want that rows
I have huge amount of data in Sybase DB and I made OLE DB connector in SSIS where I succesfully connected it. We are using charset = cp1250, because we have dat
I have managed to generate a single column based on multiple counts with different prefixes, as detailed here. But now I want to update an existing BigQuery col
I've got a problem with my order by clause when using a calculated column with an alias as below: This order by works without any problem declare @Mode int = 1
I am trying to make a my first relationally table structure for a tennis/Padel competition program that registers the scores (sets.)of dubbel matches(4players).
I have written scripts that check images in a directory and in a database. I need to delete images in a directory that are not in the database. How can I do thi
I have this query that receives a parameter from user input and I think that I am vulnerable to SQL injection. $query = "SELECT pcode,price,description FROM pro
I am trying to list all DEPARTMENT_IDs with PRODUCT_IDs, first where PRODUCT_COST_STATUS = 1 but there are also data with where PRODUCT_COST_STATUS = 0. I prefe
I'm struggling with the problem below. I have written CTE where I calculate quantity of headcount in year,mth and cumulatively. My code: with HRdataCTE as
I'm trying to build a select query with Spring Data Specification. The query in question is the following: SELECT * FROM product WHERE id IN (SELECT product_id
I have a table paths: CREATE TABLE paths ( id_travel INT, point INT, visited INT ); Sample rows: id_travel | point | visited -----------+-------+
I have a sample dataset like this Group Age Value A 1 A 2 0 A 3 20 B 1 0 B 2 0 B 3 25 B 4 0 B 5
I am trying to find out if there is a way to group rows in a table within a database based on the values from multiple columns. My specific problem is that I am
n real, ProductID integer , PRIMARY KEY () )
There is a table objects, which stores data on real estate objects. Me need to use a query to calculate a new field that will display the date range from Monday