Can u explain in detail.

michael vessey (10/24/2008)

---

I'm with primary keys....

developers often assume that what they've written against their dev database which has 50 rows of data will work just as fast with 5000 rows...

Hi

Cant write the query now.. bit busy. You can do this using CASE statements. Check this site for more details and examples.

Welcome...:)

This subquery " (SELECT Cycle_Time_perStation

...

STUFF(CustPhone,1,3,'664') WHERE left(Custphone,3) = 614

Hi

So u need to check for another record in the same table i.e. sites table rt?

If thats the case you can use IF EXISTS or IF NOT EXISTS Clause inside...

Heck... selected the wrong checkbox.;)

Where clause should come before the Order by.

Once thats done check whthr the query is executing as u want. If not give us some more details.

If i have understood correctly.........

CASE WHEN tbMeasurement.MonitoredLocationCode = 'FUGITIVE_TOTAL' THEN ISNULL(tbMeasurement.NumericResult,0) END AS 'FUGITIVE_TOTAL'

,CASE WHEN tbMeasurement.MonitoredLocationCode = 'ACCIDENTAL_TOTAL' THEN ISNULL(tbMeasurement.NumericResult,0) END AS 'ACCIDENTAL TOTAL'

Would Create Index WITH Drop_Existing work for moving non-clustered indexes.

glad it worked.

Sorry for the delay.

Since you are going to use both the range columns and also the value column, CASE is the best way to go about it.

So thats going to...

Thanks Jason , Paul. That some body got rid of it is the only conclusion that i cud come to. I do have backups so recovering the db is not...

Generally speaking performance takes a hit becoz data has to compressed and decompressed for data modifications and retrival. You could do this for data that is used rarely like some...