|
Data difference problem
6/10/2006 9:31:17 AM
(Total replies: 1)
|
| Hi all,
I dont know if this is the right forum to be posting this in, but I have a problem where I am working out a lot of sums and averages in a stored proc. The SQL code used to be in an ASP page, but there was one set of data which exceeded the allowed number of calls to tables.
To make a long story short (or longer), the client that I am doing this for has a set of data in a CSV file that was created a while ago. For most of the fields being pulled out of the database and averaged and ... |
|
|
|
Re: Data difference problem
6/10/2006 1:46:51 PM
(Total replies: 0)
|
| Thats the way the original SQL came to me.
I just went down and got the "gurus guide to transact SQL" and ran through one of the examples in the numerics chapter.
I have tried decimals, but I was getting an error for some reason.
I will have to try it again now that I have the book.
I will let you know how I get on.
********** edited region **************
I just got off the phone from my boss who reckons that the clients always got the same results each time they ran the ASP ... |
|