Software Voices

Create proc sp_AsManyAsYouLike as

set nocount on Select myInt * 1000 from #tempParam

go

$cmd->{ActiveConnection} = $conn;

$cmd->{CommandType} = 1;

$cmd->{CommandText} = "set nocount on Create table #tempParam (MyInt int)\n";

$cmd->{CommandText} = $cmd->{CommandText} . "Insert #tempParam Select 1\n";

$cmd->{CommandText} = $cmd->{CommandText} . "Insert #tempParam Select 2\n";

$cmd->{CommandText} = $cmd->{CommandText} . "Exec sp_AsManyAsYouLike";



$WScript->Echo($cmd->CommandText . "\n");

    

$RS = $cmd->Execute();



while(!$RS->EOF){

$WScript->Echo($RS->Fields(0)->value);

$RS->MoveNext;}

set nocount on Create table #tempParam (MyInt int)

Insert #tempParam Select 1

Insert #tempParam Select 2

Exec sp_AsManyAsYouLike



1000

2000