tag:blogger.com,1999:blog-9075786158122089104.post5595441087526543704..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: Dynamic PIVOT with WHERE condition in SQL Server 2005Ritesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-9075786158122089104.post-10621473555789457142011-05-10T23:45:49.508+05:302011-05-10T23:45:49.508+05:30what about to do a total sum of the pivot columns ...what about to do a total sum of the pivot columns header ? with (sum(grades) over(partition by ID)) as totalAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-7124750104680815762011-05-10T00:39:05.596+05:302011-05-10T00:39:05.596+05:30--- using two time single quote allow to use [Met...--- using two time single quote allow to use [Method] = ''Ship_Date'' :D make work <br /><br /><br /><br />it is workginAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-21877556174762630212011-05-07T09:24:25.344+05:302011-05-07T09:24:25.344+05:30can you please show me your full script if it is p...can you please show me your full script if it is possible?Ritesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-61010722126898725262011-05-07T05:03:06.338+05:302011-05-07T05:03:06.338+05:30I got work
but if I add filters in
inside of set...I got work <br />but if I add filters in <br />inside of set <br /><br />such as :<br /><br />[MEthod]= 'SHIPPING_DATE'<br />..the symbol " ' "<br />give an error : <br /><br />Invalid column name 'Shipping_Date'Anonymousnoreply@blogger.com