G's explanation is right on. I have used Float in the past, but it does not give precision and you had specifically mentioned Decimal(3,2) in your original post which...

What error are you getting? It could be the blank values are causing the issue. Convert blanks to null before converting to currency.

Is Service Broker running in msdb? DBMail needs Service Broker running in msdb.

Select is_broker_enabled from sys.databases where name = 'msdb'

This should return 1.

If you are always getting 0 it is because both fields are int and division between int's will always return and int. Convert one to decimal(3, 2) like this;

Select...

The only reason this would take more than 1 pass is that there are more than 2 records for some of the UniqueName and ParentREF combinations.

You could reverse the logic...

Locking hints are typically not recommended unless you are a very advanced SQL guru. There are instances where they can help. I have tended to use nolock on...

Carolyn Richardson (5/7/2008)

---

If the server security is set to mixed mode then you can add a fixed id to run the report and use a specific user name and password...

Unfortunately I don't believe that there is a way to do this and still maintain good security. Your best bet may be trying to write a simple ASP.NET web...

I'll just add that moving to stored procedures and only allowing the web user to execute the stored procedures will also eliminate the possibility that your web user account has...

Using db_datareader is not a good practice. The user logging into the website should only have permissions on the objects it needs access to. By default any user...

I don't think this works in SQL Server 2000. In 2005 I believe it would be DENY CONNECT.

Have you checked to make sure the SQL Server is set to allow remote connections? SQL Server Surface Area Configuration -> Surface Area Configuration for Services and Connections under...

You need to go into SQL Server Surface Area Configuration and then into Surface Area Configuration for Features and check the enable Openrowset and Opendatasource support selection under Ad Hoc...

Well in your script being run in QA you are separating the procs with the GO batch separator so they are running in 2 batches. That is just one...

Don't see anything mentioned above. Please put your problem in the post so we can see it and so we can quote it if need be.

Thanks,