Forum Replies Created

Viewing 15 posts - 106 through 120 (of 536 total)

  • RE: Using 'XYZ' where ever null data is existing in the column

    Ninja's_RGR'us (9/20/2011)


    gmrose (9/20/2011)


    UPDATE MyTable set MyField = 'MyField was NULL' where MyField IS NULL

    UPDATE MyTable set MyField = 'MyField was not NULL' where MyField IS NOT NULL

    Doesn't that just updates...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: total of sum

    You can use:

    GROUP by ID WITH ROLLUP

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Mathematical Theory (controversy!)

    jcrawf02 (9/15/2011)


    mtillman-921105 (9/9/2011)


    Think of how it would change our world if scientists proved that turning on a certain gene(s) made us, say, grow a tail. :w00t:

    Oh, and they found...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Are the posted questions getting worse?

    Tom.Thomson (9/14/2011)


    mtillman-921105 (9/14/2011)


    Grant Fritchey (9/14/2011)


    You combined Jeff & FLOAT. You're going to get the lecture now about the evils of the DECIMAL data type. I'm sorry, but you've brought this...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/14/2011)


    You combined Jeff & FLOAT. You're going to get the lecture now about the evils of the DECIMAL data type. I'm sorry, but you've brought this on yourself.

    alright, little...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/14/2011)


    You combined Jeff & FLOAT. You're going to get the lecture now about the evils of the DECIMAL data type. I'm sorry, but you've brought this on yourself.

    Oh,...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/14/2011)


    Changing the topic for a moment, I'd like to beg some ideas from the group, again.

    I'm tasked with writing another article. This one is all about the scary,...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Store all in one database instead of one prodcution database and one historic database

    I think you're getting excellent advice here. I work with a data warehouse daily and it would not work at all to have it on the production server. ...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: What do you do when it's slow?

    Go read Gail and Gus' blogs. Well, except Gail's taking a break from blogging for a while, so I guess we'll have to wait on new blog posts. ...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Crystal report mystery???

    Well, at least you found the solution. 'Hope you can upgrade Crystal soon. 😉

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Mathematical Theory (controversy!)

    Think of how it would change our world if scientists proved that turning on a certain gene(s) made us, say, grow a tail. :w00t:

    Oh, and they found the gene...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Mathematical Theory (controversy!)

    GSquared (9/9/2011)


    mtillman-921105 (9/9/2011)


    I watched a NOVA program once that showed a bird that could grow teeth if a certain gene (or genes) was turned on (or off). I thought...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Crystal report mystery???

    I would first look at how the tables are joined (if they are). If so, make sure that a key hasn't been broken somehow. Whatever Crystal is trying...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Mathematical Theory (controversy!)

    I watched a NOVA program once that showed a bird that could grow teeth if a certain gene (or genes) was turned on (or off). I thought that was...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • RE: Mathematical Theory (controversy!)

    rmechaber (9/8/2011)[hrGus, when I learned a bit about quantum mechanics in college, I began to wonder where, exactly, "I" stopped? Where are the physical boundaries of my physical existence:...

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

Viewing 15 posts - 106 through 120 (of 536 total)