Lavanyasri (2/21/2013)
Thanks to all.I go through the link , now my issue with the decimal data type
SELECT col1 FROM table2
WHERE col2 > 9999999999.99999
OR col1 < -9999999999.99999
In this script col1 is primary key and col2 is the column from eroor.
The same thing i checked for my issue,some tables doesn't have any column with primary key, and some tables have clumn primary key but its datatype is int not decimal .
suggest me how to get data_purity values using the above script ..
Col1 and col2 should be same data type (decimal)??
Lavanyasri
The above code looks like a typo error
what you need to check is
SELECT col1 FROM table2
WHERE col2 > 9999999999.99999
OR col2 < -9999999999.99999
Here Col1 is the primary key and col2 is the decimel you need to check.
Col1(PK) doesnt need to be of the same datatype. You need this column to uniquely idenntify the corrupt rows,
decide on what to do with them