I’m querying my DB twice to get some items into the header of the page and some bellow the header. I want to avoid duplicates in these two queries, currently I do this by adding a skip method to …
Tag: sql
SQL Server – Delete rows from one side of a JOIN
I have a query that identifies orphaned rows in one table after joining it to another. The query I have for selecting the rows that need to be deleted works fine, and properly selects the rows that …
What would be C# equivalent for SQL “>” operator in where clause for char column
working on an c# application i came across something that I don’t quite understand. I have SQL column KONTO char(15) and it contains numeric data. When I run the following query… I get this result… and thats just fine. My C# code providing the same result is: I came across problem when I tri…
Pairing table query
I was wondering how I construct a query to get all articles with all their information, and for every article a list with their tags. I used a pairing table called ArticleTags to connect Article and Tags. Can anyone tell me what the query would be if I wanted to receive all articles along with their tags per …
Trying to get Price Difference and Percent Difference
I am trying to find the daily price difference and the daily percent difference, in one field, in one table. Here is the code that I am testing. Here is a sample of my data (first three fields), with the expected results (last two fields named ‘PriceDiff’ & ‘PercentDiff’). I am usi…
Error in SSIS Package – There is a data source column with no name
I have a straightforward SQL statement that I posted into a DataFlow Task and got this dreaded error. There is no stored procedure or temp tables involved. What am I missing? The SQL works fine in SSMS and returns appropriate results. The query is pretty simple and I have never seen this error in SSIS before.…
What is Internal process of below mentioned queries?
As per performance which query is optimistic query? Answer id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra -: | :———- | :—- | :——— | :—– | :———— | :—— | :̵…
MySQL self join to find only the next revision
Actually I’m working with WordPress. I want to create a self-join or something similar to find a revision of a post, and the following revision of the same post. https://www.db-fiddle.com/f/eHnwYABYrVVQAhn8xLJ77q/1 The previous query doesn’t work since it takes, for every record of a, all the revi…
Syntax to resolve ORACLE error is ORA-01476: divisor is equal to zero
I’m using the NVL function to try and correct ERROR: Error fetching from cursor. ORACLE error is ORA-01476: divisor is equal to zero. I’m having trouble figuring out what the correct syntax is. Answer The normal method is nullif() in the dividend. So, instead of: You would use: Assuming that t.Amo…
how to export data from SQL in R
I’m a beginner in R. I have connection via ODBC to SQL DB: dbconnection