I have a table constructed as follows:
CID CHAR(8)
SRVDATE INT
FLDNAME VARCHAR(10)
FLDVAL VARCHAR(20)
SAMPLE DATA LOOKS LIKE THIS
CID SRVDATE FLDNAME FLDVAL
123 20090101 MEMBERID 999888777
123 20090101 PCODE 192.00
123 20090101 CHKDATE 20081231
123 20090101 CHKN0 100101
I NEED TO TAKE THE DATA IN THIS TABLE AND TRANSFORM INTO
INTO A SINGLE RECORD AS
CID SRVDATE MEMBERID PCODE CHKDATE CHKNO
123 20090101 999888777 192.00 20081231 100101
Any TSQL ideas?