hi
when I execute it below error happen
Msg 468, Level 16, State 9, Procedure GCPWclass, Line 16Cannot resolve the collation conflict between "Persian_100_CI_AI" and "Arabic_CI_AS" in the equal to operation.
below is SP:
ALTER procedure [dbo].[GCPWclass]
@PageIndex INT = 1
,@PageSize INT = 5
,@RecordCount INT OUTPUT
,@behcode nvarchar(10)
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [c].[date] asc
)AS RowNumber
,c.id
,c.Name
,c.BehCode
,(select COUNT(classification) from House_p u where u.classification=c.Name and BehCode=@Behcode group by u.classification) as TotalProduct
INTO #Results
FROM House_classification c
where Behcode=@behcode
SELECT @RecordCount = COUNT(*)
FROM #Results
SELECT * FROM #Results
WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1
DROP TABLE #Results
END
my data base collation is "Persian_100_CI_AI" but why above error happen?
what should i do?
best regards
Neda