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...

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...

Cadavre (1/11/2012)

---

Also, if Operation always contains every Operation then you could do it like this instead: -

--Actual query version 2

SELECT StockCode,

MAX(CASE Route WHEN 0 THEN Route ELSE NULL END)...

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...

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(...

Ninja's_RGR'us (10/5/2011)

---

The case needs to come earlier in the syntax... this works in my prod server :

, SUM(Quantity) AS QuantityAll

...

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...

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...

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...

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...

I am going on...

Steve Jones - SSC Editor (5/10/2011)

---

The MCSE gives you more opportunity, in my mind, if you need a job that might be part DBA, part Sysadmin. But only if you...

Welsh Corgi (5/10/2011)

---

The MCSE certification will soon be retired and beyond Windows Server 2003 you should pursue an MCITP.

It is much easier to upgrade from an MCSE to to an...