Top Articles

Dynamic Pivot Procedure for SQL Server

mark_wills05/15/2009, 12:00 AM

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively

Topic: SQL Server 2005Tags: SQL2005 sql2008 PIVOT

Views: 9537Comments: 16

Delimited String Parsing in SQL Server 2005 and later

BrandonGalderisi11/20/2008, 12:00 AM

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa

Topic: SQL Server 2005Tags: parse, string parsing, delimited string, user defined function, sql server 2005, sql server 2008

Views: 6739Comments: 8
Loading Advertisement...

Top MS SQL Server 2005 Experts

  1. ScottPletcher

    181,549

    Guru

    1,920 points yesterday

    Profile
    Rank: Genius

  2. jogos

    170,423

    Guru

    0 points yesterday

    Profile
    Rank: Sage

  3. acperkins

    137,453

    Master

    2,000 points yesterday

    Profile
    Rank: Genius

  4. TempDBA

    109,607

    Master

    1,400 points yesterday

    Profile
    Rank: Sage

  5. matthewspatrick

    88,224

    Master

    0 points yesterday

    Profile
    Rank: Savant

  6. lcohan

    84,634

    Master

    0 points yesterday

    Profile
    Rank: Genius

  7. dtodd

    82,612

    Master

    0 points yesterday

    Profile
    Rank: Genius

  8. mwvisa1

    76,156

    Master

    0 points yesterday

    Profile
    Rank: Genius

  9. ValentinoV

    72,711

    Master

    0 points yesterday

    Profile
    Rank: Genius

  10. angelIII

    53,816

    Master

    0 points yesterday

    Profile
    Rank: Elite

  11. EugeneZ

    53,602

    Master

    0 points yesterday

    Profile
    Rank: Genius

  12. anujnb

    53,164

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  13. ralmada

    50,844

    Master

    0 points yesterday

    Profile
    Rank: Genius

  14. HainKurt

    49,150

    0 points yesterday

    Profile
    Rank: Genius

  15. Buttercup1

    46,068

    0 points yesterday

    Profile
    Rank: Master

  16. huslayer

    40,600

    0 points yesterday

    Profile
    Rank: Sage

  17. appari

    37,400

    0 points yesterday

    Profile
    Rank: Genius

  18. wdosanjos

    33,836

    0 points yesterday

    Profile
    Rank: Genius

  19. tim_cs

    32,200

    0 points yesterday

    Profile
    Rank: Wizard

  20. dqmq

    31,136

    0 points yesterday

    Profile
    Rank: Genius

  21. Cluskitt

    30,940

    0 points yesterday

    Profile
    Rank: Wizard

  22. SJCFL-Admin

    30,877

    0 points yesterday

    Profile
    Rank: Master

  23. jimhorn

    28,975

    0 points yesterday

    Profile
    Rank: Genius

  24. Brichsoft

    28,107

    0 points yesterday

    Profile
    Rank: Sage

  25. momi_sabag

    27,903

    0 points yesterday

    Profile
    Rank: Genius

Hall Of Fame