title: Converting Cognos reports to SSRS , what does XSUM command does?
body: <p>We are in process of converting cognos reports to ssrs reports . i have a query which i got it from the cognos report and it is written in pervasive sql i am not sure about the language. I am able to interpret most of the query but i am stuck with one command XSUM. It has a syntax as</p>
  
  <p>XSUM(col21 at col3 col7 col5 col5 for col3 col7) as col22 where col21,col3,col5, and col7 are columns from the table. </p>
  
  <p>Can any one help me in understanding what the command XSUM does and what is the equivalent of it in T-sql please. </p>
  
  <p>Thanks.</p>