Post reply

SQL Server 2005 - Functions - Stored Procedures - Views

  • May 4, 2009 at 8:42 am

    #384497

    I've recently joined a company where it seems like they make excessive use of functions (table, scalar). When should a function be used.

    The same is true of the stored procedures.

    Both the stored procedures and the functions have at least 6 joins and I've seen them have around 12 joins. Everything I've ever learned has told me to stay away from so many joins.

    Are views the answer?

    If not, can anyone give me any direction on this. I don't want to continue something if that is isn't the correct way to go about it. I often get lost in all of the joins.

    Thanks,

    Debbie

  • May 4, 2009 at 9:01 am

    #988135

    Duplicate thread....please continue here:http://www.sqlservercentral.com/Forums/Topic709419-149-1.aspx

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 4, 2009 at 9:14 am

    #988143

    closing

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

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