Forum Replies Created

Viewing 15 posts - 15,301 through 15,315 (of 19,564 total)

  • RE: Today's Random Word!

    Butternut Squash soup.

  • RE: The Missing Certification

    Tom.Thomson (4/5/2010)


    dma-669038 (4/5/2010)


    ok, here goes...

    http://www.surveymonkey.com/s/HLR8V5S

    I have tried to include the topics we have discussed here. Please post some feedback on verbage etc before we send it out to all (or...

  • RE: how to get login's ip address?

    halifaxdal (4/5/2010)


    Big thanks to everyone, your kind helps make my life lots easier.

    I am going to send the result as email attachment in certain period, is it possible to make...

  • RE: convert non ansi join

    Lynn Pettis (4/5/2010)


    Jeff Moden (4/5/2010)


    ritu.thatola (4/5/2010)


    Jason,

    I don' know the SQL well.

    Hmmmm... then why did they select you to resolve this particular problem? You need to read the writing on...

  • RE: MCJ - The Missing Link

    Lynn Pettis (4/5/2010)


    I know the discussion right now is the review board, but I thought I'd interject one other aspect so it doesn't get lost. Should there be one...

  • RE: The Missing Certification

    Capitalization of SQL Server should be consistent throughout.

    I think I would also reword the questions that say "this certification" to " a middle tier certification."

    Some verbiage at the beginning to...

  • RE: The Missing Certification

    dma-669038 (4/5/2010)


    I will check and see the maximum time length, don't remember off hand what it is. I am thinking the quickest/easiest way to get a wide reach would be...

  • RE: Are the posted questions getting worse?

    WayneS (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    I would also enjoy neural computing. I could get a lot more done just by thinking it.

    Seems like a foolish risk. 😛

    That depends on what it is...

  • RE: convert non ansi join

    ritu.thatola (4/5/2010)


    main problem is with line IDETAIL.ChargeTypeID *= CHARGE.ChargeTypeID. in query where clause.

    I have to rewrite the query for SQL server 2005

    when I try to run this sql in SQL...

  • RE: The Missing Certification

    WayneS (4/5/2010)


    CirquedeSQLeil (4/5/2010)


    dma-669038 (4/5/2010)


    WayneS (4/5/2010)


    Jason mentioned maybe doing the survey online. I know that http://www.surveymonkey.com allows the building of free online surveys. I don't know if there are any other...

  • RE: how to get login's ip address?

    The hostname can also be returned back into this query. That information is returned by fn_trace_gettable.

    This would change the query as follows:

    SELECT I.NTUserName,I.loginname,I.SessionLoginName,I.databasename,Min(I.StartTime) as first_used

    ,Max(I.StartTime) as last_used,S.principal_id,S.sid,S.type_desc,S.name,EC.client_net_address,I.HostName

    FROM sys.traces T...

  • RE: The Missing Certification

    dma-669038 (4/5/2010)


    WayneS (4/5/2010)


    dma-669038 (4/5/2010)


    WayneS (4/5/2010)


    dma-669038 (4/5/2010)


    Wayne, how about a survey with chapters? I can pass this link around but not many people take time to read and respond thoughtfully but...

  • RE: convert non ansi join

    ritu.thatola (4/5/2010)


    Jason,

    I couldn't get your comment "Just make changes as appropriate to the commented section. "

    It would be great If you can rewrite the whole query. I don' know...

  • RE: convert non ansi join

    You're welcome.

  • RE: The Missing Certification

    WayneS (4/5/2010)


    dma-669038 (4/5/2010)


    Wayne, how about a survey with chapters? I can pass this link around but not many people take time to read and respond thoughtfully but a survey will...

Viewing 15 posts - 15,301 through 15,315 (of 19,564 total)