Thank you.

Looking past the selection into the PIVOT ! - sometimes look too hard for a solution to a problem that is never there.

Totally brilliant - thank you.

In the meantime I have used the PIVOT function to create a View - dropped into Excel and then conditional formatting to show the current warehouse...

Ahh right - sorry - yes I was playing with just the SELECT part of the query - which returns correctly and then I forgot to uncomment the bin, Rack

But...

Thanks for your help and thoughts - it is always the trouble when you change jobs and inherit systems that "The Users think best!"....

Its a real shame that we have...

Thanks for your reply -

The problem is that there is a "Custom Database" setup which people have used Text/Char fields to store numeric in - what I am trying to...

Hi -

I think I am right in saying that you are trying to display the Product Class and Months of sales - but you may not have sales in...

Brilliant - thank you.

I do like Simple answers

You would only need SQL Server Browser service if you are installing a NAMED Instance rather than the default instance. The SQL Browser listens on the different ports that...

What other message do you get ?

Is there anything in the Event Viewer ?

Thanks Sean - I will give that a try - we do use interpersonate - as its an ERP system with security within the GUI rather than at the SQL...

Sorry - that seems to be working as expected -

Thanks -

I think when I tried that I had "CASE fieldname WHEN" rather than "CASE WHEN fieldname"

Regards

Sorry -

What I am trying to achieve is a CASE within a CASE I suppose

Two conditional checks ...

So ...

SUM ( CASE field_SEX WHEN "MALE" THEN

...

Okay -

So I have a basic table - 100 Columns - ALL VALUES, when populated, there are NULL values entered instead of 0 ( zero ).

So want to scan...

Maybe worth reading this..

http://technet.microsoft.com/en-us/library/ms186865.aspx

Just looking at some resources on the web.

http://technet.microsoft.com/en-us/library/ms189798.aspx

This explains the RANK options that were talked about earlier in the topic - I think now this was a little...