Forum Replies Created

Viewing 15 posts - 45,721 through 45,735 (of 59,095 total)

  • RE: convert DateTime to BigInt

    munishprathap (1/20/2009)

    Thanks friends for all your support

    i can achieve this task by the following Query,please let me know your feedback

    IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'Note'

    AND...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 21, 2009 at 6:32 am

    #930275

  • RE: VM... Setting up new "box"

    Michael Earl (1/21/2009)

    I think you are seriously underestimating the number of people that are not thinking.

    Not sure what you mean by that, Michael...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 21, 2009 at 6:28 am

    #930270

  • RE: Why do people need to do this?

    RBarryYoung (1/20/2009)

    Jeff Moden (1/20/2009)

    Truer words never spoken... it's a pig and I was trying to name the pig. 🙂 I believe the label of "Procedural Mystery Code Requirement"...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:54 pm

    #930081

  • RE: create view problem

    rio_briones (1/20/2009)

    View definition cannot contain the following

    TOP

    Text, ntext or image columns

    DISTINCT

    MIN, MAX, COUNT, STDEV, VARIANCE, AVG

    SUM on a nullable expression

    A derived table

    Rowset function

    Another view

    UNION

    Subqueries, outer joins, self joins

    Full-text predicates like...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:51 pm

    #930080

  • RE: VM... Setting up new "box"

    Steve Jones - Editor (1/20/2009)

    VMs don't kill servers, server administrators kill servers.

    Don't blame VMS, it's an ignorance thing, same as any other new tool we get. Usually we give them...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:48 pm

    #930078

  • RE: backup failure

    Ok... something big just changed. It couldn't see the files in that directory before, but suddenly it can. Try running the backup again.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:45 pm

    #930076

  • RE: Select Where_Min()

    Heh... limits are good. Neither my driving a million rows through something nor the speediest pork chop that I can muster up will ever have the impact that a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:42 pm

    #930075

  • RE: Quick Question about Using Functions, creates 30k lines in profiler

    You bet... thank you for the feedback.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:35 pm

    #930073

  • RE: Share data (Parameters) between datasets in SSRS 2005

    htilburgs (1/20/2009)

    Yes, I'm using ReportServer and I'm using the parameters to make selections, so I need them.

    I'll try the method of Jeff, to fill my parameter.

    If it doesn't work, I'll...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:30 pm

    #930070

  • RE: convert DateTime to BigInt

    Chris Morris (1/20/2009)

    For now, he's still trying to figure out how to persuade someone to write his script without letting on that it's coursework.

    Heh.... then there's that. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:28 pm

    #930068

  • RE: Surface Possibilities

    mhaskins (1/19/2009)

    jpowers (1/19/2009)

    Even as recently as the early 1990's I knew of managers who insisted their assistants print out their emails.

    That is pretty gross.

    C'MON, RETIRE PEOPLE!

    Heh... I've gotta ask......

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:22 pm

    #930065

  • RE: Why do people need to do this?

    GSquared (1/20/2009)

    Jeff, I think the basic point of such questions is that data sequentiality matters in some cases, and it's something that SQL (and relational databases in general) are supposed...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:17 pm

    #930060

  • RE: Why do people need to do this?

    jcrawf02 (1/20/2009)

    but your customer sequence changes on the change of the hour?

    No, it changes when the SomeType column changes regardless of anything temporal.

    But, I agree with everyone else......

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:14 pm

    #930058

  • RE: Why do people need to do this?

    smunson (1/20/2009)

    I think there's an inherent problem with "slapping a label on it", which does little more than both condone AND support the very worst way to go about things....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:08 pm

    #930057

  • RE: Why do people need to do this?

    Jacob Luebbers (1/20/2009)

    Jeff Moden (1/20/2009)

    But it wouldn't reset to 1 for the same person, would it?

    Ah, I missed that key point 😀

    In that case no, I've never seen a business...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 20, 2009 at 9:04 pm

    #930056

Viewing 15 posts - 45,721 through 45,735 (of 59,095 total)