I have 2 tables in which we have common values as names field and i need to fetch id from one table to another table based on names. there is lot of data that i can't manually give hard core values. i tried this
update name set name_id = example.id from example where lower(example.id) = lower(name.id)
with this code i am able to fetch only 6000 records out of 12000. what might be the issue
Divija Vemulapalli
first of all this is not a forum for POSTGRESQL
This is MS SQL Server forum and solution given here are guaranteed to work in SQLServer only
Anyways in t-sql your query can be better written as
update n
set name_id = e.id
from example e
join name n
on lower(e.id) = lower(n.id)
if it still doesn't work, it may be that you've some unprintable characters in column like space, hard space etc
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page
