Forum Replies Created

Viewing 15 posts - 31,681 through 31,695 (of 59,099 total)

  • RE: Convert rows to columns

    adrian.buzgau (12/14/2011)

    I got it now, I have not paid attention to the logic enough.

    It's great precisely what I needed.:w00t:

    Do you understand how it actually works?

    --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 14, 2011 at 7:27 pm

    #1421701

  • RE: Using SP_

    BWAA-HAAA!!! Judging by the fact that more people got the wrong answer than the correct one, I'd say you just taught a whole bunch of people a lesson, Ron....

    --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 14, 2011 at 6:47 pm

    #1421697

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (12/14/2011)

    Roy Ernest (12/14/2011)

    You all are NUTS. I think I am the only sane person in the THREAD. 😀

    I loved the comment about our resident Santa. 🙂 Brilliant...

    --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 14, 2011 at 4:01 pm

    #1421679

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/14/2011)

    Steve Jones - SSC Editor (12/13/2011)

    SQLRNNR (12/13/2011)

    About due for a Pantsectomy :-D:-D:-D:-D

    40F in Denver, no need for pants today.:-P

    Just as long as you wear the Cowboy hat

    Gah!!! My...

    --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 14, 2011 at 3:56 pm

    #1421677

  • RE: HOW TO TRANSPOSE COLUMNS TO ROWS USING T-SQL

    Not exactly the answer I was looking for. 😉

    --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 14, 2011 at 3:43 pm

    #1421671

  • RE: HOW TO TRANSPOSE COLUMNS TO ROWS USING T-SQL

    dalexmailbox (12/14/2011)

    Dynamic solution is better than based on cursor one. Tat is the reason of my solution.

    Agreed that just about any solution is better than a cursor and that, yes,...

    --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 14, 2011 at 12:13 pm

    #1421533

  • RE: Modulo operator problem

    Cadavre (12/14/2011)

    Jeff Moden (12/13/2011)

    I've never come across a View used in this way, ...

    Just to be clear, it's not really a "view". It's actually an Inline Table Value Function...

    --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 14, 2011 at 6:23 am

    #1421229

  • RE: Using Recursion and Date Tables to Simplify Date Logic

    GPO (12/14/2011)

    Under what circumstances would you use one of these on-the-fly solutions as opposed to a permanent calendar table? I'm probably missing something here - it's not unusual - 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)

    December 14, 2011 at 6:08 am

    #1421216

  • RE: create ipaddress table

    sturner (12/14/2011)

    For some tables I store it as a bigint (convert to bigint via CLR function in insert). Very efficient and works well for huge tables or ones 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)

    December 14, 2011 at 5:59 am

    #1421210

  • RE: Last day of Month

    praneshram (12/14/2011)

    ----Last Day of Last Month

    SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))) 'Last Day of Last Month'

    Gosh no. Always find the first day of the next month and use "less than" instead of "between"...

    --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 14, 2011 at 5:56 am

    #1421208

  • RE: HOW TO TRANSPOSE COLUMNS TO ROWS USING T-SQL

    dalexmailbox (4/8/2011)

    To easily transpose columns into rows with its names you should use XML. In my blog I was described this solution with example:

    It doesn't appear to be 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)

    December 14, 2011 at 5:49 am

    #1421205

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (12/13/2011)

    ....and anyway, isn't it somewhat improper to go around feeling posts? :w00t: Especially posts about pants? :laugh:

    BWAA-HAA! Only if the posts are in the pants....

    --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 13, 2011 at 10:53 pm

    #1421000

  • RE: Modulo operator problem

    Okidoki... First, please forgive my OCD nature when it comes to formatting. I just couldn't look at multiple INSERT/VALUES or all lower case object names anymore. These old eyes...

    --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 13, 2011 at 10:29 pm

    #1420999

  • RE: Modulo operator problem

    drew.allen (12/6/2011)

    * You're using 9999 to represent unknown/missing data. The NULL value was specifically designed to represent unknown/missing data. By using a non-NULL value to represent NULL,...

    --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 13, 2011 at 9:33 pm

    #1420988

  • RE: Modulo operator problem

    Cadavre (12/12/2011)

    Jim-720070 (12/12/2011)

    Thanks for looking into a bit more deeply Cadavre.. I've been working with SQL Server for 5 years now and have literally never had anyone else look at...

    --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 13, 2011 at 7:32 pm

    #1420965

Viewing 15 posts - 31,681 through 31,695 (of 59,099 total)