I have a table of these columns:
userID, date, NumberofLogins
Basically records on which date how many times the user has logged in.
How can I turn this into a table with the following one using SQL query?
UserID, NumberofLoginsDate1, NumberofLoginsDate2, ..., NumberofLoginsDate31.
I only have data for a months, so this should be fine.
Could also be done by a pivot query. Repeat the Dx parts till 31. If your table has more data than August add a filter for that too. ( MONTH(date) = 8 )
OR