I tried converting the varchar to an int or the int to a varchar, but I still get the same message. Should I convert in the select or where clause?

Your right.. I'm learning..

Any tips?? Or to many to mention?

I modified the code, but still get the same error.

I tried that and receive these errors

Msg 137, Level 15, State 2, Line 3

Must declare the scalar variable "@dbname".

Msg 156, Level 15, State 1, Line 3

We are running 2003/2005, the updates take place in different databases.

I didn't see any blocking via sp_who, but will take a look at the locks.

Thanks for your help

Susan

*/

CREATE PROCEDURE [dbo].[usp_AVMCalculationPropertyDetails]

 @PropertyID bigint,

 @AVM as float output,

 @Confidence as float output

As

 Declare @defAppraisalWeight float

 Declare @defRSIWeight float

 Declare @defHedonicWeight float

 Declare @defAssessedWeight float

 Declare @defFiservWeight float

 Declare @defSQFTWeight float

 Declare @defLotSizeWeight float

 Declare @defPctConfWeight float

 Declare @defAvgElementWeight float

 Declare...

Although I'm from the UK, I'm talking about counties per state as in USA

THanks Mike,

It worked find via the QA.

Susan

Thanks for all your help.

SUsan

Here's what I changed

update nimages  set nimages.evox_id in (select evox_id from vehicle_tmp v where v.vehicle_nmb = nimages.vehicle_nmb

Now I get this error message

Server: Msg 156, Level 15, State 1, Line 1

Incorrect...

Sorry about that !!

When I just run the subquery, I get this both times

Server: Msg 107, Level 16, State 3, Line 1

The column prefix 'nimages' does not match with...

Sorry about that !!

When I just run the subquery, I get this both times

Server: Msg 107, Level 16, State 3, Line 1

The column prefix 'nimages' does not match with...

You can put the database in 'bulk-logged' mode and they won't grow as big.

You can change it back when finished.

Paul,

I have a table with only one column each for longitude and latitude. They will be passing the sa_property_id which has a long and lat listed. I need to...

Figured it out - needed a ]

  ,[AVM_Value] + ([AVM_Value] * .1) as [Reply10Pct]

From AllPropertyDetails

Thanks though

THanks for the help...

Susan