Does the query have the right data from each table for those rows? Once I know that, I can make it do the running total that you need.

Try this:

UPDATE Locations

SET Latitude = g.Latitude,

Longitude...

This, "Select @loc = zip FROM Locations", will always select the last value in the table, based on the clustered index. Then each of your following updates uses that...

The other thing to test is whether or not other queries that access those indexes, without going through that view, work.

You might need to recompile the view.

Did I just answer this in a different forum, or did my answer not post correctly?

Change, "ON S.SchoolID = M.SchoolID" to "ON S.SchoolID = M2.SchoolID".

I just tried this:

create table #T (

Val money)

insert into #t

select number

from dbo.numbers

alter table #t

alter column val varchar(100)

update #t

set val = '$' + val

alter table #t

alter column val money

And it worked.

That...

Here are some articles with data on how to create such triggers, and other options you have on the subject:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

Double-check that there is no clustered index on the table.

If need be, manually drop the non-clustered index, then create the clustered index that's supposed to replace it.

Also double-check that you're...

First, on the storage arrays, I get 7.2 Gig from those numbers, so I'm assuming there's some room lost to RAID set up or some such. Is this an...

RedGate has one too, called SQL Compare. You can find that from the link on SSC's upper right corner.

Either one will do what you need.

I'm assuming you're using SQL 2005, because that's the forum this is posted in. Is that correct?

Also, I need to know if the meter dates can be more specific...

That's probably timing out then. Can you break up the transaction into smaller pieces? Do it a few rows at a time?

I had to adjust some of the sample data you posted, since it doesn't appear to be a matched set of rows. Try this query:

select top 10 *

from dbo.Audits

inner...