Viewing 15 posts - 46 through 60 (of 134 total)
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 12, 2013 at 1:06 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 11, 2013 at 9:32 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 11, 2013 at 7:42 am
Agent Job with ...
USE msdb;
GO
EXEC sp_delete_backuphistory @oldest_date = (GETDATE() - 60);
to keep 60 days ?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 11, 2013 at 7:26 am
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
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 11, 2013 at 7:21 am
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,...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 11, 2013 at 6:06 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 10, 2013 at 4:30 am
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,...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 6, 2013 at 1:23 am
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
...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 4, 2013 at 1:49 am
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)...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 3, 2013 at 8:44 am
definetly not RAID 0
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 20, 2013 at 7:39 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 20, 2013 at 7:02 am
Hi Gail,
Ahhhh interesting ...
looks like its already done a few times ... interesting reading.
Thanks
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 20, 2013 at 4:46 am
Markus (5/9/2013)
SteveEClarke (5/9/2013)
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 10, 2013 at 1:14 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 9, 2013 at 12:01 pm
Viewing 15 posts - 46 through 60 (of 134 total)