Forum Replies Created

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

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

    May 15, 2011 at 11:30 am

    #1324726

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

    May 15, 2011 at 10:57 am

    #1324723

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

    May 15, 2011 at 10:48 am

    #1324721

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

    May 15, 2011 at 10:30 am

    #1324715

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

    May 14, 2011 at 10:50 pm

    #1324665

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

    May 14, 2011 at 10:36 pm

    #1324664

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

    May 14, 2011 at 9:34 pm

    #1324663

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

    May 14, 2011 at 2:23 pm

    #1324648

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

    May 14, 2011 at 2:06 pm

    #1324646

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

    May 14, 2011 at 1:16 pm

    #1324644

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

    May 13, 2011 at 4:51 pm

    #1324581

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

    May 13, 2011 at 4:36 pm

    #1324579

  • RE: renaming a txt file

    xiewei (5/13/2011)

    also want to know the correct answer.

    See the post above your original...

    --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 13, 2011 at 9:03 am

    #1324365

  • RE: Conditional Counting

    The Dixie Flatline (5/12/2011)

    You CAN use a CASE statement in a COUNT... --Jeff Moden

    It's just a personal preference. I just feel happier summing ones...

    --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 13, 2011 at 8:47 am

    #1324343

  • RE: Sum Distinct

    jvElecenter (5/13/2011)

    Hi there

    I know what the questionaire means. Have now the same problem.

    I have a grouping on delivery address and I need to know the quantity of collis delivered. 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 13, 2011 at 8:43 am

    #1324338

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