703 questions
0
votes
0
answers
70
views
Make a WHERE clause Non-Sargable and remove ISNULL [duplicate]
Is there a better way to represent this WHERE clause so is does not use the Non-SARGable funtion ISNULL?
1=1
AND ISNULL([TABLE_NAME_1].[FIELD_NAME_1], -1) <> ISNULL([TABLE_NAME_2].[...
- 401
0
votes
1
answer
71
views
Query, giving back string, even if SELECT statement is empty, is faulty
simple question, but no idea, how to fix it.
Following Query should give back "No values", if SELECT Part will return nothing. I will get error message:
[21000][1241] (conn=80188403) Operand ...
- 43
1
vote
1
answer
580
views
Is there a function to return the first null value of a row?
I have the following table:
create table table1
(
id serial,
workdate date,
tanknum1 integer,
tanknum2 integer,
tanknum3 integer,
tank1startingvalue float,
...
0
votes
2
answers
2k
views
Convert date, turn NULLS blank and keep blanks?
I have a column in a query that contains some blanks, NULLS and dates (as YYYYMMDD). I need to convert the dates to MM/DD/YYYY, remove the NULLs and keep the blanks blank.
When I try...
isnull(convert(...
-2
votes
2
answers
700
views
How to use ISNULL result in a calculation involving a subquery [closed]
I have a SQL script that uses a subquery, the result of the subquery can sometimes be NULL so I've used ISNULL to set the result to zero (0) in those cases.
The problem I have to solve is that I need ...
- 95
0
votes
1
answer
607
views
PostgreSQL ISNULL transform null to minimum value of datatype
I have a PostgreSQL database and I have a complex query which is generated dynamically from C#. I need to use the ISNULL built-in function which in PostgreSQL is called COALESCE by replacing with ...
- 1,517
-1
votes
1
answer
96
views
How to handle null values in date field in sql pgadmin
I need to find difference between two dates to calculate "total storage days" in pgadmin
date1-date2=total storage days
The date values is having null values, if i use isnull(date1,0)
ERROR:...
- 9
0
votes
2
answers
471
views
Mysql query with optional where condition
I have a form which is used to search the database. The form consists of four fields, including two date fields: (Col1, Col2, Datefm, DateTo). Users have the option to fill the values in these fields. ...
- 65
0
votes
1
answer
95
views
comparison with NULL date gives NULL value in SQL Server
This code results in NULL. sale_jan_dt and sale_feb_dt both datetime columns.
s.sale_feb_dt = 2022-09-01 01:19:00.000
s.sale_jan_dt = NULL
select
case
when s.sale_jan_dt >= s....
-2
votes
2
answers
87
views
Is there a way to return a value instead of blank for SQL? [closed]
I am trying to do a HTML table but i am having troubles where it does not return a value.
This example shows my result.Sample Image
Is it possible to script that if there isnt any result, it will ...
- 11
-1
votes
1
answer
72
views
mysql group_concat problem: ISNULL replaces null values but in the incorrect order
When using GROUP_CONCAT, the ORDER BY clause appears to works correctly. However, when replacing NULL values using ISNULL or COALESCE, although the actual values are in order, the NULL values all end ...
- 1,007
1
vote
2
answers
451
views
Excel - total count of records where all 3 columns of data are blank
I'm trying to create a formula that provides the total count of records in column A that either have a null or 0 across all 3 columns.
Ex
Name Score1 Score2 Score3
Test A
Test B 90
Test C
...
- 109
1
vote
1
answer
444
views
How to make pandas interpret NA as null but only for some of the selected columns?
I have a dataset with more than 40 columns and for some of the columns 'NA' is a valid entry which means 'Not Applicable'. But for rest of the columns 'NA' can be considered as NULL. Currently pandas ...
- 13
0
votes
2
answers
1k
views
Different results from any(df.isnull()) and pd.isnull(data).any()
I am using the standard Boston houses data frame with pandas and I have noticed something that bugs me:
when I'm checking for missing values in 2 different ways - I'm getting 2 different results, ...
- 81
1
vote
1
answer
81
views
Update procedure with case - SQL SERVER
i would like to request help with an update procedure. I want to update either the CPF field only or the Surname field only, currently, i can only update both together. Is there any way to do this ...
- 13