not enough info to really help yet helen.

the real table definition is much more helpful, as well has the name /definition of the table you are "merging" it with, ie

I'm going to agree with you...it's common to see bit fields keeping track of attributes, when more properly it should be one-to-many tables.

you could envision  that if you had to...

the full text catalog is not stored in the database, but actually separately on the server i believe.

as a result, you need to deploy the database, and after restoring it...

wierd...it's ok syntax wise, so I suspect is has to do with teh multi-part-name.

I'd suggest aliasing the table to fix it:

Update idsdemo.FFIITMAP

  set idsdemo.FFIITMAP.FFIHGTH = A.CFFIHGTH

From idsdemo.cubiscan  A

WHERE ltrim(rtrim(A.CFFIITMN)) =...

john i must be reading your post all wrong... for me, if i was going to present int's as hex, I'd do the following:

select convert(varbinary,7) ,'note said --> E0 (hexadecimal...

no need to cross post the same question in different forums. the Active Topics shows all new stuff.

continue and answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=390752

i'm sure I remember someone posting that you want to upgrade the receiver(s) of the replication prior to upgrading the publisher.  other than that I do not remember any issues.

the table idsdemo.FFIITMAP is already part of the query, so you don't want to say FROM <itself>

you want to say FROM <other table> and then add the join conditions.

I...

SQL 2000 /2005 is backwards compatible with SQL7, so I'm not sure why you think you have to use 7...you can set db compatibility to 70 and use 2000 or...

sent you a PM, as we might be getting sidetracked in ASP code vs SQL for the forum. I hate posting huge volumes of code and examples which might side...

<script> tags are for client side usage, whereas stuff inside <% %> would be executed at the server.

the connection does not exist on the clientn side of course.

if your form...

damn I learned something new again. thanks Jeff;

Here's some crappy sample code; you'd probably want to convert to int in order to store the data:

declare @IP varchar(20)

SET @IP = '192.168.1.65'

select...

As Jeff and Sergiy have identified, your data type is doinked. you should have either kept the full IP address, or converted it to an int or big int.

how do...

can you change your procedure to have the WITH RECOMPILE option in it? that would force it to build a new execution plan, and might fix the issue.

you could keep it scalar by doing something like this:

select ID, dbo.functionName (name) from table where id=1