Well that has certainly opened up the can of worms -

OK - The process I need to complete is as follows;

When a Sales Order is Dispatched - I need...

Thanks for the advice.

I will spec. it out a little further - just the concept of ... can it be done via a trigger on a table ... answer so...

Thats a very good point about the database growth over time.

Currently sat at 6gb - started at 700mb.

When doing "selective Restores" - I do take a "Copy Only Backup" at...

Agent Job with ...

USE msdb;

GO

EXEC sp_delete_backuphistory @oldest_date = (GETDATE() - 60);

to keep 60 days ?

Great - I was thinking along the same lines... although I might want to restore my Backup/T-Log from February 15th 2010 !

Thanks for the input

I currently use the OUTPUT method to populate the results from an INSERT/UPDATE

Comparing two tables and updating the data and populating the results to an audit table.

INSERT INTO tablenamehere (field1,...

Thinking about this over the weekend - I think as per the previous suggestion - I need to create a Fiscal Calender with counts for the months/years.

so the table would...

Yes - I understand - but that is what the TrnYear and TrnMonth fields are.

so forget the TrnDate Fields -

I suppose something like ....

Max TrnYear, TrnMonth to give 2013,...

Okay ... table and data.

The results I would expect are .

StockCode, MonthToDate, LastMonth, Previous6Months, Previous12Months, Previous18Months, Previous24Months, Previous36Months

38-1446-9912, 31, 98, 253, 253, 253, 253, 253

...

The easy bit -

SELECT

StockCode,

SUM(CASE TrnYear WHEN '2009' THEN InvoiceQty ELSE 0 END) AS Sales2009,

SUM(CASE TrnYear WHEN '2010' THEN InvoiceQty ELSE 0 END)...

definetly not RAID 0

Hi Gail,

Thats why I am asking for suggestions - the book said to set up the Raid 1 and Raid 5 for Backups - but not about sizing or number...

Hi Gail,

Ahhhh interesting ...

looks like its already done a few times ... interesting reading.

Thanks

Markus (5/9/2013)

---

SteveEClarke (5/9/2013)

---

Yes I agree - I think it might be that - as I was testing the BI functions within 2012 - and may have changed the 2005 MP's...

Yes I agree - I think it might be that - as I was testing the BI functions within 2012 - and may have changed the 2005 MP's on the...