Forum Replies Created

Viewing 15 posts - 46,396 through 46,410 (of 59,062 total)

  • RE: The Set-Based Limit

    RBarryYoung (12/23/2008)

    Are we talking about UDF's or builtin functions? as far as I know, the only overhead that the builtin functions have is the CPU cost of their actual...

    December 23, 2008 at 8:09 pm

    #917208

  • RE: The Set-Based Limit

    RBarryYoung (12/23/2008)

    Jeff Moden (12/23/2008)[hrIt was a very long time ago that we did some testing on this very forum and I can't even remember who the players were. I...

    December 23, 2008 at 7:55 pm

    #917203

  • RE: Smart Teaching

    RBarryYoung (12/23/2008)

    Jeff Moden (12/23/2008)

    Can you say "Matrix" boys and girls?

    Sure, they've all seen that movie. 🙂

    Heh... not quite what I meant. If all this so called "smart learning"...

    December 23, 2008 at 7:47 pm

    #917200

  • RE: add business days to a date

    andrewd.smith (12/23/2008)

    Here's a method of calculating the Nth working day in the future without using a CTE or tally table.

    DECLARE @days int

    SELECT @days = 10

    DECLARE @inputDate datetime

    SELECT @inputDate = '2008-12-23'

    DECLARE...

    December 23, 2008 at 7:15 pm

    #917187

  • RE: Are the posted questions getting worse?

    Heh... reminds me of the "SOFH" ("SysOp From Hell") series... google it... the stories are hilarious.

    December 23, 2008 at 6:44 pm

    #917183

  • RE: how to convert vb function to sql function

    Jedi Master (12/15/2008)

    Well yes as I have to make sure that any user input is correctly validated. I can't afford to have null or errors from the function so I...

    December 23, 2008 at 6:15 pm

    #917181

  • RE: Get Missing Data with Tally Table

    Sognibene,

    Well, this one certainly slipped through the cracks... are you all set?

    December 23, 2008 at 6:07 pm

    #917176

  • RE: Expressions based on data in the SELECT statement

    Sorry... this got seriously lost in the wood pile... are you all set on this?

    December 23, 2008 at 6:04 pm

    #917175

  • RE: Executing multiple .sql file using execute sql task

    Ahmad Osama (12/22/2008)

    Jeff Moden (12/22/2008)

    Um.... I don't know much about IIS, but I'm pretty sure that you're going to have to make a trip to OSQL via a command shell...

    December 23, 2008 at 6:02 pm

    #917172

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    Jeff Moden (12/22/2008)

    AnzioBake (12/22/2008)

    Although I know the value this article can represent you can actually be far more generic than you suggest.

    You can write an SP that given the Source...

    December 23, 2008 at 5:59 pm

    #917171

  • RE: Are the posted questions getting worse?

    David Webb (12/23/2008)

    Too many folks are happy with the answer with no idea as to why it works. They get a job done, but they gain no knowledge.

    I hate...

    December 23, 2008 at 5:53 pm

    #917170

  • RE: Are the posted questions getting worse?

    bitbucket (12/22/2008)

    Jeff's

    Ya gotta love it when the ops cooperate.

    Learn from them as well as love it ! ! !

    Oh, hell yes... that and other peoples posts, right or wrong.

    December 23, 2008 at 5:52 pm

    #917168

  • RE: Aggregate bit operator in TSQL

    JohnG (12/23/2008)

    Jeff Moden (12/22/2008)

    Here's a real cheater method...

    SELECT SIGN(SUM(Col1+0)), SIGN(SUM(Col2+0)), SIGN(SUM(Col3+0))

    FROM SomeTable

    That only works for the first bit. I have a similar problem where...

    December 23, 2008 at 5:33 pm

    #917166

  • RE: add business days to a date

    Heh... dunno why we're pussy footin' around it... :hehe: if you don't already have a Tally table, now would be a good time to build one. To find out...

    December 23, 2008 at 5:21 pm

    #917160

  • RE: add business days to a date

    Jack Corbett (12/23/2008)

    There is no built-in method to handle this. Something like this would probably work, but would not handle holidays. The best way would use a dates...

    December 23, 2008 at 12:43 pm

    #917040

Viewing 15 posts - 46,396 through 46,410 (of 59,062 total)