Post reply

Create Table from a variable

  • June 30, 2005 at 2:30 pm

    #570153

    Slow down what???

  • June 30, 2005 at 2:37 pm

    #570159

    select Count(*) Result from posts where patindex(%crap%,words ) > 0

    Result

    -----

    A LOT


    * Noel

  • June 30, 2005 at 2:40 pm

    #570163

    Stupid is as Stupid does.

  • June 30, 2005 at 2:44 pm

    #570166

    It's not that I keep things in different tables, I guess I'm not conveying the flow.

    What happens is that these tables that are created are exported out of SQL and into files which are categorized and dated based on what my remote offices are working with.  At this point the files are either re-imported into a stand-alone SQL box, or into an old old foxpro database for our dialers.

    Each office would request a different lead type to call, and within these lead types they would request a state.  Therefore, I have created a naming convention so that at a glance my management team can know which files they need to import into their systems.  Thus a one-name-does-all approach won't work, I have to create unique names that are differentiated by our Dept/State/Office. 

    Thus the "bad design" evidently.

  • June 30, 2005 at 2:46 pm

    #570169

    I want a recount.

    Just happens to be true unfortunately.

Viewing 5 posts - 16 through 19 (of 19 total)

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