Forum Replies Created

Viewing 15 posts - 44,296 through 44,310 (of 59,063 total)

  • RE: Timestamp to Datetime

    javid.alimohideen (4/6/2009)


    Actually I am working on some stored procedures that was written by another developer. In my case, the table has a timestamp column, which gets cast to a datetime...

  • RE: Manners

    Jeff Moden (4/6/2009)


    Lynn Pettis (4/5/2009)


    Well said, both the editorial and the pod cast. From that, I really think that my blog posts are particularly relevant. For those who...

  • RE: Manners

    RBarryYoung (4/6/2009)


    majorbloodnock (4/6/2009)


    Well, I expect you'll get a lot more posts to this thread agreeing with your article, albeit (frustratingly) all from people who wouldn't commit that cardinal sin in...

  • RE: Manners

    Lynn Pettis (4/5/2009)


    Well said, both the editorial and the pod cast. From that, I really think that my blog posts are particularly relevant. For those who haven't read...

  • RE: Convert multiple rows into columns

    Actually, I got a blank page on Flo's link... a working link exists in my signature line below. Do yourself a favor and read the article attached to it.

  • RE: Convert multiple rows into columns

    vishal.chawla (4/6/2009)


    Hi All,

    Attached is sample data in excel file. I want to display the colored data in column K,L & M as a single row. Please help me.

    Thanks,

    Vishal

    I,...

  • RE: Idenity column question /issue

    jgrubb (4/6/2009)


    By definition, identity has gaps, check BOL. If you need sequential id's without gaps, identity is not the way.

    Ummm.... you're gonna have to show the...

  • RE: Compare Two Tables

    AFIFM (4/6/2009)


    I need help with the SQL query to comare two tables in two seperate databases on the same server. The tables have FirstName, LatName and Email as common fields.

    I...

  • RE: varchar to date derived tables

    Op accidently posted in wrong forum. This thread answered in the following post...

    http://www.sqlservercentral.com/Forums/Topic691647-169-1.aspx

  • RE: varchar to date distinct select

    This will likely be slow one way or the other, so you may want to turn it into a function. This seems to catch most

    of the aberrations you've...

  • RE: How to return a "start of group" column?

    Soooo.... does that mean you're happy now?

  • RE: The T-SQL Paradigm

    Steve Jones - Editor (4/6/2009)


    Jeff Moden (4/6/2009)


    Heh... no, I get it. But there are still rules of thumb that absolutely must be followed.

    There are, but unfortunately we...

  • RE: The T-SQL Paradigm

    Heh... brackets... they sure did take a shortcut there. It would be nice if the automatic code generators didn't put those in unless actually required.

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/6/2009)


    Jeff,

    We have two developments ongoing. One was our regular developer/week a month that I believe tried to fix some code items. Those are in test now,...

  • RE: Challenging SQL interview questions

    On the Halloween thingy... that's what I call an "oolie" and it shouldn't make or break an interview. If someone knows it, then it may be a bonus unless...

Viewing 15 posts - 44,296 through 44,310 (of 59,063 total)