Search results for query: *

Hi We have a financial system based on a SQL Server 2005 database and there is a requirement in this system to round numbers down after 2 decimal places. So for example: 2500.627 - would need to be rounded down to 2500.62 However, At the moment, SQL Server rounds this to 2500.63 which is...

Hello I have a problem with reporting services, more specifically the scheduling function within Reporting Services. We have been using this function without a problem for about 2 months now to run reports at specified times and then email the report to the recipients with the report included...

Hello I am using the xp_fileexist command inside a stored proc to check to see if files that are created each night exist in a directory (hence check to see if they where created properly). Is there any way of outputting the result of the xp_fileexist command to a text file or even to a table...

Hi I really need some suggestions on this one. We are in the process of updating our Enterprise system from version 8 to version 9. We are currently in the testing phase. We had a number of reports in version 8 that are based on a Crystal Query that we had no problem running. However, I have...

Hi I was hoping someone would be able to give me some advice on the following problem I am getting when trying to run a report via crystal enterprise. It is not a very big report but it does take over 5 minutes to run. When I run it, after about 5 minutes I get the following error reported and...

I am not very familiar with SQL Server SQL but what I am trying to do is the equivalent of the Spool command in Oracle SQL. I wish to write the results of a SQL query in SQL Server 7 to a text file. Can anyone help me this? Thanks