Thank you. I got it. Dependents details are in a separate table and we need total dependents details in a another table, which is in a separate server.

I want only one row to return, to get update to "dbo.tblHOF.TotalDependents" column.

Snapshot of both tables is as follows:

Table 1: tblHOF

FamilyID HoFName Age...

Sorry I didn't noticed that! I will read it first now. Thank you again.

Dear Cadavre,

Thank you for reply.

I tried this way to get member_id, member_name, age also in the same row, but failed.

SELECT @SQL = COALESCE(@SQL,'') + 'MAX(CASE WHEN...

Thank you guys. As you all told, the option might be to restore the database as version 7/8 in SQL 2005. Now the only way for me is to migrate...

Oh. I remember, when I worked with SQL 2005 version for first time, (some 2 years before), there was an option in SQL 2005 to restore the database as version...

Thank you steveb, your last message has solved the problem. After enabling my system for supplemental languages, I can read the data from SQL server.

Yes, am using SQL Serer Import and Export Wizard to port data.

Hi steveb,

Am using DTS service from SQL Server to port data from Access to SQL.

Hi,

Thanks a lot Steve Jones and Jack Corbett. I was thinking of using SQL Server Express edition and installed and checked also. But the thing is, I don't...