Why do we need to convert when its not required....

DECLARE @radius float

SET @radius = -0.256712789599778

SELECT lis_id, @radius AS distance FROM Listings

Hey, I've just tested this and surprisingly it works both in procedure as well as in trigger...:w00t::w00t:

The solution provided is for SQL Server 2000 or higher and wouldn't run in MS Access or any other RDBMS.

Is the column COPPersoonID a unique identifier?

A unique identifier is a 16 byte long value in the format xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx (can be generated by NEWID() function). The condition...

Try running the inner sub-query to verify the results....And also you are using a sub-query executed for each row, which can be avoided by using derived tables...

It would actually group the rows by columns b.pn_bnc, b.model_bnc and b.bnc90d. And also you have a sub-query executing for each row, will not scale well in production. ...

CREATE VIEW vw_SomeTable

AS

SELECT * FROM SomeTable WHERE SomeID IN( 1, 2, 3 ) AND SomeDate IN( '20060101', '20070101' )

EDIT:

Damn....I guess, I misunderstood the post....;)

Well, if you are taking about "real-time" data refresh then you can look more into replication, mirroring and snapshots, otherwise you can hit a search on this site to find...

Hey, you are still using sys.databases...

Assuming that you want alphabetical row numbering, here is what you can do...

UPDATE SomeTable SET Col2 = 66 - ASC( LOWER( Col1 ) )

Hey.... guess I hit someone's "sweet" spot.:D:D

Use sysdatabases table

I hope, next time you follow the route opposite to that you've been through:D:D

Go to Server > Management > SQL Server Logs [Right click and select Configure]

The queries which I and PW has posted will surely improve...