Post reply

Creating a Phone Book / Horse Blanket type thing...

  • January 4, 2008 at 1:27 pm

    #181913

    Hey guys. I'm not sure where to start on this but what I'm looking to do is to create a big sheet of Departments / People / Phone Numbers on a large scale sheet. All the information that's needed is already located in a database. What would be my best bet to use to extract the information I need and to have it automatically placed in the format I need it to be in. The sheet would be roughly 3.5' x 3'.

    Any help would be greatly appreciated into starting this off.

    This could possibly be in the wrong section, sorry for that. Not sure if it belonged here or in another one but SQL Server 2005 would be what I'm extracting from.

  • January 4, 2008 at 7:44 pm

    #765015

    Heh... do you intend to print that size sheet?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • January 4, 2008 at 9:40 pm

    #765042

    Yeah, we have access to a very large / expensive printer which will print exactly that.

  • January 4, 2008 at 10:05 pm

    #765047

    Probably easiest to write a pass-through query (maybe to a view) in Excel and print from Excel.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 4 posts - 1 through 3 (of 3 total)

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