pivot table problem

Question

Post reply

pivot table problem

DaveBriCam

SSCarpal Tunnel

Points: 4298

November 11, 2019 at 6:11 pm

#3696815

Can anyone tell me whats wrong with the line with: FOR stateID in (36,11)?:

SELECT * FROM   
(
    SELECT 
        peopleid, 
        stateID
    FROM 

        GCDF_DB..People p
        INNER JOIN 
GCDF_DB..PeopleContactInfo l 
            ON p.peopleid = l.peopleid
) t 
PIVOT(
    COUNT(peopleid) 
    FOR stateID IN (36,11)
) piv

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

DesNorton SSC-Insane Points: 24386 More actions · Answer 1

Try

FOR stateID IN ( [36], [11] )

How to post data/code on a forum to get the best help.

DaveBriCam SSCarpal Tunnel Points: 4298 More actions · Answer 2

DaveBriCam

SSCarpal Tunnel

Points: 4298

November 11, 2019 at 7:14 pm

#3696835

that worked thanks!