Hii I am Varun i have a problem with the dynamic stored procedure
This is my stored procedure
ALTER PROCEDUREdbo.sp_TimeTableAdjustment1(
@.TeacherID_OnLeavenumeric(9),@.DateFromdatetime,
@.DateTodatetime, @.UserIDnumeric(9))
AS
declare@.flagas numeric(9)
declare@.yearas varchar(4)
set@.year=(selectbatchfrombatchmasterwhereiscurrent=1andisdeleted=0)
if( @.year=null or len(@.year)=0)
set@.year =year(getdate())
exec('if not exists(select * from timetableadjustments_'+@.year+' where datefrom='''+@.datefrom+''' and dateto='''+@.dateto+''' and teacherid_onleave='+@.teacherid_onleave+')begin
insert into TimeTableAdjustments_'+@.year+' (TeacherID_OnLeave,DateFrom,DateTo,UserID) values ('+@.TeacherID_OnLeave+','''+@.DateFrom+''','''+@.DateTo+''','+@.UserID+');
end')
else
set@.flag=(selecttimetableadjustmentidfromtimetableadjustments_2007wheredatefrom=@.datefromanddateto=@.datetoandteacherid_onleave=@.teacherid_onleave)
return@.flag
--exec('select timetableadjustmentid from timetableadjustments_'+@.year+' where datefrom='''+@.DateFrom+''' and dateto='''+@.DateTo+''' and teacherid_onleave='+@.TeacherID_OnLeave+'
--')
--return @.flag
--exec('@.flag=select timetableadjustmentid from timetableadjustments_'+@.year+' where datefrom='''+@.DateFrom+''' and dateto='''+@.DateTo+''' and teacherid_onleave='+@.TeacherID_OnLeave+'')
And the problem?...
