Do any of these apply?
http://support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&withinResults=&QuerySource=gASr_Query&Product=sql&Queryc=8630&Query=8630&KeywordType=ANY&maxResults=25&Titles=false&numDays=-Mike
>Dear friends,
>
>i have the follow SQL Code:
>
>SELECT *
>FROM
>(
> SELECT DtOcorrencias.DtGroup, CodCategorias.CodCategoria
> FROM
> (
> SELECT
> DateADD(ww,DatePart(ww,O01.DtOcorrencia)-1,'01/01/' + Cast(Year(O01.DtOcorrencia) AS varchar)) AS DtGroup
> FROM Ocorrencias O01
> WHERE
> O01.DtOcorrencia BETWEEN '02/15/2003' AND '04/17/2004'
> GROUP BY
> DateADD(ww,DatePart(ww,O01.DtOcorrencia)-1,'01/01/' + Cast(Year(O01.DtOcorrencia) AS varchar))
> ) DtOcorrencias,
> (
> SELECT
> O02.CodCategoria
> FROM Ocorrencias O02
> WHERE
> O02.DtOcorrencia BETWEEN '02/15/2003' AND '04/17/2004'
> GROUP BY
> O02.CodCategoria
> ) CodCategorias
>) CrossTab
>LEFT OUTER JOIN Ocorrencias
>ON
>DateADD(ww,DatePart(ww,Ocorrencias.DtOcorrencia)-1,'01/01/' + Cast(Year(Ocorrencias.DtOcorrencia) AS varchar)) = CrossTab.DtGroup
>AND Ocorrencias.CodCategoria = CrossTab.CodCategoria
>
>but when i run it i receive a error message #
8630.
>
>What´s wrong?
>
>thanks