The field is a varchar(20)

Awesome!!!

Worked great, thanks for your help

Susan

Here is the query

SELECT PartnerLeadTypeID, PartnerID, LeadTypeID, isActive, AllowedStates, RestrictedStates, CreditHistory, LoanAmount, PropertyValue, LoanToValue, PropertyType,

RestrictedCityState, SoftCap, HardCap, HasLender, HasAgent, FoundHome, Bankruptcy, ProdPostURL,

(Select count(*) from PartnerLeadTypes e2 where e2.PartnerLeadTypeID <=...

Still get the 'invalid column name' message.

Should I be changing the order in which I'm doing things?

Then I get an 'invalid column name ' error message..

Any other ideas?

Thanks for your help!!

So going forward it's politically correct to use 'with (nolock)'?

What would be the sql command to zip a file via WinRar?

Nope, just created my own jobs....

CREATE TABLE [dbo].[tbl_RCResultMatch] (

 [RCID] [bigint] NULL ,

 [ResultID] [bigint] NULL ,

 [DecisionChar] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [AlternatePhone] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Date_in] [datetime] NULL ,

 [Acceptance_Failure_Description] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

It's happening at the end of the query..

DECLARE @DateFr datetime

DECLARE @DateTo datetime

--SET @DateFr = '5/11/2006 12:00:00AM'

--SET @DateTo = '5/11/2006 11:59:59PM'

SET @DateFr = '10/12/2006 12:00:00AM'

SET @DateTo = '10/12/2006 11:59:59PM'

SELECT '<XMLData>

<Decisions>

    <Decision...

figured it out..

There maybe a better way, but this is what I ended up with

insert into trackingpixels

select adid,'<img src="','N','L','Reply'">https://reporting.cpcmanager.com/ct/146/x.gif?cid=auto%5BIDENTIFIER%5D">','N','L','Reply'

 from trackingpixels

where adid in

(select  adid  from trackingpixels

group...

That should be two tables, not three..

The other one isn't involved in the query

Thanks for your help.

There was a view that was created with schemabinding.

Dropped that renamed the table and recreated the view.

Thanks again!!

Susan

Yes, I tried that.

It actually turned out to be that the string was too long, so I broke the insert into two, but can't get it to loop through...