Hi everyone,

We encountered two anomaly's in SQL 6.5 SP4.
1) Running an SP which takes
2) Running an SP that misses some data in the result set.

Example 1)

Example 2)

create procedure xxx()with recompile
as
begin
if exists (select * from tempdb.dbo.sysobjects where name = "##tempMessages")
begin
drop table ##tempMessages
end

create table ##tempMessages
(
id decimal(3) identity not null,
ExtraData varchar(10) not null
)

insert ##tempMessages
(
ExtraData
)
select ExtraData
from Table
order by cc.Colorcode