Forum Replies Created

Viewing 15 posts - 31 through 45 (of 71 total)

  • RE: Count the number of spaces in a field

    Matt Miller (9/18/2008)


    It makes sure that the trailing spaces don't get truncated before you count them. (LEN will not count trailing spaces). by adding it to both - it...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Grouping records

    Adam Bean (9/18/2008)


    Did you mean? ([ROWNUMBER] + 1)/2 AS [Team]

    Yes! Fatfingered it again!



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Grouping records

    Adam Bean (9/18/2008)


    Terri (9/18/2008)


    Replace the CASE statement with:

    ([ROWNUMBER]/2 + 1 ) AS [Team]

    from BOL

    If an integer dividend is divided by an integer divisor, the result is an integer that has...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Grouping records

    Replace the CASE statement with:

    ([ROWNUMBER]/2 + 1 ) AS [Team]

    from BOL

    If an integer dividend is divided by an integer divisor, the result is an integer that has any fractional part...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: The Value of an MBA in IT

    Where I live (New Orleans) Executive MBA programs can cost twice as much as traditional MBA programs. At UNO the EMBA is $28,000 whereas the MBA is $3600...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: What is the advantage of telecommute?

    Steve,

    How do I start a new thread? I have only posted replies.



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: What is the advantage of telecommute?

    My office wants us to start telecommuting several days a week because they want to hire more workers but don't have enough office space. Most managers want their team...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Update values within trigger

    We include CreateDate, CreatedBy, UpdateDate and UpdateBy columns on our tables which are updated in our update triggers. We also log the record to an audit table...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Blackberry or smartphone for DBA

    In the wake of Hurricane Katrina my organization issued Blackberries to all of the IT staff deemed critical. the specific features they wanted was QWERTY keyboard and push-to-talk. ...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Saving SELECT Results to a CSV file

    Lester Policarpio (1/21/2008)


    correct me if im wrong if you are running this query:

    INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Test.xls', 'SELECT * FROM [Sheet1$]')

    SELECT * FROM Table1

    it means that you need to create...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Finding Current Month's First Day& Last Day

    Shaun McGuile (1/3/2008)


    0 to the power 0 is undefined - maybe in pure maths

    But my good ol calculator says it is 1. 😀

    --Shaun

    And my calculator says it is an error:exclamation:



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: Finding Current Month's First Day& Last Day

    Shaun McGuile (1/3/2008)


    Jeff: Gis a Job then mate!:)

    ROFL! I would shoot these people before they could damage the ecconomy! I might not be able to spell but maths like that...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: The College Experience

    paul.alan.taylor (10/23/2007)


    ...

    It's probably worth pointing out that I've been asked for my degree precisely twice in my career. If companies truly prize the acquisition of a degree, you'd think...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: The College Experience

    I have a BS, MS and PhD in Mathematics. I taught math and computer science at the university level before becoming a developer.

    Our shop requires a BS...



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

  • RE: T-SQL Code Bank

    Template Explorer is improved and easier to use in SSMS than in QA. We have switched to SSMS because of the integration with SourceSafe



    Terri

    To speak algebraically, Mr. M. is execrable, but Mr. C. is
    (x+1)-ecrable.
    Edgar Allan Poe
    [Discussing fellow writers Cornelius Mathews and William Ellery Channing.]

Viewing 15 posts - 31 through 45 (of 71 total)