Need query assistance.

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  June 18, 2013 at 11:57 am

  #275319

  Is there a way to structure a single query to select all the unique values from field 1 of table A, and the unique values from field 2 of Table A and then select count(*) for all of the resulting combinations of field 1 and field 2 values?

  Thanks in advance.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 18, 2013 at 12:04 pm

  #1625175

  Please don't cross post. It just wastes people's time and fragments replies

  No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1464819-392-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass