When running a simple select statement followed by a similar select statement as
you see in the sql below,
I never get the Second SQL execution results to display .. I have even tried a
Go between the two selects and that doesn’t work either.
I get the messages value but just not the result set.
Please note the following is blank
Hopefully, this is not a problem but an Option. However, I suspect there is
something else-a-going-on in the wild-wild-world of Toad-SS 5.0.0.444..
There4, I would like to know what to do to trap and report this problem so that
I and others who are experiencing it as well can give you what you need to fix
the problem. (No Support bundle supplies as of this email…
The work-a-round is to just run the second sql Select statement after the first
one finishes.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
select * from JustEnergy.dbo.DirectDebitCreditCard
where upper(cardType) like '%DISC%' -- rowcount 4950
--go
select * from JustEnergy.dbo.DirectDebitCreditCard
where upper(cardType) like '%VISA%' -- rowcount 138765
