I have a case statement to rectify one business logic in snowflake: INSERT INTO DB.table_b SELECT CASE WHEN UPPER(emp) <> LOWER(emp) THEN NULL WHEN emp IS NULL THEN nullif(emp, 'NULL') ELSE emp END AS emp_no FROM DB.table_a; The 'table_a' content…
I have an SQL table called FileGroups. I will query for certain columns such as Id, Name and Version. In my Azure Data Factory pipeline, I want to map the column names and row values from the SQL query results…
Why do both SSMS and ASP.NET MVC dropdowns show the data I filled in a different order sorted alphabetically? I've added the "Other" option as the last and when I ask SSMS to show the table content I get it…
I have a table in my database that tracks visitors page views and I am trying to pull out the utm tracking parameters from the url https://www.example.com/?utm_source=Adwords&utm_medium=ppc&utm_campaign=PGLawBrand&utm_ID=18075&mh_matchtype=e&mh_keyword=university%20of%20law utm_medium = ppc utm_source = Adwords utm_campaign = PGLawBrand utm_id = 18075 You…
I got a table like this in Azure analytics with Kusto for the game I'm working on datatable (ID_player:string, Timestamp:timespan, monster1:int, monster2:int, monster3:int) [ "aaa", "12:00:00", 1,2,3 ,"aaa", "12:10:00", 4,7,0 ,"bbb", "12:30:00", 0,2,1 ] Basically, I need to switch to…
I am wondering if there is a function in SQL Server or service in Azure to provide an opportunity to combine multiple queries into one. For example, ALTER TABLE1 ADD RetailValue AS (CAST(QtyAvailable AS int) * CAST(UnitPrice AS int) *…
We have recently migrated a PHP web application to a different hosting. Along with that, the database was also successfully copied over to the new mysql server. The earlier version of database server was mysql5.6 and the new hosting has…
I want to display regular_price product after sale_price product. For example product #5 is not sale_price, i want it to be after product #6. Product with sale_price will come before regular_price products.
I have 2 tables: genres_table: bands_table: genre_id | genre_name band_id | genre_id | band_name 1 | Rock 1 | 8 | Blink 182 3 | Jazz 3 | 1 | Foo Fighters 8 | Punk 4 | 1 | RHCP…
I am working on a small project, currently setting up a MySQL database. Unfortunately, this one piece of code is driving me crazy: CREATE TRIGGER main_db.tg_make_competitor AFTER UPDATE ON main_db.persons FOR EACH ROW IF (NEW.permissions LIKE '%Competitor%') && (SELECT COUNT(*)…