wow, that's really cool. i had no idea you could do that. Didn't seem logical to even be able to.

Since u can do that i suppose u can do the...

heh, If it is scheduled for deprecation - I can't find it.

Maybe I'm being thick, but I am trying to see the connection between truncated data and the quote being...

also u have to ensure that the aliases of everything your selecting must match between the top select and bottom select. these aliases is what you will put in your...

--notice how i have the local var @db and how it is added to the dynamic sql

set nocount on

DECLARE @sqlScript varchar( max )

Declare @db varchar(500)

declare @user varchar(100)

select name, 0...

you can loop through the dbs using the below then put the drop create of the sp in there.

set nocount on

DECLARE @sqlScript varchar( max )

Declare @db varchar(500)

declare @user...

That's good to know.

u should also have the check to see if u dont need to update

update a

set comments1a = b.Subdivision

From Notes a

inner join CowettaCoSubs b

on a.account_id = b.account_id

where a.comments1 is null

and isnull(...

also not sure if it matters but u dont need the alias in front of the feild ur updating as long as u specify which table ur updating after the...

there must not be any null values for a.comments1

prob shouldn’t do this since it isn’t my code or problem and I run risk of steering the problem and solution in the wrong direction but now i too am...

If you use sp_executesql, the dynamic string can be set up so that all variables are parameters, and the parameters also passed in thru sp_executesql. As you add/drop lines in...

I think i may have made some quick judgements about you Lynn and for that i'm sorry. Apparently those u call friends on this site do not feel you are...

============================================================================

gsquared:

One of the most fundamental rights any human being has (or has been denied) is the right to choose with whom to associate. If Lynn, or anyone else, chooses not...

mem settings

•If server memory is <= 3 GB, set min memory to 1 GB, and max memory to server less 512 MB.

•If server memory is > 3 GB, settings depend...

u need to upload the stored proc at least so we can see if there is something obvious.