(I’m not sure if I’m using the correct title… please let me know if you think it should be changed to something else) Hi, I’m trying to select substring with different starting location. I have a table like this, Req: I’m trying to get a table like this: After googling around, I …
Tag: sql
How to update a specific value of a object present in array of object within Postgres JSON Field
Here is my JSON field value. which is stored in the PostgreSQL table. I want to search and update the specific user_name in the user key whose name is Devang to Dev using Django JSONField for example I have tried the RAWQuery for the find. This is the query. It will return like this I have also tried JSON_SET…
Pivoting a table of survey data in SQL without PIVOT
I have a table called Responses which contains survey responses using the following structure. This is data for two different survey responses. Each survey has 4 questions (QuestionIDs) but the last one (long text) is optional, so some responses only have 3 rows of data. The first question (QuestionID “…
time data ‘(datetime.date(2021, 7, 30), )’ does not match format ‘%Y/%m/%d’
I am accessing date from database using below query, in my jupyterLab notebook: it is giving this ValueError: time data ‘(datetime.date(2021, 7, 30), )’ does not match format ‘%Y/%m/%d’ can anyone guide, the correct way pls? Answer Seems like c_date is already a datetime.date object. Y…
String date to SQL datetime conversion ‘Mon Dec 09 2019 12:00:54’
I have a field in database which has date time saved in string format like this. Mon Dec 09 2019 12:00:54 I want to convert this to SQL Datetime. I tried by splitting but it is not working for me. Answer SQL Server is pretty flexible about recognizing formats for date/time values, but not with the day of the …
Whats the right syntax to CONCAT in wpdb?
I’m quiet new in working with wordpress database tables. So far I know because of the wpdb documentation how to update a row in a table. Now i want to achive to update the row and keep the old data in that row. I’ve read that you can use the CONCAT function to get this working but I’ve no cl…
Select rows after the current row which are null and combine them to rows
I have written the following SQL code to display the data as rows, where the row after data is having null values except on the description column. This results in the output as follows: I have written the following query to group and display rows: The data is displayed as follows Expected output is as follow…
Find the latest version of a dataset available in SQL Server on specified dates, using RStudio
Each month I run a script in RStudio, on the 9th of the month. I need to manually append the latest DATAyymm sql data set onto the my_data vector, before running the script. Is there a way I can have the program automatically create this vector? Maybe it could connect to SQL Server and find what the latest av…
How can I get specific rows in a table by the value of a specific queried column of a different table?
I have the Table1 and the Table2 tables. Table1 has the B (Primary Key) and IC columns. Table2 has the CC, SC and IC columns: Table Table1 … B IC … … B1 IC1 … Table Table2 … CC SC IC … … CC1 SC1 IC1 … … CC1 SC2 IC1 … … CC2 SC1 IC1 … ̷…
Set a local variable and use throughout the query batch?
Once I insert default values in the table I store the result of scope identity in a variable After this, I have to run some other pieces of code that change the value of scope identity and after running those pieces of code I have to use the value of @id again but it shows an error saying that I