Forum Replies Created

Viewing 15 posts - 33,931 through 33,945 (of 59,102 total)

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    peter-757102 (5/15/2011)


    ...I ran into a disturbing issue that caused me to give up in frustration.

    Time for some beer popsicles and a long chat with the dust bunnies. 😛

    In short, I...

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

  • RE: How to add new partitions automatically to a table when new quarter started.

    theunique1011 (5/4/2011)


    Thank you for reply. i couldn't find in Books online. can you please write code for me to delete quarter data and add new partition automatically.

    No... please see 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)

  • RE: How to add new partitions automatically to a table when new quarter started.

    theunique1011 (5/3/2011)


    Can you explain me how to create a job to add and delete partitions automatically?

    Yes... please see the link that SQL Kiwi provided above.

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

  • RE: Need Round Robin- For loop in T-SQL

    skcadavre (5/6/2011)


    What you're talking about isn't a job for SQL. What are you actually trying to achieve?

    If you insist, you could do it in a few ways. One such would...

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

  • RE: single column data spit into multiple columns to another table

    Heh... took it one step further to see what was going on. Apparently, there's an extra field of information and a few more

    rules that you eithe didn't know about...

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

  • RE: single column data spit into multiple columns to another table

    I "normalized" the data you posted to find the "13 rows" you spoke of. As you can see, something is amiss...

    d1012112010B20004180822A10006320845A100T5250847A10020280851A100F1480854A100T82859

    d1012112010A10004920859A10020290900A10010640900A100T1980900A100F0510900A10006520900A

    d1012112010A100T7650900C300T7650900A100F1500900A10013230901A100T5690901A10005900901A

    d1012112010A10006450901A10018610902A10003430902A10004610902A10001270902A10002610902A

    d1012112010A10005420902A10005280903A10006360903A10003930903A10006240903A10006470903A

    d1012112010A10006500903A10015610903A10006430903A10005810903A10006110903A100T0070903A

    d1012112010A10005610904A10006220904A10005970904A100T5310904A10020450904A10006030905A

    d1012112010A100T8510910A100T3420910A100T2690910A100T9420911A10020400911

    d2012112010C30006140811C30006480824C30012710824C30018190832A100T2420844C300F1480854C

    d2012112010C300T1980900C300F0510900C30016730900C300F1500901C300T5690901A100F1320901B

    d2012112010B200A0010902A10018610902B20002610902C30005280903C30003930903A10015220903C3

    d2012112010A100T0070904C30005610904C30005970904B200A0060904C300T5310904A100F1650911A

    d2012112010A100F1650911

    One row is two characters short and another 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)

  • RE: Compare Lists within a Table

    Thanks for the feedback, Goldie. I needed to do such a thing with 300,000 lists that had 1 to 12 items in each list. I tried other 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)

  • RE: single column data spit into multiple columns to another table

    ashok_bayyana (5/11/2011)


    Hello sir

    first let me say thanks

    Your query is very good and working fine but in my table i have 13 rows ...

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

  • RE: try this !!

    Mike01 (5/10/2011)


    I tried this and it works. What am I looking for?

    It would appear that someone has discovered the joy of using recursive CTE's to resolve Adjacency List hierarchies...

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

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    It would be very interesting, indeed, if there were a true relational database that some of the people touting the attributes of relational databases could try. I believe 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)

  • RE: sql server time out and memory dumps

    sqlstar2011 (5/13/2011)


    How do I go about tackling this issue?

    If you've run the trace as you say you have, then you have a list of the queries that are causing 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)

  • RE: renaming a txt file

    ashok_bayyana (5/14/2011)


    Hi

    I have copied the txt file from c:\ drive to a table (txtid) through bulk insert it is working fine

    then same time...

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

  • RE: Compare Lists within a Table

    Hi Goldie,

    Before we start on a solution, let's make more than just a handful of rows of data to test with so we can see what happens when scale increases.

    --=====...

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

  • RE: Employee Roster

    learnerbd (5/13/2011)


    Dear All,

    If you have any employee Rostering Query from at least 3 Table (Employee,Attendance,Roster)

    Please help me

    Such example queries exist in the "AdventureWorks" example database that comes with SQL Server....

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

  • RE: Convert String to a Table using CTE

    phickey (5/13/2011)


    msaleem-583379 has a pretty good function.

    Where is that? What is the URL? I don't see such an entry on this thread.

    And, for the record, the "performance...

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

Viewing 15 posts - 33,931 through 33,945 (of 59,102 total)