Forum Replies Created

Viewing 15 posts - 121 through 135 (of 327 total)

  • RE: How to use data from a table in a view that has no primary key

    In order to you to just use the first row, you'll have to give some ordering criteria to let SQL know what constitutes the order of the rows of which...

    June 28, 2012 at 8:06 am

    #1506637

  • RE: How to use data from a table in a view that has no primary key

    adiehl (6/27/2012)

    Hi all,

    I have a requirement to add a new field to a view we have currently. This new field is called Market. This field is based off...

    June 27, 2012 at 1:38 pm

    #1506346

  • RE: Stored procedure error

    ChrisM@Work (6/27/2012)

    @CLASSIFICACAO is declared as an int, you have to cast it as a string type to concatenate it into the string:

    SET @STRSQL = 'INSERT INTO ' + @DB +...

    June 27, 2012 at 1:35 pm

    #1506345

  • RE: The Cult of Mediocrity

    jbnv (6/26/2012)

    patrickmcginnis59 (6/26/2012)I'm pointing out that you have not addressed the free market response to a visibly bad actor. There very well could be an answer here, thats why I'm...

    June 26, 2012 at 12:00 pm

    #1505764

  • RE: The Cult of Mediocrity

    sturner (6/26/2012)

    patrickmcginnis59 (6/26/2012)

    Or would all companies simply agree not to pollute?

    Or do you simply have no opinion on this?

    In your mind all companies *must* pollute something in order to make...

    June 26, 2012 at 11:38 am

    #1505754

  • RE: The Cult of Mediocrity

    sturner (6/26/2012)

    "I can agree with you on that. For instance, having a clean environment is typically not a business goal, and thus you get the expected results. Theres just no...

    June 26, 2012 at 10:36 am

    #1505714

  • RE: The Cult of Mediocrity

    Lynn Pettis (6/26/2012)

    sturner (6/26/2012)

    patrickmcginnis59 (6/26/2012)

    sturner (6/26/2012)

    One other thing about the three entrepreneurs you cited: they all achieved their success without a dime of government stimulus (i.e taxpayers money).

    Counterpoint: the Apollo...

    June 26, 2012 at 10:28 am

    #1505707

  • RE: The Cult of Mediocrity

    sturner (6/26/2012)

    patrickmcginnis59 (6/26/2012)

    sturner (6/26/2012)

    One other thing about the three entrepreneurs you cited: they all achieved their success without a dime of government stimulus (i.e taxpayers money).

    Counterpoint: the Apollo space program.

    Its...

    June 26, 2012 at 10:11 am

    #1505684

  • RE: The Cult of Mediocrity

    sturner (6/26/2012)

    One other thing about the three entrepreneurs you cited: they all achieved their success without a dime of government stimulus (i.e taxpayers money).

    Counterpoint: the Apollo space program.

    June 26, 2012 at 9:42 am

    #1505666

  • RE: How to Join Two tables with row numbers.

    sambireddy chirra (6/26/2012)

    Hi Vijayarani,

    In my Requirement EmpId in Employee table have 101, same refearence table Employee_Details have 1011 (1012,1013 ) like . how it possible for the below query.

    select *...

    June 26, 2012 at 7:02 am

    #1505540

  • RE: Index defaults 1

    Robert-378556 (6/22/2012)

    Any answer can be valid as anything unspecified can follow - any alter table, drop table, even drop database.

    It's like a question "Guess what I'm thinking about".

    "If I execute...

    June 22, 2012 at 8:34 am

    #1504520

  • RE: Never, Ever Use Clustered Indexes

    Dean Cochrane (6/21/2012)

    patrickmcginnis59 (6/21/2012)

    I freely admit that I'd like to be biased toward portability in the general case, but that it would take additional effort to materialize that bias in...

    June 21, 2012 at 8:22 am

    #1503958

  • RE: Never, Ever Use Clustered Indexes

    cfradenburg (6/21/2012)

    Grant Fritchey (6/21/2012)

    There is a very real, and evidently apparent in more than just the SQL sphere, understanding that you can design for performance on a platform, or you...

    June 21, 2012 at 7:31 am

    #1503919

  • RE: Never, Ever Use Clustered Indexes

    Grant Fritchey (6/21/2012)

    Just received an interesting comment on this over on my blog that included this:

    “By now, you might be able to see where I’m going in this section. I...

    June 21, 2012 at 6:27 am

    #1503892

  • RE: Never, Ever Use Clustered Indexes

    Jeff Moden (6/19/2012)

    patrickmcginnis59 (6/4/2012)

    GSquared (6/4/2012)

    I've maintained for years that databases are platform-portable in the same way that continental plates are "portable". They do move, and it's usually listed as...

    June 19, 2012 at 8:45 pm

    #1503202

Viewing 15 posts - 121 through 135 (of 327 total)