i can't figure out rewrite sql statement avoid error below   msg 8120, level 16, state 1, line 26 column 'staffmember.staffmemberid' invalid in select list because not contained in either aggregate function or group clause.   sql statment   select (select [dbo].[udf_readstaffmemberbasic](sm.staffmemberid)     xml path ('staffmembersummary'), root ('items'), type ),     count(sm.staffmemberid) totalresults,     ceiling(cast(count(sm.staffmemberid) decimal)/ @pagesize) totalpages     staffmember sm     inner join staffmembertoadditionalrole ar     on sm.staffmemberid = ar.staffmemberid     (sm.firstname '%' + @name + '%' or  sm.surname '%' +  @name + '%')         ,  (@floorid null or sm.floorid = @floorid)         , (@directorateid null or sm.directorateid = @directorateid)         , (@additionalroleid null or ar.additionalroleid = @additionalroleid)     order sm.staffmemberid         offset @page * @pagesize rows         fe...
 
Comments
Post a Comment