SELECT loadNumber, CASE WHEN E.Clave = ‘LOD’ THEN FechaEvento ELSE NULL END AS ‘Load Date USA’, CASE WHEN E.Clave = ‘DAA’ THEN FechaEvento ELSE NULL END AS ‘Colocacion AA’, CASE WHEN E.CLAVE = ‘RPD’ THEN FechaEvento ELSE NULL END AS ‘Docs Listos’, CASE WHEN E.Clave = ‘IDT’ THEN FechaEvento ELSE NULL END AS ‘Llegada MX’,… Read More Group Select in an Only row
Say I have a table that looks like the following: Account Sale Date A $5 2023-Jan-01 A $8 2023-Feb-15 B $2 2023-Mar-03 A $7 2023-Apr-10 A $9 2024-Jan-01 If a user selects a date range of 2023-Apr-01 to 2023-Apr-30 I would want the table to filter down to the below: Account Sale Date A $5… Read More If a multi row account has a row in a specified date range, how to select all previous rows for that account before that date?
New to SQL and need some assistance. I have two tables: 1) current iOS versions and 2) target iOS version and wanted to get a target iOS version for each version, how should I go about doing this? iOS Version 11.0.0 12.0.1 13.5.0 16.4.1 17.1.0 Target iOS Version 12.5.7 15.8.0 17.2.0 Goal: iOS Version Target… Read More SQL – iOS Version Target query
I want to create a view with result like this in SQL Server, from data table with date range per row (start date – end date), can generate repeating data based on a date range to get the number of months for repeating data (by displaying the date of the beginning of each month). data… Read More Generate repeating data based on date range
I have a table with a column of type Image and I’m trying to insert the value in bytes using a SQL query like this: INSERT Into DocumentImage (FileName, DocImage, DateTimeAdded) VALUES (‘TestTemp.xlsx’, ‘0x504B030414000600080000002100ECC0AA13A901000035070000130008025B436F6E74656E745F54797065735D2E786D6C20A2040228A0000200000000’, GETDATE()) But after inserting the Image value changes to some other bytes like this ‘0x30783530344230333034313430303036303’ Any idea why this is happening… Read More Why Image inserts different value in bytes
Simple reprex below: drop table if exists my_table; create table my_table ( ref int, customer_name char(50) ); insert into my_table(ref, customer_name) values (1001, ‘Alan’), (1002, ‘Bob’), (1003, ‘Christine’), (1004, ‘David’), (1005, ‘Elizabeth’); drop table if exists lookups; create table lookups ( ref int, gender char(6) ); insert into lookups(ref, gender) values (1001, ‘male’), (1002, ‘male’),… Read More Updating Table After Left Join
I have a table with some IDs and a flag of whether or not the person should be deleted. There are 2 sets of IDs in the table, 1 primary ID, and then a secondary ID as well. A single primary ID can be in the table multiple times if it has multiple secondary IDs.… Read More Get Distinct Values With Consistent Value
I need to update the buyersAccountID in tblITEMS with the accountID of a winner who’s boxNo in tblEntrants matches ‘winner’ in tblItems: TBLENTRANTS fileID boxNo accountID TBLITEMS fileID buyersAccountID winner So to clarify: If ‘winner’ which is an integer in tblItems matches the integer boxNo in tblEntrants then I need to store tblEntrants.accountID in tblItems.buyersAccountID… Read More Multiple Selects to update tblItems – INNER JOIN required?
I have the following data: Date Index MonthlyReturn Group 2023-01-01 10 0 Group 1 2023-02-01 NULL 3 Group 1 2023-03-01 NULL 6 Group 1 2023-01-01 10 0 Group 2 2023-02-01 NULL 4 Group 2 2023-03-01 NULL 2 Group 2 From this data, I want to calculate the Monthly index for each group (Index of current… Read More Multiply value from next row to get monthly Index in SQL Server
I’m getting this error message IntegrityError: (2627, b"Violation of UNIQUE KEY constraint ‘XXXXX_TypeOfData_input_un’. Cannot insert duplicate key in object ‘XXXXX.TypeOfData_input’. The duplicate key value is (Processing Data, Processing Data Name).DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\n") How to add unique constraint when insert? My code INSERT INTO… Read More MSSQL – Violation of UNIQUE KEY constraint