No announcements
Found 1244999 threads
-
1 Votes
Inserting null values and NO values null
Excel source can return null values when text and numbers are mixed in one column.Answered | 1 Replies | 5264 Views | Created by SBolton - Friday, April 16, 2010 8:00 PM | Last reply by Miloslav Peterka - Friday, April 16, 2010 8:49 PM -
1 Votes
Null values
The default of CASE if no ELSE is specified is ELSE NULL.Answered | 3 Replies | 3960 Views | Created by Khan_K - Tuesday, December 8, 2009 6:52 PM | Last reply by Khan_K - Tuesday, December 8, 2009 7:50 PM -
0 Votes
.null. value
You might just want to inner join to not get the result rows with NULL values.Answered | 2 Replies | 2200 Views | Created by Alaa Mukhtar - Friday, April 13, 2012 6:19 PM | Last reply by Olaf Doschke - Friday, April 13, 2012 7:57 PM -
0 Votes
join with null values not returning values
Hello, If you concate a NULL value with an other value it results in a NULL value again.Answered | 2 Replies | 3117 Views | Created by SQLProgramming - Wednesday, July 11, 2012 3:23 AM | Last reply by Olaf Helper - Wednesday, July 11, 2012 3:36 AM -
0 Votes
null !
Hi as null is not a value it cannot be compared using EQUALS operator.Answered | 1 Replies | 4309 Views | Created by Pasupathi - Thursday, February 21, 2013 10:28 AM | Last reply by Lawrence A. Freeman - Thursday, February 21, 2013 11:23 AM -
5 Votes
Replacing null values
But one thing is the second level values should return NULL between rownumber 10 and 13.Answered | 9 Replies | 4967 Views | Created by Arne Olsson - Tuesday, November 23, 2010 12:15 PM | Last reply by Arne Olsson - Wednesday, November 24, 2010 4:16 PM -
0 Votes
Not able to make column to null value from not null
1)Regardless of the way on how the error is encountered, if a column does not accept NULL values, always assign a value to it when inserting new records to the ...Answered | 3 Replies | 1029 Views | Created by Manthan(Monty) - Wednesday, May 13, 2015 8:09 PM | Last reply by AV111 - Thursday, May 14, 2015 12:43 AM -
0 Votes
Default value if there is null value provided
Hi Yuji, The expressions in Logic Apps should only have the first @ at the beggining, so your expression should ...Answered | 3 Replies | 4751 Views | Created by YNagata - Thursday, March 16, 2017 4:20 AM | Last reply by WSilveiraNZ [MVP] - Monday, April 10, 2017 10:47 AM -
3 Votes
WORKING WITH NULL VALUES
When working with data, which data type would expect to contain NULL values?Answered | 5 Replies | 3502 Views | Created by narang aman - Tuesday, May 25, 2010 5:41 PM | Last reply by KiranKumar.Y - Wednesday, May 26, 2010 12:27 PM -
0 Votes
Getting null values for the attribute
if that is so Some times in any of the month the measure value might be null...Answered | 4 Replies | 5664 Views | Created by Eswararao C - Friday, December 11, 2009 7:02 AM | Last reply by Prasanna K J - Friday, December 11, 2009 10:55 AM -
0 Votes
running value null check
0,"There is Null in here","No Null Present") Good luck.Answered | 4 Replies | 3986 Views | Created by dedbeat - Wednesday, March 4, 2009 8:52 PM | Last reply by Isham H - Wednesday, March 4, 2009 9:40 PM -
2 Votes
NULL values issue
hi If your dealing with NULL value use SET ANSI_NULLS OFF,because sql server treat NULL as unknown value.Answered | 7 Replies | 3061 Views | Created by BI_Support - Monday, July 15, 2013 9:58 AM | Last reply by Satheesh Variath - Wednesday, July 17, 2013 12:07 PM -
0 Votes
NULL values Indexed?
Yes - Null values are included in indexes by default but with new features in SQL 2008 (Sparse columns and filter index) you can change the way it ...Answered | 5 Replies | 5837 Views | Created by myNameIsRon - Friday, April 8, 2011 8:15 PM | Last reply by myNameIsRon - Thursday, April 14, 2011 5:00 AM -
0 Votes
Null fallback to default value.
No; NULL is not a value, but the absence of a value, so cannot be used in any comparative operation as the result will always be NULL, ...Answered | 10 Replies | 975 Views | Created by UpTide - Wednesday, June 19, 2013 8:01 PM | Last reply by Ken Sheridan - Thursday, June 20, 2013 4:55 PM -
1 Votes
can null value be typed other than NULL.
By typed NULL it means a NULL value with a datatype.Answered | 10 Replies | 1003 Views | Created by rajemessage - Thursday, October 13, 2016 1:48 PM | Last reply by Tom Cooper - Thursday, October 13, 2016 6:40 PM -
0 Votes
Unique Indexes and NULL values...
That will enforce the constraint to allow multiple NULLs and only unique non-NULL values.Answered | 3 Replies | 4159 Views | Created by JaedenRuiner - Monday, December 7, 2009 3:31 PM | Last reply by Plamen Ratchev - Monday, December 7, 2009 3:37 PM -
1 Votes
Update Null Values
If you want to know details about these columns' Null VALUES (PERCENTAGE for example), you can check out this ...Answered | 8 Replies | 1276 Views | Created by BKreft - Monday, November 10, 2014 7:14 PM | Last reply by BKreft - Monday, November 10, 2014 8:25 PM -
1 Votes
Null values are being inserted in columns not allowing Null values
SQL Server will not allow NULL values to be inserted into columns that do not allow NULL.Answered | 3 Replies | 5719 Views | Created by Mahesh C Sharma - Saturday, January 14, 2012 5:27 AM | Last reply by Dan Guzman - Saturday, January 14, 2012 2:31 PM -
0 Votes
Dimension contains Null values
Don't mix up NULL values in attribute key column and in fact table.Answered | 4 Replies | 3635 Views | Created by SSAS BT - Thursday, October 20, 2011 8:02 PM | Last reply by dstewartbi - Friday, October 21, 2011 1:29 PM -
14 Votes
Value is not null in SSRS
I need to use it in a switch statement where if one value is null and another is not null, then " " when both values are ...Answered | 9 Replies | 215346 Views | Created by BSPReddy - Wednesday, October 1, 2008 5:39 PM | Last reply by JP104 - Wednesday, April 4, 2012 4:17 AM - Items 1 to 20 of 1244999 Next ›
No announcements