Forum Replies Created

Viewing 15 posts - 46,381 through 46,395 (of 59,095 total)

  • RE: OLE Automation help

    The server you are working on, whether local or remote, must be logged in as a user that can "see" the spreadsheet using a UNC instead of a mapped drive.

    --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)

    December 26, 2008 at 1:42 pm

    #917924

  • RE: Looking Forward

    Steve Jones - Editor (12/26/2008)

    Congrats!

    Hey, pick up running as a new vice, that's what I did 🙂

    http://amileaday.blogspot.com/

    Just bought a nice new Calypso Cruiser (bicycle)... 7 speeds... nice super heavy duty...

    --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)

    December 26, 2008 at 1:34 pm

    #917922

  • RE: Split Names With out VB Script

    ps (12/26/2008)

    Jeff, I must say the way you play around with T-SQL is really amazing. Atleast I couldnt think of using PARSENAME in this example:w00t:

    :blush: That's awfully nice...

    --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)

    December 26, 2008 at 12:58 pm

    #917914

  • RE: Smart Teaching

    Heh... you beat me to it, Barry. Despite some awesome technology in some classrooms and the awesome learned abilities by the students in those classrooms, most still can't count...

    --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)

    December 26, 2008 at 12:36 pm

    #917905

  • RE: What do you look for in a Database Audit?

    rajib (12/26/2008)

    I love the word "depends". 😀

    How about we assume that I'm looking for everything (3 things mentioned above as well as other items not listed there)? I am interested...

    --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)

    December 26, 2008 at 11:39 am

    #917888

  • RE: Looking Forward

    Heh... Actually, I haven't had a cigarette in over a week. Still want one real bad, but trying not to give in. Also trying not to bury folks...

    --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)

    December 26, 2008 at 11:34 am

    #917886

  • RE: Split Names With out VB Script

    Using the test data nicely provided by Pradeep, with an added row...

    create table #patname

    (

    FullName varchar(100),

    FirstName varchar(100),

    MiddleName varchar(100),

    LastName varchar(100)

    )

    insert into #patname(FullName)

    select 'John,David Robert'

    UNION ALL

    select 'sustaita,corie m'

    UNION ALL

    select 'pena,geneva jesus'

    UNION ALL

    SELECT...

    --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)

    December 26, 2008 at 11:29 am

    #917885

  • RE: Looking Forward

    I have two resolutions....

    1. Stop swearing so much at people who want to do stupid things to databases because... most of them are managers that have some say so...

    --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)

    December 26, 2008 at 10:49 am

    #917869

  • RE: What do you look for in a Database Audit?

    rajib (12/23/2008)

    I am curious to find out what your team does when it comes to database audit?

    Here are a list of questions from me:

    - Do you check schema only to...

    --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)

    December 26, 2008 at 10:38 am

    #917865

  • RE: How to calculate the Bi-weekly in SQL

    Dugi (12/26/2008)

    Dugi (12/26/2008)

    Jeff you are amazing ...I'm going to delete my answers ah :hehe:

    but can you explain to me this t.n*14 where did you find it ???

    SELECT DATEADD(dd,t.n*14,'20090102')...

    --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)

    December 26, 2008 at 10:33 am

    #917864

  • RE: How to calculate the Bi-weekly in SQL

    doss.tychicus (12/26/2008)

    Thanks Jeff . that's really cool

    You bet, Doss... thanks 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)

    December 26, 2008 at 10:31 am

    #917863

  • RE: How to transpose the ROWs

    Praveen,

    If you want to learn how to make cross tabs, then what Madhivanan suggested is a good idea. Also, I wrote a kind-of tutorial on how to make 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)

    December 26, 2008 at 10:29 am

    #917862

  • RE: Is it possible to call stored procedures inside a function

    vaibhav.a (12/26/2008)

    I want to call a stored procedure inside a function... and then create a view using that function . How can i use stored procedure inside a function....

    Thank You...

    --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)

    December 26, 2008 at 10:25 am

    #917860

  • RE: Still shows scan

    samsql (12/25/2008)

    hi i hav an update query which show table scan m confused how to i put indexes so that it does not scan the table

    Update temp1 Set Date =...

    --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)

    December 26, 2008 at 10:22 am

    #917857

  • RE: How to calculate the Bi-weekly in SQL

    doss.tychicus (12/26/2008)

    is there any way i can calculate bi weekly in sql

    from ex:

    from 1/1/2009 to 12/31/2009

    I need to know all the fridays biweekly

    ex 1/2/2009, 1/16/2009,1/30/2009

    Thanks

    It's...

    --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)

    December 26, 2008 at 10:01 am

    #917845

Viewing 15 posts - 46,381 through 46,395 (of 59,095 total)