Здравствуйте, написал тут запросик, работает :)

SELECT upper(okFIO.Fam) as Fam, upper(okFIO.Im) as Im,
upper(okFIO.Otch) as Otch, sdListFIO.Address, okFIO.dateBorn,
okFIO.WorkStagzYear as Staz, sdList.NumYear,
case when (okDocFIO.DateDoc is null) then '' else ' выдана '+convert(varchar(10),
okDocFIO.DateDoc,104)+char(13) end as DateDoc,sdList.DateList,
upper(okDoc.NameAward+CHAR(13)) as NameAward,case when(okDocFIO.SerDoc is null)
then '' else 'Серия '+okDocFIO.SerDoc end as SerD,
case when (okDocFIO.numDoc is null) then '' else ' Номер '+okDocFIO.numDoc
end as NumD,upper(okDocFIO.Prim) as Prim, case when(okDocFIO.addressDoc is null) then ''
else ''+upper(okDocFIO.addressDoc+char(13)) end as addressDoc, case sdListFIO.isOK
when 1 then 'Присв.' when 0 then 'Отказ' else 'Вопрос' end as isOK, sdListFIO.SerDoc,
sdListFIO.NumDoc from sdListFIO INNER JOIN sdList ON sdListFIO.idList = sdList.id
INNER JOIN sdListType ON sdList.idListType = sdListType.id INNER JOIN okFIO
ON sdListFIO.idOkFIO = okFIO.id INNER JOIN okDocFIO ON sdListFIO.idOkDocFio = okDocFIO.id
AND okFIO.id = okDocFIO.idFIO INNER JOIN okDoc ON okDocFIO.idDoc = okDoc.id
WHERE (sdList.idListType = 1) AND (sdListType.id = 1) AND
(sdList.DateList >= CONVERT(DATETIME, '2006-08-01 00:00:00', 102))
and NumYear=(select NumYear from sdList where idListType=1) order by Fam,Im,Otch

Однако при попытке выполнить тот же запрос в XML-ке выдается ошибка вот здесь:
NumYear=(select NumYear from sdList where idListType=1) Если написать NumYear=11, то все ОК.
Кто подскажет по какой причине?:)
Извиняюсь, если непонятно объяснил. Ламер, сами понимаете:)