Problem I’m making some small REST API, which I have never done before. I’ve got some basic stuff working. Now […]
Category: SQL
I want a nice design pattern for “All”, “many” or “one”
Problem In my particular usage here, I’m using two functions to deal with one thing. Lets say the user request […]
Finding the Nth occurrence of character in string
Problem I wrote an SQL Server function which returns the substring before the Nth occurrence of a character. For example: […]
Second-sealed-bid auction web app
Problem I am working on a second-sealed-bid auction web app. I have an Auction table to keep auction items on […]
Best way to get two columns from a table
Problem Basically I have taken over a project and found a table that has the following video and video title […]
SQL queries in a dataframe
Problem I want to get table names and column names from queries in a dataframe. The dataframe is like this: […]
Optimizing this seemingly slow Query
Problem SELECT BR.IDObject AS IDObject, B.imgName AS imgName, BK.imgPath AS imgPath, BR.imgType AS imgType FROM ImageReferences BR INNER JOIN BDB_WebImages […]
Complicated article sort
Problem In short I have a bunch of articles (~100k) which shall be ranked (“mixed”, hence “newsmix”) based on their […]
Are these tables concepted correctly?
Problem I want to store image (details) in my database, and want for each image the possibility to have from […]
SQL to find table containing all specified columns
Problem I have the below code to list all tables which have columns DataAreaId and CountryRegionId. This works, but requires […]