Dear Friends,

Thanks for your Reply...

Actually the above code is my Store Procedure i m passing value to @Table and @AuditMasterID through the front end

i m passing value to the below SP through the Query Analyzer is follows:

exec USP_12 'Auditdata','24'

My SP is as follows:

CREATE Procedure USP_12(@AuditMasterID as varchar(10),@TABLE as Varchar(50))

as

BEGIN

Declare @SQLStatement varchar(2000)

Declare @PrefixNo varchar(20)

Declare @PrefixLen varchar(20)

Declare @AfterPrefixLen varchar(20)

DECLARE Cur_Prefix CURSOR

FOR

SELECT PrefixNo,PrefixLen,AfterPrefixLen FROM NoSeriesMaster_Prefix WHERE PrefixType='SMS' order by ID

OPEN Cur_Prefix

FETCH NEXT FROM Cur_Prefix INTO @PrefixNo,@PrefixLen,@AfterPrefixLen

WHILE @@FETCH_STATUS = 0

BEGIN

SET @SQLStatement = 'update '+@TABLE+' set AuditData.TATCallType=''12'', AuditData.TATCallUnit=''1'' ' +

'from '+@TABLE+' AuditData '+

'inner join AuditMaster am on am.ID=AuditData.AuditMaster_ID '+

'inner join HomeCircleMaster hcm on hcm.Ori_CircleMaster_ID=am.CircleMaster_ID and hcm.Ori_ServiceTypeMaster_ID=1 and hcm.Dest_ServiceTypeMaster_ID=1 '+

'inner join AuditTaggingMaster atm on atm.AuditMaster_ID=am.ID '+

'inner join NoSeriesMaster ns on (ns.CircleMaster_ID=am.CircleMaster_ID or ns.CircleMaster_ID=hcm.Dest_CircleMaster_ID) '+

' and ns.ProviderMaster_ID=am.ProviderMaster_ID '+

' and ns.ServiceTypeMaster_ID=1 '+

'inner join ProviderMaster_CallTypeMaster pm_ctm on pm_ctm.ProviderMaster_ID=am.ProviderMaster_ID and pm_ctm.CallTypeMaster_ID=101 and pm_ctm.CallTypeTagValue=AuditData.CallTypeTag '+

'where AuditData.TATCallType is null and substring(AuditData.CallTo,1,convert(int,'+@PrefixLen+'))='''+ @PrefixNo + ''' and len(AuditData.CallTo)='+convert(varchar(10),convert(int,@PrefixLen)+convert(int,@AfterPrefixLen))+' and '''+@PrefixNo+'''+ns.NoSeries=Left(AuditData.CallTo,len(ns.NoSeries)+convert(int,'+@PrefixLen+')) and AuditData.AuditMaster_ID='+@AuditMasterID+' '

print(@SQLStatement)

exec(@SQLStatement)

FETCH NEXT FROM Cur_Prefix INTO @PrefixNo,@PrefixLen,@AfterPrefixLen

END

CLOSE Cur_Prefix

DEALLOCATE Cur_Prefix

end

plz help me

what should i do.....