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 TOP 100 PERCENT item_id AS [Part Number], 'TSI' AS [Distributor Code], CONVERT(decimal(5, 0), qty_on_hand) AS Quantity, '25' AS [% Discount], CONVERT(decimal(8, 2), price1) AS [Sell Price], CONVERT(varchar, GETDATE(), 101) + '|' AS [Date] FROM dbo.p21_view_inv_loc WHERE (qty_on_hand > 0) AND (product_group_id LIKE 'mac%') ORDER BY item_id
|join 2 views with 5 conditions||3||43|
|Help Parsing a String with SQL Syntax||23||25|
|Extract string portion||2||10|
|Whats wrong in the below query? Any help would be appreciated...||2||8|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!