Peformance issue with zip codes and addresses

  • Hi.

    I have a lot districts with zip codes and sales figures. Then i join some addresses to each zip code.

    Finally the user try to filter several districts, render and get all the data with many many addresses.

    Does anybody has an idea to display such a report?

    Thx 🙂

  • reportmaster (7/20/2011)


    Hi.

    I have a lot districts with zip codes and sales figures. Then i join some addresses to each zip code.

    Finally the user try to filter several districts, render and get all the data with many many addresses.

    Does anybody has an idea to display such a report?

    Thx 🙂

    You are extremely familiar with the table structures, but to someone reading your request who is not, there is not much one can say except "It depends".

    If you would post the table structure(s), some sample data and the expected / required results from that sample data someone will be able to provide you with a tested solution.

    To achieve this, please click on the first link in my signature block and read the article and use the included T-SQL code to post table structure(s) and sample data.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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