Hi all,
Using VS 2005 and MSSQL 2005.
I created a view with the following:
select Brandid
, products = left(o.list, len(o.list)-2)
from lstBrand
cross apply
(
select Convert(varchar(200), ProductName)+', ' as [text()]
from lstProduct
where lstBrand.BrandId = lstProduct.BrandId
for XML Path('')
) o (list)
I then tried to add this view to a typed dataset, but get an error "Could
not retrieve schema from table or view"
But as soon as I remove the apply operator, it works.
Can some one shed some light and help
Thanks
Robert
|