i have Two databese TestDB and LiveDB
One Procedure Use In Both Database Same Table And View
My Procedure is Show :
Text
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE procedure Proc_GetDSRequest
(
@nDivisionNo varchar(Max),
@nCategoryNo numeric(18,0),
@nConferenceNo numeric(18,0),
@fromdate datetime,
@toDate datetime,
@ReqMKTApproved bit,
@ReqFINApproved bit,
@ReqProcessed bit,
@ReqConfirm bit,
@nBookTypecode int,
@OnlyCount char(1),
@StartNo int,
@EndNo int,
@Status varchar(50)
)
As
Begin
declare @tblMain as table(nDSReqHdrNo int, nDSReqDtlNo int, vDSReqCode varchar(100), dDSReqDate datetime,ServiceDate Datetime, ...
Go to the complete details ...