PIVOT Table

• NimBus_87

  Valued Member

  Points: 68

  More actions

  May 21, 2010 at 12:40 pm

  #103944

  Hi all,

  could someone please help me with the query below. It is about changing a query which has a PIVOT statement from microsoft access into SQL Server SP.

  i did google for solutions and found some basic ones, but they did not help me, the query i am dealing with is way complected for me as a new SQL Server user. i have been trying to solve this problem all day and got nothing, so please HELP me !!

  this is the SQL view from access:

  TRANSFORMCount(tblA.A) AS Something

  SELECTtblB.C

  FROMtblC

  INNER JOIN (tblA

  INNER JOIN tblB ON tblA.B = tblB.B) ON tblC.A = tblA.A

  WHERE tblC.Date Between @StartDate And @EndDate

  GROUP BY tblB.C

  PIVOT tblA.D In ("1","2","3","4");

  result for running this query from access:

  C,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,,,,,2,,,,,,,,,,3,,,,,,,,,,,4

  ------------------------------------------------

  Something 1,,,,,,,,,,,,,,,,,,,,,,,1

  Something 2,,,,,,,1

  Something 3,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,2

  ", = space"

  Thanks, and looking forward to hearing from you

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  May 24, 2010 at 6:11 am

  #1171490

  post sample data with table definiton . see the link in my signature

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)