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

SELECT col1 FROM table2
WHERE col2 > 9999999999.99999 
OR col2 < -9999999999.99999