Yes, I read the posting and was able to get the results I needed in the select,

but I can't actually modify the column during export using that select statement...

In first post you mentioned only one column.

Which one?

Turns out we need to modify all 4 date columns (not part of initial request).

I know I can get it out...

Two of them are varchar (not sure why), the other two are datetime.

Thanks that worked!!

So it's more of a setup configuration needed for active/active than it is for security?

Figured it out..

Thanks

Susan

Thanks for the clarification -

Here's what I will be using - Do I have to do the top 100 percent? or would you recommend looping/cursoring it?

update Propertydetails

set ReplyAVM =...

Ok, I see your point, I can see the ranges, but am still having a hard time getting it all in the update statement

and making it a percentage. This is...

Thanks for all your advice, although it maybe a little more complicated than I need for this project.

I have a 'valeudetails' table, with a field called 'avmvalue' that...

Thanks Noel!

Time to update my BOL.....

Scheduling restart of server.

Thanks for all your help

Susan

Here's what I have in my BOL

I ran the script, it now shows my config_value = 213, but my run_value is still 255

sp_configure 'show advanced options', 1

GO

RECONFIGURE with override

GO

sp_configure 'max worker threads', 512

GO

RECONFIGURE with override

GO

EXEC sp_configure

create table MPATemp(

City varchar(50),

state varchar(50),

zip varchar(10)

)

insert...

Perfect.

Thanks

Susan

Sorry, I didn't inlcude the output I needed...

I need a max date per type per distinct email..

Email  MaxLastDateClick         MaxLastDateOpen  

e@y.com  2007-01-22             2007-03-12

a@p.com  2007-01-22             2007-03-12

fk@ce.net 2007-01-22             2007-03-12

a@ya.com 2007-01-22             2007-03-12

m@ya.com 2007-01-22            2007-03-12

leo@se.com 2007-01-22