Grant Fritchey (1/9/2009)

GilaMonster (1/9/2009)

It's been...

In your example, what do you want the final result to be in t1? Do you want 1 row for each project id? Then you need to decide...

Can you work with the vendor to change the password on the application's login and then not allow anyone else to know the password? Then you could make the...

Well, it is 2 stored procedures accessing the resources. You need to check that they are doing their access in the same order. Can you post the sp...

Yes, service packs often make changes to the tools as well.

The general recommendation for BLOB's in SQL Server is to only store them on the server is they are relatively small and you are dealing with larger files. For...

Are they domain admins or admins locally on the server? Are they connecting using Windows or SQL Authentication? Is Builtin\Administrators still allowed access to the SQL Server?

Are the tools up to the same service pack level as the server? Are you sure you have appropriate rights?

Oh yeah, forgot about ROUND()

I think using cast or convert is your only option if you are just using SSMS. It is using whatever the data type is for your column, so you...

I think you can also do a dataset.tables().Rows or .RowCount = 0

I'll second Jonathan's request as that will help us see what each session is attempting to do. You may want to check out this blog post as well: ...

What are you using to display the results? What are the datatypes of the columns in the calculations? Can you post the query?

When you set up the counter log what was the Refresh Interval?

Is the data in SQL Server? If it is I don't think you need to use SSIS to do this. Try this:

Set DateFormat DMY

Declare @meterreadings table(Date datetime, meter1reading...