Viewing 13 posts - 121 through 134 (of 134 total)
just to add.
This probelm occurs on a network PC - ( Windows 7, SQL 2008 R2 Express ) so I installed similar on my home laptop - standalone no GPO's...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
March 5, 2012 at 5:23 am
To be honest - Performance is not an issue -
31920 records
consolidated to 10280 in less than a second - I will convert this to a view and then do...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 11, 2012 at 6:24 am
Cadavre (1/11/2012)
--Actual query version 2
SELECT StockCode,
MAX(CASE Route WHEN 0 THEN Route ELSE NULL END)...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 11, 2012 at 5:39 am
I totally agree - but the only person that sees the RAW is myself - I will now put this into a crystal report that will be tidy for the...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
October 5, 2011 at 9:32 am
My mistake - moved the WHEN - well duplicated the WHEN ...
Sum( CASE WHEN (DateDiff(wk,GetDate(), MLineShipDate)) = 1 THEN (MShipQty + MBackOrderQty) ELSE 0 END) as OQ_Wk_01,
Sum(...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
October 5, 2011 at 9:25 am
Ninja's_RGR'us (10/5/2011)
, SUM(Quantity) AS QuantityAll
...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
October 5, 2011 at 9:19 am
Absolutely 100% perfect -
Just added the target table in the select and added the table.alias - added when target is null
bobs your uncle !
Thank you very much for your...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 26, 2011 at 6:39 am
Hi,
I have the same issue - which after taking snipets from online samples and playing them through have been failing - so I have been working through the basics and...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 26, 2011 at 5:13 am
All sorted -
I was looking at the wrong error log -
Right click Jobs, View History !
Found out that the backup jobs were being run under an old service...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 18, 2011 at 4:37 am
Resourse Govenor ! Right
Thanks again guys for the pointers - I have downloaded the sampel test questions and pleased to say that I understand the format and questions are...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 12, 2011 at 6:27 am
arun.sirpal (5/11/2011)
I have passed 4 2008 sql exams and found that the training kits from a book shop cover alot of what was asked in the exams.
I am going on...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 11, 2011 at 2:31 am
Steve Jones - SSC Editor (5/10/2011)
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 11, 2011 at 12:49 am
Welsh Corgi (5/10/2011)
It is much easier to upgrade from an MCSE to to an...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 11, 2011 at 12:47 am
Viewing 13 posts - 121 through 134 (of 134 total)