Forum Replies Created

Viewing 15 posts - 61 through 75 (of 667 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (7/15/2013)

    ... I didn't even have to show the card to join the Navy....

    I hope Lynn doesn't see this before he gets to Afghanistan...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Grouping by day on a rollover count

    No problem, Brett. Glad you managed to sort it out.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: SQL in the City 2013

    I expect that we'll bring more events to locations outside the US...

    How about "outside the US and Europe"? Like Africa 😎

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Revenant (6/24/2013)


    Better database than kids.

    :w00t:

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Append characters in a sentence after certain length

    I like the Penguin one. 🙂

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Append characters in a sentence after certain length

    Now why does this InlineTally function look so familiar? 😉

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Partitioning in SQL Server 2008

    Evil Kraig F (6/20/2013) ... SET TRANSACTION LEVEL READ UNCOMMITTED

    The cure for all :hehe:

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Append characters in a sentence after certain length

    I'd strongly suggest you do this on the client side. SQL isn't geared towards manipulating strings.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Append characters in a sentence after certain length

    So are you talking about updating the table once-off, or whenever a client app retrieves the data? Plus what if the previous "word" is less than 32 characters long and...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: smart first name matching in TSQL

    So I got the idea right. Anyhow, that's beside the OP's question 🙂

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: t-sql joins

    Just OUTER JOIN tableA, tableB and tableC on id_number.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: backup

    balasaukri (6/19/2013)


    If db recovery model is simple and I take full back up every day. And if my recovery mdel is full and I take only fulll backup every day.

    (I...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Newbie needs help

    No problem, that's what we are here for.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: smart first name matching in TSQL

    Wolf, don't say you are Austrian, or are you? Passport-wise I'm too. Spent my teens in Vienna and a few more years after that.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Partitioning in SQL Server 2008

    I don't even think there is a linked server situation here, Gail. Not if you look at all those CREATE VIEW statements, they all select from the same server, which...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

Viewing 15 posts - 61 through 75 (of 667 total)