Posted by: the_hareeb May 3, 2010
SQL server roll-up function help
Login in to Rate this Post:     0       ?        
newlynew, i looked into that, it didnt help me. My category is not a number, it is a string so I cant use Sum function here directly

khairey, i cannot use sum aggregate on nvarchar data type. we have to count the temp/perm values  use a rollup function here on category. I am not sure how
Last edited: 03-May-10 03:52 PM
Read Full Discussion Thread for this article