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...

Hi Tim can you clarify... Is the question "create a thumbnail image from an image i have so I can either use the thumbnail or save it in the db?"...

it looks like you have 12 fields you want to grab from 3 columns, is that right? so this is really ONE record with 12 fields?

importing from excel , by...

i think it might have to do with the table variable;

 SELECT userid, fname, lname, toemail FROM users, @clientstable CT WHERE users.userid = CT.userid

i would look at the execution plan, but...

minor, maybe do to a copy/paste/edit, but i think one variable is not declared, and another is never initailized:

CREATE PROCEDURE [dbo].[proc_broadcastemailsget]

AS

DECLARE @clientstable TABLE (userid INT PRIMARY...

i guess what i was suggesting is that when you are looping thru the datagrid, I would have put the userid's that had checkboxes checked in their associated data row,...

there's several ways...I would suggest a group by:

SELECT ENO, Fname, Lname, MIN(Dept) as Dept, MIN(Start) as Start, MIN(End) as [End], MIN(Chngdate) as Chngdate FROM sometable

group by ENO, Fname, Lname