tag:blogger.com,1999:blog-9075786158122089104.post5595441087526543704..comments2023-10-23T19:47:51.926+05:30Ritesh 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 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 [Method] = &#39;&#39;Ship_Date&#39;&#39; :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 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 <br />but if I add filters in <br />inside of set <br /><br />such as :<br /><br />[MEthod]= &#39;SHIPPING_DATE&#39;<br />..the symbol &quot; &#39; &quot;<br />give an error : <br /><br />Invalid column name &#39;Shipping_Date&#39;Anonymousnoreply@blogger.com