Viewing 15 posts - 16 through 30 (of 134 total)
Thank you.
Looking past the selection into the PIVOT ! - sometimes look too hard for a solution to a problem that is never there.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 17, 2014 at 9:20 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 10, 2014 at 7:53 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 10, 2014 at 5:24 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
November 18, 2013 at 5:05 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
November 14, 2013 at 9:13 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
November 13, 2013 at 4:36 am
Brilliant - thank you.
I do like Simple answers
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
October 16, 2013 at 4:05 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 26, 2013 at 2:11 am
What other message do you get ?
Is there anything in the Event Viewer ?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 26, 2013 at 2:09 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 26, 2013 at 1:39 am
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
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 25, 2013 at 9:17 am
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
...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 25, 2013 at 8:37 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 16, 2013 at 1:59 pm
Maybe worth reading this..
http://technet.microsoft.com/en-us/library/ms186865.aspx
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 16, 2013 at 7:28 am
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 misleading as...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 16, 2013 at 7:17 am
Viewing 15 posts - 16 through 30 (of 134 total)