error

create #table(A nvarchar(30), B nvarchar(20), c nvarchar(15), D int)
insert into #table
select A,b,c,d
from x,y,z
group by a,b,c,d

select *,(select max(d) from #table t
where t.a = d.a and t.b = d.b and
t.c like 'm%') as mx1
drop #table
go

when there is such data as t.c like 'm%',
it works OK but otherwise, i get error:
not supported,
details:
cannot obtain error message from server.

--
Sent by 3 from yahoo part of com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.comReplied in
microsoft.public.sqlserver.programming

--
David Portas
----
Please reply only to the newsgroup
--