Monday, March 12, 2012

Integers, Money values becoming zeros

Hi,

When I reset the SQL query in Database ->Show Sql Query, all integer and money type values are becoming zeros. When I execute the same query in the SQL Query Analyzer I am getting the values with same no. of records in the report. Can anybody suggest me the solution.

The only difference before resetting, the query doesn't have "WHERE" clause.

Thanks in advance.Post the query you used and the table structure

No comments:

Post a Comment