Hi,



Recently I upgraded from my Access database to SQL Server and noticed that 

some of my stored procedures display odd results.



When I test the stored procedure through the SQL Web console the stored 

procedure works fine and displays all the results I'd expect.



However, when I access the stored procedure through an ASP page not all of 

the contents of the recordset are displayed????



I've noticed that whether the field value is displayed or not is dependent 

on where it is placed in the stored procedure



For example, if I place the fields that aren't diplaying properly at the 

front of the SELECT statement then they display - does anyone know why 

this is????



Any help would be greatfully appreciated as I have a tight deadline!!



Regards



Dave