I have a table with a text field that imported with incorrect characters delimited by a space. Expected Output I need to run an update to remove all the text AFTER the space on a specific number of rows. I figured out a way to select the correct text, but I’m stuck on how to update in bulk. Will return
Tag: sql
Adding new records to Access table on an update to a linked table in Access VBA SQL
I have two table one (skillsMatrix) the other table is (elementTree) with columns [mediumElement], [ID] in table skillsMatrix the mediumElement is a lookup dropdown of the mediumElements in table two. I want to write a macro to update skills matrix table to add a new record “name”, “new topi…
OBIEE generated query using irrelevant fact tables in its select
In an analysis, we are counting number of all loaned items by their interest rate. It uses one fact table F1 and three dimension tables D1, D2 and D3. F1 is joined to all these three dimension tables. Therefore, as I see it there shouldn’t be any complicated query generated to get the result. However, w…
Google sheets query – I would like to return a column, but if cells in the column are empty return cells in another column instead
Kinda new at this, struggling with a solution. So currently my formula looks like this: Col2 is my criteria and remains constant. What I’m looking to do is have the formula return the cell in Col9 if the cell in Col8 is empty. If the cell in Col8 is not empty it will just return as is. Col8 is not
JSON Connection string configuration
In the app settings JSON file I am passing through a connection string which contains the name of my server ‘ .SQL2017 ‘ I recieve the following warning in error list when entering the server name …
How to split dates into groups of 24 hours -BigQuery
this is my goal, split the dates into groups of 24 hours, but those depends of the data, not of a very specific date Let’s say these are the calls from a call center, I want to know how many sessions I had, but those sessions are valid for 24 hours, those 24 hours are starting to count since the
My SQL is have to search for articles in my database within price range of 3,00 and 4,00 but the code does not work
Cam someone help me…. I have to bookmark my SQL Query, i have to create a code to boormark all products within the tabel “album”, and the price must be between 3,00 and 4,00 But it doesnt work. Can someone tell me whats wrong? Im new in SQL so sorry if its a dumb qeustion xD Screenshot of th…
Issue connecting to SQL Server via Python pyodbc
I have an ongoing issue that I just can’t solve. It concerns a Python script that loads data into a SQL server database. When I run it from my local machine it works fine, however when I run the same script from a server I get the following error: conn = pyodbc.connect(r’Driver={SQL Server};’…
get started minutes from 0:00:00 type values
I’m not really used to sql but I have a csv file with a lot of rows and columns so I decided to do the needed work in sql. I have a Table with 3 columns and a few thousand rows. Column duration is …
Laravel – DB::TABLE SQL – how to get join data in one queries
I Have 2 tables first client_group with data like below second table client in Controller I have code like below: $client = DB::table(‘client_group’) ->where(‘client_group.user_id’…