Forum Replies Created

Viewing 4 posts - 421 through 424 (of 424 total)

  • RE: function vs. another table join

    Carl Federl (12/30/2007)

    Your example SQL is exactly the case where a table would be superior to a stored procedure. With a table, the values of the date range are...

    December 30, 2007 at 2:52 pm

    #763571

  • RE: function vs. another table join

    Carl Federl (12/30/2007)

    As the SQL Query optimizer can make use of table indicies, constraints and statistics but cannot determine the result of a function, recommend using a table.

    thanks, but the...

    December 30, 2007 at 12:13 pm

    #763566

  • RE: function vs. another table join

    Jeff Moden (12/29/2007)

    Heh... thought you said you "Frankly, I don't want to waste time working on something that's a bad idea or trying to prove which one is better"

    correct. ...

    December 30, 2007 at 11:47 am

    #763565

  • RE: function vs. another table join

    Thanks, but that link simply describes how to create a calendar table (which we already can do for the various tables). It does not contrast benefits/drawbacks of using a...

    December 29, 2007 at 3:59 pm

    #763532

Viewing 4 posts - 421 through 424 (of 424 total)

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy