Forum Replies Created

Viewing 15 posts - 9,496 through 9,510 (of 14,953 total)

  • RE: Trigger Help

    The problem with the trigger is that it doesn't tell the database what to do if there ARE matches, it just tells it what to do if there are not.

    So,...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (5/15/2009)


    Back to the subject of questions...

    There must have been 8-10 questions on database corruption in the last week or two. Is it open season on corruptions all of a...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Why is not SSMSE allowing me to view and manage the databases objects

    mattiylen (5/15/2009)


    ... It is just question of the remote sql servers provided by the web hoster as part of their package. I am trying to manage through SSMSE.

    Matti

    There's a security...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Deleting own post ?

    GSquared (5/15/2009)


    There's a delete button above and to the right of the post. I know Steve had it disabled for a while, but I think he turned it back...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Deleting own post ?

    There's a delete button above and to the right of the post. I know Steve had it disabled for a while, but I think he turned it back on.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: The Best Days

    emr (5/15/2009)


    I couldn't believe my eyes when I saw your picture of the Timex/Sinclair 1000.

    One of those was my first computer. 2k of RAM! Woot!

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (5/15/2009)


    GSquared (5/15/2009)


    Actually, that looks more like an Asian elephant to me than an African one, judging by the ears. Possibly a female Asian elephant, judging by the lack...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (5/15/2009)


    Anyone like to guess where that photo was actually taken?

    Actually, that looks more like an Asian elephant to me than an African one, judging by the ears. ...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (5/15/2009)


    Grant Fritchey (5/15/2009)


    GSquared (5/15/2009)


    I'm here (most of the time).

    DUDE! I've visited that place before. How cool is that?

    And the continent visible is where I live, or more specifically, here

    Not...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: get drive info with sql

    If they're all SQL 2005 or 2008, CLR should be able to do that for you pretty efficiently.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Is it possible to have 0 latency?

    Zero latency is impossible in the physical universe. I'm assuming you mean latency so small you can't measure it, which still wouldn't actually be zero.

    It'll depend on the bandwidth...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: The Best Days

    I recently turned 40, so I'm pretty much in the middle of my working life (assuming I ever retire or anything like that). I'd definitely say that the only...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: get drive info with sql

    What I've done for that was create a table in my DBA database and list the drives and their total space in that table.

    I'm sure you can retrieve the data...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: first element in sublist

    stoler (5/15/2009)


    I thought about this, but problem is - I have more fields - and for every filds I must prepare subquery.

    In MSAcces there is group function FIRST and...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: nested row_number () function

    mmunson (5/14/2009)


    Thanks for the reply GSquared. I appreciate your opinion!

    I continue to learn new functions based on the requirements from the users, and well, they can be pretty demanding!...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 9,496 through 9,510 (of 14,953 total)