Post reply

Multidimensional query?

  • March 14, 2007 at 9:21 am

    #175642

    Hi Folks,

    I have a database table named tblstorecheck.

    I would like to create a new sql view based on this database table.This database view will include these columns:

     

    QuestionName Results1 Results2 Results3 Results4 Results5

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

     

    the count of the columns will be the number of the distinct StoreID s...

    Is this a multidimensional query? How can I get this result.Please Help

  • March 14, 2007 at 9:29 am

    #694983

    This is the same question as your other one.  You should include this info in your other post as well as the table structure and sample data from the table.

  • March 14, 2007 at 9:38 am

    #694985

    I have included all data from the table and this is really enough!

  • March 14, 2007 at 12:51 pm

    #695041

    Nobody but you can see the image you included in your post because it points to a file on your hard drive. 

  • March 15, 2007 at 12:27 am

    #695144

    is it ok now?

     

  • March 15, 2007 at 2:23 am

    #695154

    Hi erden ,

    We r not able to see anything.....

     

    Regards,

    Amit Gupta

  • March 15, 2007 at 2:24 am

    #695156

    Hi erden ,

    We r not able to see anything.....

     

    Regards,

    Amit Gupta

  • March 15, 2007 at 2:24 am

    #695155

    Hi erden ,

    We r not able to see anything.....

     

    Regards,

    Amit Gupta

  • March 15, 2007 at 2:30 am

    #695157

    ok?

  • March 15, 2007 at 6:13 am

    #695192

    no it is a broken image.  run your query in query analyzer and paste the results into your message.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply