That worked! and also helps to give me a better understanding of the join syntax.
Thanks for helping me out, and a very Happy...
I have another similar query, which I want to use for updating a table that I am having a problem with as the query is more complex so I am posting...
Got this working okay with a bit of trial and error, ended up using the same query...must have had a syntax issue before or my structure was not...
I tried the following:
set X.A = Y.A
from tbl1 X, tbl2 Y
where X.B = Y.B
I get an error about multi part identifier
still learning, its still quite complex for me.
how can I formulate your response into a sql statement for update (not insert)?
so far I...
I need to peform the following (performance is not an issue as its not production):
1. select col1 from tbl1
2. use these results to run...
Thanks Adriaan, that worked.
So for sql server v7:
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
I know how to check collation in sql 2k5 but not sql v7...tried a bunch with no luck:
sql server properties
Thanks for the reply.
Although not too familiar with COLLATION, I did read the link and I think this is not the problem.
Sorry for not making this clear. I only have basic knowledge of joins, so please forgive my ignorance on the subject. I believe I will...
thanks for the reply!
not sure that the join works in this...there is nothing common to join on between the local and linked db....
I have the follwoing query:
select col1, col2, col3 from [linked_server].db1.dbo.tbl1
where col1 not in (select col1 from tbl1)
I get the...
Separate names with a comma.