home
I'm trying to work on SQL Server with some parameters that can be NULL, where NULL means "ignore...
I have a form where I want either Asset or Location filled out and Supervisor or Lead or Crew or...
I have a large case expression e.g. CASE WHEN ... THEN ... ELSE CASE WHEN ... THEN ... ELSE ''...
I have set up my datatables using an external database that is being put into a list and then...
I have a table where i want different columns to be calculated and store the computed result in...
I have this query INSERT INTO dbo.finaltable (qty) SELECT REPLACE(REPLACE(ISNULL(table1.[qty],...
There are many posts on this topic but unfortunately the solution provided (using loc) is not...
Im trying to validate some data on a listbox. If user select a name on the combobox it needs to...
I am trying to calculate a formula but its not workig or i am doing it wrong (obiviously). The...
I originally had a placed in the where statement that seq1 (most recent physical address) would be...
I have a query (condensed version - edited to add the SUM items for clarity) - SELECT STORENBR AS...
I have developed a query using two pivot table, now I want to add a zero where the value is...
I am trying to handle some data in the following way. If the entry is numeric, cast it as an...
I've a table as shown in the SQL Fiddle. CREATE TABLE `test` ( `id` varchar(250) NOT NULL, ...
I have a table of users and I want users to update some of their details (data), but if a user...
I have a parent system table called lt_program_data it contains customer data, percents tracked for...
I have a scenario where for the second employee (in the screenshot attached) there is no record...
I have the following SQL: Select MyNumber FROM (SELECT to_number(Name) AS MyNumber FROM...
Column MaxPlaces sometimes has a value and sometimes is just NULL. I have to send this procedure to...
I am working on a Hive table on Hadoop and doing Data wrangling with PySpark. I read the...
This question already has an answer here: How can I include null...
I would like to find the rows which fulfill certain conditions with their values. The values and,...
I've a multidimensionnal array like that, and I wan't to check if all of the "open_at" and...
I have a stored procedure where it can return no row, in that case I would like to put 'Other' as a...
4 months ago

Not working !==NULL

In my app I have a table in where I'd like lo highlight some rows if a date field is empty, here's...
I have this stored procedure in MySQL, its suposed that should works but it doesn't. I put a table...
Sometimes SUM(c.Quantity) is null so I need to convert it to 0, tried to use case/isnull and so on,...
Suppose that I have: case when @ID ='2386002' then...
4 months ago

ISNULL prints *

I am encountering this strange behavior (Okay maybe not strange but beyond my understanding) when...
I have a database table "Category" which can have a self-reference. If self-reference is null, then...