Forum Replies Created

Viewing 15 posts - 436 through 450 (of 667 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (10/5/2009)

    I miss anything? Just cranky old guys and gals complaining?

    The post is a little self promotion, but I'm more willing to tolerate authors promoting themselves than...

    --------------------------------------------------------------------------
    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]

    October 5, 2009 at 2:52 pm

    #1061988

  • RE: Are the posted questions getting worse?

    No, Gus, wasn't taking you serious on point 1, not after what I read about it. Re point 2, I'm reading up on the link you sent. Looks pretty scary...

    --------------------------------------------------------------------------
    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]

    October 5, 2009 at 2:52 pm

    #1061987

  • RE: Are the posted questions getting worse?

    GSquared (10/5/2009)

    jcrawf02 (10/5/2009)

    My project this weekend has been Artillery Fungus[/url], unfortunately. I'm trying the mouthwash/toothpaste solution on that link later tonight or tomorrow, depends when it rains. Spent time this...

    --------------------------------------------------------------------------
    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]

    October 5, 2009 at 2:03 pm

    #1061970

  • RE: Are the posted questions getting worse?

    Was just asking because they guy who "advertised" his free tool, just to get some feedback a few weeks ago (forgot his name and exactly what it was) got bitterly...

    --------------------------------------------------------------------------
    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]

    October 2, 2009 at 4:35 pm

    #1061254

  • RE: Are the posted questions getting worse?

    Is this fair use of the forums by the way?

    --------------------------------------------------------------------------
    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]

    October 2, 2009 at 4:14 pm

    #1061245

  • RE: Down Grading SQL Server 2008

    Oops, didn't read original post properly. Rest of post removed. Apologies...

    --------------------------------------------------------------------------
    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]

    October 2, 2009 at 4:04 pm

    #1061243

  • RE: Are the posted questions getting worse?

    Hey, I liked Seth's reply to this one. You, Lynn, were way too saintly again.

    --------------------------------------------------------------------------
    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]

    October 2, 2009 at 3:46 pm

    #1061237

  • RE: Does a table need to have a primary key in order to implement a trigger?

    Hi Steve,

    I'd say first prize would be if you could get the extraction to populate the ClassStart/EndDate columns correctly in all cases. May be easier said than done, I know,...

    --------------------------------------------------------------------------
    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]

    October 1, 2009 at 3:38 pm

    #1060721

  • RE: Does a table need to have a primary key in order to implement a trigger?

    Hi Steve,

    It is a bit late (in this part of the world) to wrap my head around you problem, but what first comes to mind is that your table is...

    --------------------------------------------------------------------------
    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]

    September 29, 2009 at 4:26 pm

    #1059760

  • RE: Audit Log Question - May be silly

    I agree with you Steve in terms of the amount of auditing done, but I guess it also depends on how wide your tables are. Duplicating the most recent records...

    --------------------------------------------------------------------------
    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]

    September 25, 2009 at 5:07 pm

    #1058698

  • RE: Are the posted questions getting worse?

    Now how do you like the OP's reply to Lutz's suggestion on this one http://www.sqlservercentral.com/Forums/Topic793490-1291-1.aspx

    --------------------------------------------------------------------------
    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]

    September 25, 2009 at 4:31 pm

    #1058693

  • RE: Does a table need to have a primary key in order to implement a trigger?

    Steve-437536 (9/24/2009)

    Thank you both, that's what I figured. It gives me another reason to ask that we put a primary key on the table, as I didn't find any...

    --------------------------------------------------------------------------
    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]

    September 25, 2009 at 4:25 pm

    #1058691

  • RE: Audit Log Question - May be silly

    UB-242988 (9/25/2009)

    After I wrote all my thoughts into this question/post and re-read it, approach 2 seems like a better one. The small over head is negligible. Is one more row...

    --------------------------------------------------------------------------
    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]

    September 25, 2009 at 4:08 pm

    #1058683

  • RE: what is the best way to find an itemID from a given itemvalueIDs

    Hi Michael,

    Don't want to give away the answer, because the whole point of these forums is to teach people how to teach themselves. Just a hint, a simple LEFT JOIN...

    --------------------------------------------------------------------------
    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]

    September 25, 2009 at 3:45 pm

    #1058679

  • RE: Assigning results of stored procedure to a variable

    Hi Stuart,

    Try this:

    CREATE PROCEDURE usp_GetEmailsOnCall

    @EmailsOnCall varchar(max) OUTPUT

    AS

    BEGIN

    SET @EmailsOnCall = 'fred.smith@domain.com;joe.bloggs@domain.com' -- Replace this with actual code to get email adresses from database table

    END

    GO

    DECLARE @EmailsOnCall...

    --------------------------------------------------------------------------
    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]

    September 22, 2009 at 6:20 am

    #1056701

Viewing 15 posts - 436 through 450 (of 667 total)