Post reply

Undocumented Routines: Forbidden fruit.

  • November 16, 2012 at 8:23 am

    #1559837

    @jeff

    I must admit chuckling a bit whilst writing that article, thinking of the reaction of some DBAs I knew. I was, at the time, writing a website that used a lot of the techniques. it ended up being blindingly fast and simple to implement.

    Best wishes,
    Phil Factor

  • November 16, 2012 at 9:23 am

    #1559850

    jbayliss (11/16/2012)

    Especially being one myself, I love "old school". We do know how to hammer out a work around to "improvements" and deprecations. 🙂

    I don't know what your level of HTML knowledge is but Phil Factor's post (post above) shows the same basic method that I use to work around the demise of sp_MakeWbtask. Is that enough or do you need more help on this?

    Phil, that is way cool!. Just did a quick mockup on my system- this is going to be fun to work with. Now to look up your link. Thanks!

    Jeff, I too enjoy the challenge of figuring out how to get something to work in spite of the limitations put in our way.

    May take me a while but I do believe with the options y'all have given me I can make it work.

    Thanks everyone,

    Jim

    There are some pretty easy ways to do conditional formatting (eg. Change the background of a "cell" if certain conditions are met) that are super simple additions to the code Phil Factor posted. Let me know if you need such a thing and I'll try to put together a small example for you.

    --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)

  • November 16, 2012 at 9:54 am

    #1559864

    There are some pretty easy ways to do conditional formatting (eg. Change the background of a "cell" if certain conditions are met) that are super simple additions to the code Phil Factor posted. Let me know if you need such a thing and I'll try to put together a small example for you.

    Thanks Jeff, That may be useful to alert the user of differences between the two records, like zip codes or addresses being different. Let's wait until i get that far though. Priorities and projects can change quickly around here.

  • November 16, 2012 at 9:59 am

    #1559865

    Sorry to boringly point out an article vI once wrote where I explain how to format cells according to content without needing to alter the SQL at all.

    Making HTML tables easier on the eye- CSS Structural Pseudo-classes http://www.simple-talk.com/dotnet/.net-framework/making-html-tables-easier-on-the-eye--css-structural-pseudo-classes/ Yes, I hit precisely the same problem.

    Best wishes,
    Phil Factor

  • November 16, 2012 at 12:08 pm

    #1559907

    Phil Factor (11/16/2012)

    Sorry to boringly point out an article vI once wrote where I explain how to format cells according to content without needing to alter the SQL at all.

    Making HTML tables easier on the eye- CSS Structural Pseudo-classes http://www.simple-talk.com/dotnet/.net-framework/making-html-tables-easier-on-the-eye--css-structural-pseudo-classes/ Yes, I hit precisely the same problem.

    Guile, I like it. This has turned into an exceptional learning event, now to use it!

  • November 16, 2012 at 1:22 pm

    #1559929

    Update (leaving for the day so will not get much more done other that saving what I have so far.)

    Step one is completed, was able to modify Phil's script to return two data sets. Will probably work next week on getting the qry results into the html file. But will be a much better weekend than I anticipated this morning.

    Thank You,

  • December 11, 2012 at 7:26 am

    #1567439

    Jeff and Phil,

    Thanks again for you help and great tips. My inexperience with CLR and the security issues with the other options left me with no choice but to use JavaScript, ADO and stored procedures.

    My app is about 80% complete with only debugging, and incorporating changes resulting from learning more about our data.

    Working alone means having no one to bounce ideas off of, your replies filled a gap for me and helped me see the best solution.

    Thanks a bunch,

    Jim

Viewing 7 posts - 31 through 36 (of 36 total)

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