Forum Replies Created

Viewing 15 posts - 46,171 through 46,185 (of 59,062 total)

  • RE: Cursors Be Gone!

    jacroberts (1/2/2009)

    Jeff Moden (1/1/2009)

    One of my fellow MVP's... Go back and look at Grant's posts... you'll figure it out. I've probably said too much, already.

    When you say "fellow MPV's"...

    January 2, 2009 at 9:12 am

    #920338

  • RE: Cursors Be Gone!

    Alexander Kuznetsov (12/24/2008)

    Actually in most cases the best alternative is a loop written in a modern language such as C#, not a T-SQL WHILE loop or a CURSOR. Not only...

    January 2, 2009 at 9:05 am

    #920336

  • RE: Cursors Be Gone!

    repicurus (12/24/2008)

    I would be happy to contribute TWO examples that I do not think could be accomplished WITHOUT cursors.

    There are several places where I agree that at least a...

    January 2, 2009 at 9:00 am

    #920327

  • RE: Ok, its their first day on the job.

    BWAAA-HAAA!!! The next problem is... finding a good book! 😉 Many of the folks that write such books have some pretty severe ego problems themselves. 😉

    January 1, 2009 at 7:41 pm

    #920071

  • RE: getting all records between 2 fridays of a given date

    Piotr Rodak (1/1/2009)

    Now, that's a cunning trick I see now Jeff :w00t:

    Not earlier than yesterday I said to myself 'one day I have to get those dateadd-datediff calculations sorted out'.

    And...

    January 1, 2009 at 7:37 pm

    #920069

  • RE: Partitining an existing table

    I'm not sure what you're talking about. A clustered index IS the data and adds almost nothing to the size of the table.

    My feeling is that you've not done...

    January 1, 2009 at 7:33 pm

    #920068

  • RE: Split a date-range into periods

    HanShi (10/23/2008)

    I have work out your solution. Maybe others can benefit from this code.

    As you allready mentioned, this solution is more generic. The TALLY table now only contains the number...

    January 1, 2009 at 7:10 pm

    #920062

  • RE: help with sqlcmd

    Lookup "OSQL Utility" in Books Online.

    The real key here is, why are you trying to do this from the command line... SQL Server can check to see if a file...

    January 1, 2009 at 6:55 pm

    #920059

  • RE: Partitining an existing table

    I read the article, probably I dont have a high IQ, could you please let me know what I've done wrong and what I should do?

    Reading just one article probably...

    January 1, 2009 at 6:19 pm

    #920054

  • RE: getting all records between 2 fridays of a given date

    Piotr Rodak (1/1/2009)

    It does unfortunately..

    set language us_english

    go

    select @@datefirst, datepart(dw, getdate())

    go

    set language british

    go

    select @@datefirst, datepart(dw, getdate())

    I had to cope with this on a few occasions.

    Piotr

    That would be true if I used...

    January 1, 2009 at 5:59 pm

    #920053

  • RE: Cursors Be Gone!

    One of my fellow MVP's... Go back and look at Grant's posts... you'll figure it out. I've probably said too much, already.

    January 1, 2009 at 5:52 pm

    #920052

  • RE: getting all records between 2 fridays of a given date

    Datefirst doesn't even come into play on this...

    January 1, 2009 at 2:26 pm

    #920033

  • RE: Join Query (Please Urgent !!!!!!!!!!)

    Heh... interview must be over, huh? 😛

    January 1, 2009 at 2:23 pm

    #920032

  • RE: The Year in Review 2008

    Steve Jones - Editor (12/31/2008)

    Guess no one is working today or my cell phone woes didn't strike anyone as funny.

    Heh... not supposed to slam "Dash" phones against the "Dash"... that's...

    January 1, 2009 at 2:21 pm

    #920030

  • RE: Join Query (Please Urgent !!!!!!!!!!)

    This is obviously either homework or an interview test.

    First, please read the article at the link in my signature below for how to post questions concerning data.

    Second, show us what...

    January 1, 2009 at 1:57 pm

    #920026

Viewing 15 posts - 46,171 through 46,185 (of 59,062 total)