Forum Replies Created

Viewing 15 posts - 44,716 through 44,730 (of 59,063 total)

  • RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

    And, sorry... the running total article I wrote is in the process of being rewritten.

    March 7, 2009 at 12:23 pm

    #955534

  • RE: Text Parsing TSQL code

    Bob Hovious (3/7/2009)

    I do it strictly in self-defense.

    BWAA-HAA!!! Me too! Let's get together and burn some ISO's sometime! 🙂

    March 7, 2009 at 11:41 am

    #955529

  • RE: Lets help the experts help themselves

    Steve Jones - Editor (3/7/2009)

    I used to think we should disclose discussions from there that aren't NDA. I still think there's value in having someone summarize and put the notes...

    March 7, 2009 at 11:34 am

    #955527

  • RE: Text Parsing TSQL code

    Bob Hovious (3/7/2009)

    By an odd coincidence, I just did that. It doesn't seem to make a significant difference.

    I just knew you would... that's one of the...

    March 7, 2009 at 10:41 am

    #955512

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/7/2009)

    Flash Gordon...Brings back old memories. I have never seen the series but I used to read the comics back then. Flash with the Doc. Mandrake with Luthor nd...

    March 7, 2009 at 10:35 am

    #955508

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/6/2009)

    Of course, there are areas where egos are strong, RBAR solutions for one (right Jeff!).

    Heh... no ego there... I let the code do the talking, as all should.

    Funny...

    March 7, 2009 at 10:34 am

    #955506

  • RE: Text Parsing TSQL code

    Bob Hovious (3/6/2009)

    a WHILE loop may actually perform better than a Tally table on function like these

    Jeff, do you know if the size of the tally table make any...

    March 7, 2009 at 9:06 am

    #955483

  • RE: PIVOT query

    Bob Hovious (3/6/2009)

    As a former attorney...

    Heh... now I know where you get that wonderful sense of humor... 😀

    March 7, 2009 at 7:35 am

    #955453

  • RE: Table design

    So, Narendra... are you all set?

    March 6, 2009 at 10:43 pm

    #955410

  • RE: Bulk insert won't skip the column header in the .csv file

    qzhu (2/5/2009)

    So how should I define my format file to define the column header corretcly? Is there a way to do that?

    There is a nasty little fault in BCP...

    March 6, 2009 at 10:41 pm

    #955409

  • RE: Repeatable Query

    Shuaib (3/6/2009)

    Thanks lot for you info.

    I also found the Numbers table details.

    If you want to know how a Numbers or Tally table actually works to get jobs like these done,...

    March 6, 2009 at 10:31 pm

    #955407

  • RE: nth WeekDayName of a month

    robert.mason (3/6/2009)

    Yes, I am using 23:59:59 as the end date for the reports. Any results that occurred after that time are for the following day, and should not be...

    March 6, 2009 at 10:23 pm

    #955405

  • RE: T-SQL

    metro17 (3/6/2009)

    SELECT MYDATE AS year, DATENAME(mm, MYDATE) AS month, SUM(number) AS totalnumber, SUM(amount)

    AS totalamount

    FROM MYTABLE

    GROUP BY MYDATE, DATENAME(mm, MYDATE)

    ORDER BY MYDATE, DATENAME(mm, MYDATE)

    year month totalnumber totalamount

    2004-08-26 10:39:00 August 2199...

    March 6, 2009 at 10:14 pm

    #955404

  • RE: sql

    It would likely be better if you wrote the spreadsheet to pull from a view or proc using the "external data" features.

    March 6, 2009 at 10:06 pm

    #955402

  • RE: PIVOT query

    Bob certainly did that right for the problem given... I'm just concerned about using names which are likely not unique... especially if it's for people's bank accounts. Heh... see...

    March 6, 2009 at 10:02 pm

    #955400

Viewing 15 posts - 44,716 through 44,730 (of 59,063 total)