Forum Replies Created

Viewing 15 posts - 16 through 30 (of 71 total)

  • RE: The Reading Poll

    Aaron N. Cutshall (7/24/2009)


    Terri (7/24/2009)


    We can do just that now with audiobooks at our library. That is, I can go on line and "check out" an audiobook. The...



    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 Reading Poll

    Aaron N. Cutshall (7/24/2009)


    Several years ago I entered an essay contest at our local library about what I envisioned the library of the future to be. Basically, I envisioned...



    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 Reading Poll

    Well, i have not been counting but maybe I read 30-40 books a year, mostly fiction. I will read 4-5 books on vacation or travel, but it will...



    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: free text search

    ajaykshanker (7/22/2009)


    Terri, Thanks a lot for the code sample. I updated the query based on your sample. It is working great and I dont have to worry about SQL injection....



    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: free text search

    In our web application we can search for a User by a portion of the name or logonid as follows

    SELECT UserSID

    ,LoginID

    ...



    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: CHARINDEX in reverse

    andrewd.smith (7/1/2009)


    REVERSE is one of the less performant string functions in TSQL, so this alternative expression calls REVERSE only once.

    SELECT RIGHT(@nam, CHARINDEX(' ', REVERSE(@nam)) - 1)

    Bear in mind that this...



    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: charindex help

    Good explanation Jeff. A small point, your solution fails if there is more than 1 space between the 2 words. e.g 'Lincoln Lincoln' has length 16. So...



    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: Trigger interfering with application - how to avoid?

    We have triggers that update audit tables. In order to avoid the problem your are describing we do not use an identity column in the audit table. Instead...



    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: Dead Data

    When I give up a machine at work I either wipe the hard drive myself or give it to the tech support group to wipe the hard drive to remove...



    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: Do You Need an IT or CS Degree to be a Successful DBA?

    I had one Fortran course as an undergrad and one PL/I in grad school. I got a Ph.D. in Math and taught at university for 10 years, first math,...



    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: Open Source Pay

    I work for state government for the past 25 years and salaries are a matter of public record. I could go to the library and look them up but...



    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: Image is Everything

    mhaskins (1/9/2009)


    I worked many years for an automation company. I wore a skirt once, and was asked - what are you going to do if you have to crawl into...



    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: Function that finds Sundays

    andrewd.smith (11/24/2008)


    SELECT DATEADD(DAY, DATEDIFF(DAY, '19000101', GETDATE()) / 7 * 7, '19000101') AS followingMonday,

    DATEADD(DAY, DATEDIFF(DAY, '19000101',...



    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: Problem with decryption

    GilaMonster (11/6/2008)


    Sure they can. Encryption is not designed to protect the mdf file (secure your server), not is it mean to protect against the DBA (If you don't trust your...



    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 (10/7/2008)


    Hey Terri, any thoughts on how to add some better logic in by randomizing the deptname a little better to avoid same deptname groups (teams)?

    Thanks

    Well, it IS random...



    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 - 16 through 30 (of 71 total)