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)