Sorry Dear, but this is also not working.

Paul,

I appreciate your help. But i can't change table definition. this is just an example. i want to apply this logic in my live environment SP. It's already very complicated....

Friends,

Thanks a lot for all your help and giving your precious time behind this stuff.

I am posting one more stuff related this stuff in same forums TSQL(SS2K5). If possible please...

I think this is work...

SELECT

'Order_No' = CASE WHEN C.Row_No = 1 THEN CONVERT(VARCHAR(20),C.Order_No) ELSE ' ' END,

'Name' = CASE WHEN C.Row_No = 1 THEN C.Name ELSE '' END,

'Total_Cnt'...

Thanks a lot dear.....

For use delete cascade use following Create table script...

CREATE TABLE test_child

(SUB1 INT,

[NO] int,

FOREIGN KEY ([NO]) REFERENCES Test_parent

...

Thanks dear

Thanks for the valueable reply.

My requirement is to call this function approximately 2000 times in a hour from front end system, will it serve purpose, or still i need look...

Thank you....... Andras

Hi Andras:

Thanks for your reply.

In SQL 2000 we had a field called "schema_ver" in sysobjects which changes whenever any alteration occurs to any object. Is there any equivalent system object field...

Hi Andras:

Thanks for your reply.

In SQL 2000 we had a field called "schema_ver" in sysobjects which changes whenever any alteration occurs to any object. Is there any equivalent system object field...