Thanks Kevin..

I am running the query in SQL 2005 only..

Thanks for ur reply..

Hi target db is in sql server 2005.

Where i have to add sp_addlinkedserver in 2005 or 2000?

Regards

Hi

Can you provide the clear script..

Bcoz same error.

Hi.. Same Error...

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'COLLATE'.

Thanks shamshudheen ..

It works.

Is anyother way to do this using CTE or other way without using UPDATE, just do select & insert?

Thanks for ur query..

Regards

Sharma

Hi Tables are restructrued by adding id in all the tables.

ID in Address table is pk & ID in qualification table is FK

Initailly Employee table is empty.

Address tbl contains below...

In Server it is worked..

But in Client only it shows error.

I am trying in sql client machine only..

Thanks Squard..

That way i need..

But it insert as three rows.. I need combine this query & insert as single record in employee table..

Regards

No it shows same error..

I am having excel file which contains firstname & lastname..

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "The Microsoft Jet database engine could...

Thanks SanjayAttray

I did

ALTER TABLE NVARCHARTBL

ALTER COLUMN NAME COLLATE default

The above query is correct?

Bcoz It shows error

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'COLLATE'.

Regards

Thanks for ur reply..

In SP where the retrived values are stored?

If i am calling the SP means it throws invalid binding exception..

In Oracle, if we want to retrun more than...

Yes venkat .. Your way is correct.. I need a script without using UNION ALL

Thanks GSquared..

Is it possible to give a script without UNION ALL keyword?

Regards

Sharma

Thanks..

Thanks for ur help.

That link contain sp which call oracle .

In oracle using CURSOR i did it.

In SQL Server SP no cursor is used in that procedure. How can i...

No.. Initially Employee tbl does not contain data