« first day (391 days earlier)      last day (114 days later) » 

12:00 AM
1
Q: Empty closing XML tag instead of self-closing tag

RaghuMy 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, ...

 
 
14 hours later…
2:09 PM
-4
Q: cte similar to the cursor below

Mary Erimiadeclare 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...

 

« first day (391 days earlier)      last day (114 days later) »