Thursday, May 1, 2014

multiple aggregation using pivot in sqlserver

Hi Baiju,


your output requires an in/out flag. But it seems as if it is not part of your events table. Then it seems that your sample data does not fullfill your requirements. Could you explain how the data disclose which registered time is a "in" or "out" event?


Best regards,


Rudolf




Rudolf Swiers


No comments:

Post a Comment