Hey Ian Yates,

I agree with you, but in my case, no need to keep the old data in production database, so i wants the data should be remove permanently.

So what...

Hey Brad,

I am now using more than 15 numbers of cascade delete in my Database.

Is it correct to use cascade delete in all relation?

the reason behind using it,

its easy for...

Thanks Grant,

I really feeling great that i am a part of Sql Server Central.

I will change the DB Design in the Monday.

I really appreciate the way you just guide me...

I...

Hey Grant,

Thanks for your trying,

did you get any way to solve this?

Cheers!

Sandy.

Hi Jeff,:hehe:

Thanks for your suggestion.

I will follow this..

Thanks for the same...

No more.....he he he..lolz...;):P:w00t::cool::hehe:

Cheers!

Sandy.

Hey Grant,

Nope, Actually I don't want to call any other Store Procedure or function from out side to main procedure.

I wants to define a small block of code in side...

Hey sqluser,

Thanks, It is working...

Jeff,

Actually I asked about this post...

" http://www.sqlservercentral.com/Forums/Topic444141-338-1.aspx "

he...

Jeff,

Clearly Cheating.....;)!!!

Jeff, I already did it by using Dynamic TSQL,

but how can it possible in One single Select Query?

Ok, Let me try today evening ...

if not you will give the...

Jeff,

Can you Please Look into this topic?

Cheers!

Sandy.

Hey Adams,

Can you please write the Sql query for this?

:w00t::hehe::cool:

Cheers!

Sandy.

Jeff,

he he he..lolz...:P ....

Now you will tell me....hee hee ..in my shop.....;)

Please Tell me the Answer,

Jeff, Is it possible or Not?

Please ....

Cheers!

Sandy.

Jeff,

Where is Grant....???

😉

Cheer!

Sandy.

More Clear to all,

Here In Above Post,

My Stored Procedure is calling one function almost 30 nos. of time

after checking the condition.

if also i am using the out...

Hi Jeff,

Its one of the requirement,

Is it possible by using single Query....??

I am using TSQL for this by

taking Temp table and Going row by row....

So Any Idea..

Cheers!

Sandy.

hey Jerome, ha ha ha....:)

Be Cool,,,

I just shared what I feel...

and One thing, Let this topic leave to the recruiting people.

why are we break our head for this....!!!

he he he...lolz:)

Cheers!

Sandy.