Issue with Float datatype while using EXCEPT

Question

Issue with Float datatype while using EXCEPT

gurvimail

SSChasing Mays

Points: 615
More actions
April 1, 2013 at 9:25 am

#270575

I have two tables with float data types and am using EXCEPT to check for the new rows in the source tables.
Their is data in the source table but it is returning nulls.I am unable to figure it out , why this is happening.
select colmn1,
colmn2,
-----
from table a
Except
select colmn1,
colmn2
from table b
now although talbe A has data but it is giving nulls
Any help will be appreciated
Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286573 More actions · Answer 1

gurvimail (4/1/2013)
I have two tables with float data types and am using EXCEPT to check for the new rows in the source tables.
Their is data in the source table but it is returning nulls.I am unable to figure it out , why this is happening.
select colmn1,
colmn2,
-----
from table a
Except
select colmn1,
colmn2
from table b
now although talbe A has data but it is giving nulls
Any help will be appreciated
Thanks

Can you post some details? We need to see ddl and sample data and your query at the very least. Please take a few minutes and read the article found at the first link in my signature. Once we have some details we can help. With no details the best we can do is guess.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

gurvimail SSChasing Mays Points: 615 More actions · Answer 2

Hi ,

thanks for the reply , actually it was nothing to do with the float data type.There were nulls in the source table so i was getting null.I just overlooked it .

thanks