Forum Replies Created

Viewing 15 posts - 38,566 through 38,580 (of 59,098 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/6/2010)

    Never know, I may actually find myself on the dark side in the future (goverment contracts tend to use Oracle a lot, ...

    Heh... I've done both and I'm...

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

    May 8, 2010 at 6:16 pm

    #1164629

  • RE: Are the posted questions getting worse?

    Heh... poor guy... he's fighting not one but two language barriers (Oracle and French). Although even Oracle works better when using set based code (when set based code is...

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

    May 8, 2010 at 6:10 pm

    #1164626

  • RE: need to find out % value

    san-1015392 (5/7/2010)

    select Distinct ClientIdentifier, sourcesystem, methodtype, voicedatatype

    ,Count(CASE WHEN CONVERT(DATETIME,CONVERT(VARCHAR(10), dtmdatecreated ,101))

    ...

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

    May 8, 2010 at 5:57 pm

    #1164625

  • RE: pivot table

    ColdCoffee (5/5/2010)

    Dear Lavanya, you have not even provided one of the requisites that Gianluca has asked for! Please provide us those and then we will provide you with awesome code!...

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

    May 8, 2010 at 5:32 pm

    #1164624

  • RE: pivot table

    lavanya.pothu (5/5/2010)

    i have table

    roomNo,blockFrom,blockTo

    blockFrom and blockTo are date fields.....

    i insert data like

    501 1-Mar-2010 5-Mar-2010

    502 1-Mar-2010 5-Mar-2010

    503 1-Mar-2010 5-Mar-2010

    504 1-Mar-2010...

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

    May 8, 2010 at 5:26 pm

    #1164623

  • RE: Node.value and insert the result to an existing table

    sohairzaki (5/8/2010)

    Can you explain more how to shredded down. Performance is very important because the xml files are of size 1g

    Thanks

    heh... as a side bar, if performance were really important,...

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

    May 8, 2010 at 5:19 pm

    #1164622

  • RE: how do I find the IP of the 2005 sql server instance?

    marwenG (5/8/2010)

    Hi ps,

    My string connection is now like that:

    string sConnection = @"Data Source=Admin-PC;Initial Catalog=GMAO;User ID=sa;Password=sa;";

    When running my program,still the same error:

    Specified sql server not found:Admin-PC

    what is the problem?

    Thanks

    The problem is...

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

    May 8, 2010 at 5:17 pm

    #1164621

  • RE: CTE performance

    kazim.raza (5/8/2010)

    Select * From #Hie

    this select is the one that has problems. exact count of records after inserting in #Hie is 161343. My data export to Excel failed after exporting...

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

    May 8, 2010 at 5:11 pm

    #1164620

  • RE: Is selecting top(sum(int)) possible?

    shannon-567218 (5/7/2010)

    Hello -- thanks for taking the time to read this. Last I tried to broach this issue in 2000, it wasn't possible. But now I'm again wondering...

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

    May 8, 2010 at 4:46 pm

    #1164619

  • RE: running manipulation of columns in sql query

    Sash Mav (5/8/2010)

    never mind..fellas

    here u go

    select

    t.num ,

    t.strike ,

    rt.col2

    from #tmp t

    cross apply (select

    case when (t.strike...

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

    May 8, 2010 at 1:07 pm

    #1164602

  • RE: find missing date and values

    Simple (now that we have some readily consumable data ;-)). Code with your data setup follows. Read the following article and pay attention to the rules because if...

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

    May 8, 2010 at 1:05 pm

    #1164601

  • RE: replace a string

    jayanp (5/7/2010)

    Yes.Need to add in to a stored procedure.

    Since I did not get any reply, I found out the solution myself.

    Thanks anyway.

    I understand the disappointment of "no reply", but...

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

    May 8, 2010 at 11:37 am

    #1164590

  • RE: Need Ideas for a large lookup table solution

    Cory Blythe (5/7/2010)

    Some of the more common uses would be find all Values of Zip2 within 10 miles of Zip1 etc.

    One of the very useful performance tweeks here is 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)

    May 8, 2010 at 11:32 am

    #1164588

  • RE: query to get a part of strin

    Cory E. (5/7/2010)

    This is why we are looking for requirements.

    Heh.... I understand the lesson in progress but I thought the requirements were actually pretty clear on this one. From...

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

    May 8, 2010 at 11:19 am

    #1164587

  • RE: Calculate values for TallyDuration

    Heh... I just wanted to know if it worked for you. :blush: Thanks for the compliment, Clive.

    Just a followup warning... don't take any shortcuts or deviate from the...

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

    May 8, 2010 at 11:03 am

    #1164585

Viewing 15 posts - 38,566 through 38,580 (of 59,098 total)