Forum Replies Created

Viewing 15 posts - 38,911 through 38,925 (of 59,072 total)

  • RE: data manipulation by row

    NEAL-464478 (4/12/2010)

    and how i can create sister table with the specific sort order which will show like 2nd table, i am new to sql any help will be much appreciated.

    Thanks

    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)

    April 12, 2010 at 12:47 pm

    #1150266

  • RE: How to build 7 day slots based on start and end dates?

    BIMind (4/12/2010)

    Jeff...this is pretty close...however this keeps the lowest row ID of any duplicates found and deletes the higher row IDs..i need it the other way around..

    i tried row ID...

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

    April 12, 2010 at 12:45 pm

    #1150265

  • RE: Index suggestion for VERY large table

    Stefan_G (4/12/2010)

    I actually found such a formula myself by modifying code found at

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66471

    Here is the code:

    DECLARE @IntDate INT

    SELECT @IntDate = 20090117

    dateadd(month,((@IntDate/10000-1900)*12)+((@IntDate/100)%100)-1,(@IntDate%100)-1)

    But, the performance of this expression is actually slightly...

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

    April 12, 2010 at 12:41 pm

    #1150257

  • RE: Help with keeping the leading zeros

    Based on what Lowell said, my recommendation is that you check the final table for the correct datatype. If you want, the CREATE TABLE statement for both tables... 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)

    April 12, 2010 at 12:33 pm

    #1150249

  • RE: Data verification question

    lmu92 (4/12/2010)

    SELECT cols

    FROM YourTable

    where YourColumn like '%[0-9]%'

    will return only rows with numbers.

    SELECT cols

    FROM YourTable

    where YourColumn like '%[^0-9]%'

    will return only rows at least...

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

    April 12, 2010 at 12:28 pm

    #1150248

  • RE: more than 250 indexes on a table

    hennie7863 (4/6/2010)

    For a customer i have to investigate a table wich has more than 250 indexes on it.

    hennie7863 (4/12/2010)

    There are about 80 indexes on that table.

    Heh... silly me. What'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)

    April 12, 2010 at 12:23 pm

    #1150246

  • RE: Understanding and Using APPLY (Part 1)

    Nicely done, Paul. The impeccably timed/highly appropriate graphics, the simple code examples, and the straight forward "talk" make this a model for future articles. It was a pleasure...

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

    April 12, 2010 at 12:11 pm

    #1150241

  • RE: Date Range

    jonathan.gregg (4/12/2010)

    Hello all,

    I'm really (I mean really) new to this so thanks for the info, I've learned a ton about Tally tables. However, I still don't understand how I get...

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

    April 12, 2010 at 12:04 pm

    #1150238

  • RE: Which is better and Why.?

    Bill Kline-270970 (4/12/2010)

    I work in a multi db platform environment. We use both SQL Server and Oracle. I'm just a newbie when it comes to Oracle administration, 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)

    April 12, 2010 at 11:51 am

    #1150224

  • RE: SQL Database development Questions

    This is precisely why I don't trust people with letters after their names. Tell your friend to do his/her own work and to earn the degree instead of faking...

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

    April 12, 2010 at 10:12 am

    #1150155

  • RE: more than 250 indexes on a table

    I think that the code that uses the table and the design of the databased needs serious review once it's moved. Perhaps the parental lineage of the vendor needs...

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

    April 12, 2010 at 7:33 am

    #1150034

  • RE: delete repeating rows

    Trouble Shooter (4/12/2010)

    Hi,

    2 is the variable ,u can set as your requirement.

    u can set it to 3 or 1 also as your requirement.

    I know... but for only one set of...

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

    April 12, 2010 at 7:14 am

    #1150021

  • RE: delete repeating rows

    Trouble Shooter (4/9/2010)

    Hi,

    use

    "set rowcount 2"

    it will show top 2 row of matching criteria out of 3,if there is 3 rows for that criteria and delete those row using delete...

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

    April 10, 2010 at 10:24 pm

    #1149672

  • RE: MCJ - The Missing Link

    On a serious note of my own, I sure hope this MCJ thing works out well because the posts I've seen lately from some people with letters after their name...

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

    April 10, 2010 at 10:17 pm

    #1149671

  • RE: data manipulation by row

    NEAL-464478 (4/10/2010)

    well requirment suppose to show like 2nd table, order by processdataID

    There's nothing to sort on in the first table to present the data in the order of the second...

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

    April 10, 2010 at 8:18 pm

    #1149664

Viewing 15 posts - 38,911 through 38,925 (of 59,072 total)