1
My query is
USE ...
SELECT @JNo=jour_no from WB_PMS..tblJournal WHERE jour_scode=@Jcode
IF EXISTS (SELECT 1 FROM WB_PMS..tblArticle WHERE jour_no=@JNo AND art_no=@ArtNo)
BEGIN
SET @XML=
(
SELECT
j.jour_scode AS JournalID,
a.art_no AS ArticleID,
...
declare check1 cursor for
SELECT ACCT_CODE, SCRCODE ,expdate, qty ,uniqno,busirate,base_value FROM #TempBS
where busi_type='B'
ORDER BY acct_code, scrcode
OPEN check1
FETCH NEXT FROM check1 INTO @lc_acct_code,@lc_scr_code,@ld_exp_date,@ln_check...
