Post reply

query for chart

  • January 2, 2012 at 3:51 pm

    #262337

    Hi

    I have 2 tables

    tbl_impressions

    ImpressionID

    SupplierID

    ImpressionDate

    tbl_clicks

    ClickID

    SupplierID

    ClickDate

    I need to write query where I can get number of clicks and impressions for specific supplier (supplierid from dropdownlist) for each month and year.

    for example

    12/2011 impressions 7 clicks 2

    11/2011 impressions 5 clicks 1

    .

    .

    .

    where supplier ID = @SupplierID

    through whole table

    Thanks for help

  • January 2, 2012 at 4:02 pm

    #1427501

    duplicate post. no replies please (see original post)


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

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