Count occurances across several fields?

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  January 23, 2012 at 2:00 am

  #1436971

  mick burden (1/23/2012)

  ---

  EDIT

  please excuse me, I've gone back over the code and discovered a typo caused by me. Everything appears ok, thanks

  Make sure you understand what's going on in the code, here are some articles that might help (assuming you used what I wrote) : -

  CrossTabs part 1[/url] (you could skip this is you're familiar with the concept, but it's an interesting read that may help for similar situations)

  CrossTabs part 2[/url]

  Unpivot

  More Unpivot

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  January 23, 2012 at 2:05 am

  #1436973

  That's great thanks. I didn't just want code, I always want to know how it works too. Many thanks to everyone who contributed in the answers to my question