Hi Chris,

Thanks for your help ..Now It's Working!!

Hi Chris,

Thanks, but your query gives one another error :

:Subquery returns more than 1 row

I want to update all program_id according to episode_id in episode table.

Waiting for your reply...

Thanx Tomm, It's good logic.

Thanx Gail....

Plz give an example how to use these function from Stored procedure...

But how can i compare the result..?

It is impossible to change the schema of table. bcoz this table has 66000 records.

There is no other solution..?

yes sir...I understood the query very well and giving explanation to my friends also.

thank you sir.

Thank you sir...It is my homework for today..

thanx again

OK...

i hv a table tblDesidnation which hv 2 fields.

DesignationName varchar(100), Description Varchar(1000)

if table hv 50 row then the desire output is first 2 rows, middle 2 rows means record no...

I m very happy.

Thanx

Thank you sir.

thank you very much... My problem is solved now.

yes, i want to remove <img..> tage from whole string.....

Plz explain in detail... I m New for SQL

i don't understand. Plz give me example....

Plz..

Thanks to all of u....

thanks a lot.