troubleshooting Question

Pivot Table in SQL Server

Avatar of Mike McCracken
Mike McCracken asked on
Microsoft SQL Server
8 Comments1 Solution155 ViewsLast Modified:
I have a table HF01A which has 3 columns
   Acct_Nbr     string
   Col_Head    string (has 3 values  HF_C, HF_D, HF_L)
   Col_Value     integer

ABC        HF_C     5
ABC        HF_L     7
ABC        HF_D    3
DEF        HF_L     2

I need a table
    Acct_Nbr       string
    HF_C               integer (NULL allowed)
    HF_D               integer (NULL allowed)
    HF_L               integer (NULL allowed)

Acct_Nbr           HF_C         HF_D       HF_L
ABC                  5            3          7
DEF                                          2

Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros