Sorry for late reply to lutz iam actually trying the same in .NET and i was bit busy on that, As this report should go live tommorow iam just exploring...

Hi ,

Sorry for not entering properly,

I have modified the post

Id, Name, EStartDate, PPAID, EEndDate

1, 01_Event1106_Pretoria, 6/11/2010, 1(PPAID), 6/11/2010

2, 01_Event1006_Soweto, 6/11/2010, 1(PPAID), 6/11/2010

3, 01_Event1106_Pretoria, 6/11/2010, 2(PPAID), 6/11/2010

4, 01_Event1006_Soweto, 6/11/2010, 2(PPAID),...

Hi Thanks for your reply, I have already seen those posts before posting my problem may iam poor in Sql i was not able to find any solution from those...

But how can i run a script in .sql file in proc, becuase i want it in sql file only (for me no other option)

but i want it as a reusable component so that i can run when ever i want

It is very useful thank you very much Gail

I have a SP which will accept ID and CultureID depending on there two things it will give me a scalar value that is "Name"

Now the above proc is working...

I have a SP which will accept ID and CultureID depending on there two things it will give me a scalar value that is "Name"

Now the above proc is working...

Sorry for 2 Posts first time site gave me some error so i entered it again, but it took both the 2 posts

Thanq john actually i am sarching for any buit in function or view for this any ways thnq for the reply