need help in writing join select query

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  October 18, 2004 at 9:33 am

  #182101

  Hi,

     I am trying to develop a report. Basically we have two tables named A and B.

  In Table A we have columns

  DelivTypeId

  EstDate

  CompDate

  In Table B we have columns

  DelivTypeId

  DelivDesc

  I have written a join select statement to get the DelivDesc, StartDate, Enddate

  so the result would be like

  DelivDesc           StartDate        EndDate

  Tiering1              8/31/2004       9/20/2004

  Tiering2              8/31/2004       9/20/2004

  Tiering3              8/31/2004       9/20/2004

  Tiering4              8/31/2004       9/20/2004

  I need my datagrid look like this

  Tiering1              Tiering 2              Tiering 3            Tiering 4

  Completed           Completed          Completed         Completed

  I need to put the column values as column labels and I need to check whether the completed date is less than the current date. if so i need to place "Completed" in that column.

  Can you please let me know how to do this? Do I need to change my Select Statement or can i access multiple rows inside my datagrid?

  Thanks,

  Sridhar!!

• herb walles

  Say Hey Kid

  Points: 692

  More actions

  October 18, 2004 at 10:29 am

  #527067

  this article might help:

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q175/5/74.asp&NoWebContent=1

   

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  October 18, 2004 at 12:21 pm

  #527074

  Hi,

    I looked at the article. In that aricle they know the column names before like Q1, Q2,etc but in my case i have to get the column names from another table. Can you point me to any other links?

  Thanks,

  Sridhar!!