there's a difference between the Parse Query Function and the Execute Query;

Parse Query (the check mark button) validates the query for syntax violations...it does not actually check if the objects...

because your WHERE statements affect different records, you can't merge them together into the SAME SQL

there is no guarantee that the data found would be the same rows, and would...

I'm sure Aaron is right...it calls the extended stored procedure, which in turn queries the registry for the specific values in question...that way, for example, a service pack or Hot...

here's an example: you need to decide what to do with columns that have multiple or no commas, but here you go:

create table QUADTEST(namefield varchar(60) )

insert into QUADTEST(namefield) VALUES('Noblesville,Fishers')

insert into...

if you can, redesign your data storage... you should use a date time filed to store the date and the time together. if you need them separate, you can always...

you would want to deploy the SQL Native Client drivers with your application. you would not need anything else.

here's what MS says: basically they give a reditributable sqlncli.msi file, and...

what is the specific error message you get for error -271; i googled it and couldn't find an example.

ok...you said you were loading the data into a data table. when...

changing collation can be a big project because it's in so many places:

at the server level, at the database level, and separately for each column of type text/ntext/char/nchar/varchar/nvarchar/

here's a script...

i believe your code is trying to update the calculated field, maybe by trying to update it's current value with the same value. it might be automatic. make sure the...

i've seen this many times ; it has to do with the default database for the login in question...change the default login's database from whatever it is now (probably master)...

since you are updating standard2, you should not have joined it: stop the query and do it this way;

UPDATE    Standard2

SET        Standard2.Current_County = ZipMkt06.County2

FROM        zipmkt06 WHERE standard2.patzip = zipmkt06.zip

improved to include the column as well:

select

object_name(parent_obj) As TableName,

syscolumns.name as Columnname ,

sysobjects.name as DefConName from sysobjects

inner join syscomments on sysobjects.id=syscomments.id

inner join syscolumns on sysobjects.parent_obj=syscolumns.id and sysobjects.info =syscolumns.colid

where sysobjects.xtype='D' --default...

I think this is what you are looking for: this is for a single database, you'd need to wrap this up for the sp_msForEachdb proc for every location on every...

i don't see how/if A is related to b, but it is something like this i think: maybe left or right joins, you'd have to examine the actual data:

select  a.[Value],...

i kind of assumed that the uniqueness you wanted was firstname/lastname, so all other columns would be a min() or max(), unless those columns make the row the distinct -ness...