Forum Replies Created

Viewing 15 posts - 45,286 through 45,300 (of 59,063 total)

  • RE: how to reterive a single record from a table

    The real answer to this question should have been "Since data is not guaranteed to be in any order in a table or query result, and ORDER BY would be...

  • RE: how to reterive a single record from a table

    Max (1/29/2009)


    Lowell (1/29/2009)


    ... insulting people who are trying to help will not get you anything...

    here here

    ... but you still answered the question, didn't you? 😉 If it were...

  • RE: Permissions for Developers

    I 110% agree with that! And, there may be restrictions on some other tables, as well. For example, tell me why a developer would need to know anyone...

  • RE: Strange network error

    kevriley (2/2/2009)


    Todd,

    it is happening everytime with one id and not with another - but I've checked anti-virus and that isn't kicking in.

    Kev

    I can't remember exactly what the phrase in the...

  • RE: Count() with expressions, vs. numerics

    GSquared (2/2/2009)


    Look up Jeff Moden's article on Running Totals (on this site). Should be able to use that for what you need.

    The article is temporarily "offline" until I can...

  • RE: non sysadmin needs to modify a couple of sql agent jobs

    fizzleme (2/2/2009)


    We have a contractor who needs to modify a couple of SQl agent jobs on our server. He is using standard SQl security to connect.

    The SQL agent jobs...

  • RE: Logs for table updates

    SQL Server 2000 has none of those features.

  • RE: SQL Server 2005 upgrade changes column order of tables.

    rich.ramos (2/2/2009)


    The PeopleTools upgrade would not affect the field order of custom records. And the column order does not affect the way the PeopleSoft application interacts with the table....

  • RE: What Duties Would a Junior DBA Have?

    John Bates (2/2/2009)


    hi DBAs,

    I'm a Oracle and SQL Server 2005 DBA for my employer. I have been asked to list some of the skills that a *Junior* DBA position would...

  • RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

    GSquared (2/2/2009)


    Go for it. Might take more than a quarter, so don't be disappointed if you aren't up to Jeff Moden's or Gail's skill level by that time.

    :blush: ...

  • RE: SQL or Oracle

    Jeff Moden (2/2/2009)


    noeld (2/2/2009)


    Bruce W Cassidy (2/2/2009)


    [font="Verdana"]Relational Integrity is over-rated.

    OMG, did I really just say that? And I was just reading an article by Joe Celko too! Aaaargh!...

  • RE: SQL or Oracle

    noeld (2/2/2009)


    Bruce W Cassidy (2/2/2009)


    [font="Verdana"]Relational Integrity is over-rated.

    OMG, did I really just say that? And I was just reading an article by Joe Celko too! Aaaargh! 😛

    [/font]

    If...

  • RE: list of month names and week ranges between dates

    ghughes (2/2/2009)


    ok, I give up. I defer to everyone greater judgement in the matter. Make perfect sense. I have created table......thank you for the help.

    in...

  • RE: Keeping user database in memory

    noeld (2/2/2009)


    I am going to say this one last time, I promise. FIX THE APP!

    Heh... and I'll keep on saying it... FIX THE APP! 😛

  • RE: SQL or Oracle

    Bruce W Cassidy (2/2/2009)And I was just reading an article by Joe Celko too! Aaaargh! 😛

    [/font]

    A solution of Boric Acid, Silver Sulphate, and a little saline water will...

Viewing 15 posts - 45,286 through 45,300 (of 59,063 total)