Hi,
Kindly help me from the folowing cross tab query,
while i call the procedure it throw the folowing exception:
String was not recognized as boolean
alter
Procedure CrossTab
(
@MID
int
)
AS
EXEC sys_CrossTab
'Position CBP
inner join [Client] C
on CBP.ClientID = C.ClientID
inner join Number RN
on RN.RID = CBP.RID'
, -- @SQLSource
'CBP.Runner', -- ColFieldID
'CBP.Runner', -- ColFieldName
'CBP.Runner', -- ColFieldOrder
'CBP.Positions', -- @CalcFieldName
'CBP.Positions', -- @RowFieldNames
NULL, -- @TempTableName
NULL, -- @CalcOperation
0
, -- @Debug
NULL, -- @SourceFilter Cast(@MID as VarChar(20))
0
, -- @NumColOrdering
'Total', -- @RowTotals
NULL, -- @ColTotals
'Username', -- @OrderBy
'int' -- @CalcFieldType