I am using the following query from an ASP page:

select Orders.CustID
into #TempTable
from Orders
join Customers
on Orders.CustID = Customers.CustID
group by Orders.CustID
having count(Orders.CustID) = 1

select count(*) as NewCustomers
from #TempTable t
join Orders o
on t.CustID = o.CustID
where cast(convert(char(10), OrderDateTime, 112) as smalldatetime) = cast(convert(char(10), '11/10/2005', 112) as smalldatetime)

drop table #TempTable

When I run this in Query Analyzer it works fine and returns a column called "New Customers". However, when I run it from the ASP page or even as a stored procedure, the column is not available. Can anyone help me with this? Thanks.

I suspect that there may be a problem with your dynamic type of data returned. I suggest trying to force the count(*) as a particular data type. Not allowing SQL to determine the data type. I have seen many times when you run something in SQL it works but doesn't in a front end app when the data type is not explicit. May want to try something like NewCustomers = convert(varchar(24),count(*)) to see if this is the issue. SQL won't care if the data type changes because it's only displaying it in a query window but the recieving application generally needs a consistent data type. Also if this solves your problem let me know so I don't have to test it.

Thanks,
Rob