ok i have that same zipcode database , and this SQL seems to work:

select  SQRT(POWER((38.492497 - latitude),-2)  + POWER((-121.404807 - Longitude),2) )  as distance ,zipcodes.* from zipcodes

where SQRT(POWER((38.492497 - latitude),-2) ...

there's nothing wrong with using the IN operator and having only one item in the selection list:

so if [#ABN_RUInput] only has one row witht he value 220056 , it...

additional instances must be identified by IP AND port numbernote the comma after the ip address)

 you should also be able to connect to...

sounds to me like the decision to pull everything out into 4 tables was a mistake, since you need to query all 4 tables anyway. Is there a difference really...

I'm under the impression that a lot of the backup time is SQL server finding/creating/reserving contiguous harddrive space;

once it has the contigous space it goes pretty fast putting the...

instances can only be dropped; they cannot be renamed.

uninstalling all versions of sql server, and then installing sql2005 will allow you to install sql20005 as the defaul instance.

By conditional counts i thought this is what you meant:

select

Count(ID) as TotalRecords

case when isnull(Processed,0) = 0 then 1 else 0 end as RecordsNotProcessed,

case when isnull(Processed,0) = 1 then 1 else 0...

that was my point...the example i provided takes the '2A' into consideration by grabbing the substring of the first character, then you get your claim [version?] of '1' or '2'...

since [claim] is actually a varchar, you should make your comparisons the same data type:

when [claim] = 1 should be when [claim]='1'

or when it has versions appended to it:

when substring(claim,1,1)...

because of email size constraints, i would suggest having the job FTp the file to another location instead.

many email servers have a 4 meg or 10 meg limit on...

could it be something as simple as the path missing a slash?

'E:ListServer.bak' might really need to be 'E:\ListServer.bak'

oops;

missing a closing parenthesis on the line above the error line:

   SET @Pdy=(select  'pkzip -a "'+ @dbname +'-' + @DY + '.zip"' +' "' +@dbname +'-' + @DY +...

I agree; post counts show a degree of dedication towards helping people, but i've seen a lot of good helpful posts from people with just a handful of posts; some...

Remember Query analyzer is just a developer utility which can display most data.

it interprets (char10) OR char(13) as a new line;

for example:

select 'text'+ char(10) + char(13) + 'vbCrLf' + char(10)...

that is not the correct syntax; the dynamic SQL Jon posted is the correct solution.

your SQL would return 'xy' for every row in the table table_ab, where Jon's statement would...