Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
select DISTINCT '60 Days' as [Date Range], IV30300.ITEMNMBR As [Item Number], IV00101.ITEMDESC As [Item Description], IV30300.DOCNUMBR AS [Doc], SUM(IV30300.TRXQTY) OVER (PARTITION BY IV30300.ITEMNMBR, IV30300.TRXLOCTN) As [SUMQTY], IV30300.TRXLOCTN As [Location Code], CASE WHEN IV30300.DOCTYPE = '1' THEN 'Adjustment' WHEN IV30300.DOCTYPE = '2' THEN 'Variance' WHEN IV30300.DOCTYPE = '3' THEN 'Transfer' WHEN IV30300.DOCTYPE = '4' THEN 'Purchasing Receipt' WHEN IV30300.DOCTYPE = '5' THEN 'Sales Return' WHEN IV30300.DOCTYPE = '6' THEN 'Sales' WHEN IV30300.DOCTYPE = '7' THEN 'Assembly' END AS [Document Type], IV30300.DOCDATE As [Document Date], IV30300.TRXQTY As [Qty], IV30300.UOFM As [U Of M], IV30300.UNITCOST As [Unit Cost], IV30300.EXTDCOST As [Extended Cost], IV00101.USCATVLS_1 as [Use] from DTZ..IV30300 INNER JOIN DTZ..IV00101 on DTZ..IV30300.ITEMNMBR = DTZ..IV00101.ITEMNMBR INNER JOIN DTZ..IV00102 on DTZ..IV30300.ITEMNMBR = DTZ..IV00102.ITEMNMBR and DTZ..IV30300.TRXLOCTN = DTZ..IV00102.LOCNCODE WHERE IV30300.DOCTYPE IN (1, 6) and IV00102.QTYONHND > 0 and IV00102.QTYONHND - IV00102.ATYALLOC > 0 AND IV00102.RCRDTYPE <> 1 AND IV00101.USCATVLS_1 IN ('FG', 'RAW') and IV30300.TRXQTY < 0 and IV30300.DOCDATE < cast(getdate()-60 as datetime)
|SQL Server Communications Audit||5||67|
|How can I exclude some wording in a like statement?||39||65|
|CRM 2011 How to Create a Quote with same QuoteID and QuoteNumber||4||46|
|How to use odbc in vb to connect to ms sql||14||34|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!