Database

declare @parentid int<br />
				select accountparentid=@parentid from account where accountid=@accountid<br />
				<br />
				while @parentid<> 0<br />
				begin<br />
					UPDATE [dbo].[account]<br />
					   SET [accountvalue] = [accountvalue]+@accountvalue<br />
								where accountid=@parentid<br />
					select accountparentid=@parentid from account where accountid=@parentid<br />
END

<br />
set ANSI_NULLS ON<br />
set QUOTED_IDENTIFIER ON<br />
go<br />
<br />
<br />
<br />
<br />
<br />
<br />
ALTER    procedure [dbo].[apo_GetQuestionsByInqTransId]<br />
--Passing inventory id as input variable <br />
--Generate all the questions of it<br />
@InqTransId int,<br />
@appId int,<br />
@option nvarchar(20),<br />
@schema nvarchar(30)<br />
<br />
As<br />
Begin<br />
<br />
	if @option='All'<br />
		begin<br />
				select qm.QID,qm.[name],QM.ParentQID,itql.SequenceNo from QuestionMaster qm,InquiryTransaction it,<br />
				InquiryQuestionLinkage itql   <br />
				where itql.qid=qm.qid and it.InquiryTransId=itql.InquiryTransId<br />
				and it.InquiryTransId=@InqTransId order by QM.ParentQID<br />
		end<br />
	else<br />
		begin<br />
				declare @AnswerDetailTable as nvarchar(40)<br />
				set @AnswerDetailTable =@schema+'.AnswerDetalTable'<br />
				select qm.QID,qm.[name],QM.ParentQID,itql.SequenceNo<br />
				from QuestionMaster qm,InquiryTransaction it,InquiryQuestionLinkage itql   <br />
				where itql.qid=qm.qid and it.InquiryTransId=itql.InquiryTransId<br />
				and it.InquiryTransId=@InqTransId and qm.QID not in(select QID<br />
				from @AnswerDetailTable<br />
				where appId=@appId)   <br />
				order by QM.ParentQID<br />
		end<br />
<br />
End  <br />