hi,

Thanks a lot

This is for the creation of a dynamic report.I can give my code to generate my table

create table kpuser.tbl(vtype varchar(50))

declare @UnitID varchar(8000),@FieldName varchar(50),@Unit_ID varchar(30)

select @UnitID=dbo.unitbelow('252')

set @UnitID = @UnitID +...

i have a master table that have some unit name based on unit id.Using a function named unitbelow i pass one Parentunitid and i get the corresponding unitid under that...

Hi,

Thanks for it.

Now I have another problem.

Now I am Passing 4 Parameters to my Store Proc.

Here is my Store Proc

Using a User define Function Callad UnitBelow will retrive some data...

Hi,

Thanks for it.

Now I have another problem.

Now I am Passing 4 Parameters to my Store Proc.

Here is my Store Proc

Using a User define Function Callad UnitBelow will retrive some data...