I have the following SQL which outputs fine when run both adhoc and as sproc in SQL Studio.
But when I try to retrieve data using ADO... the recordset returns with nothing. I've tried accessing the sproc through CommandObject and Recordset.Open methods and it's giving me nothing!
The only difference between this query and all others I've successfully written is this is the first time I'm using
Does EXECUTE sp_ExecuteSQL
require special handling in ADO? This is ADO 2.6, VB6 and SQL 2008.
declare @itemID varchar(20)
declare @columns varchar(max)
declare @startdt datetime
declare @enddt datetime
set @itemID = '008888164647'
set @columns = '[September], [O
View Complete Post