Re: SQL in ACS vs Green Screen

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Greg

When you say that green screen version shows results within seconds, do 
you mean the first screen, or the entire result set? If the former, how 
long does it take to go to the end in STRSQL?

*Regards*

*Vern Hamberg*

<cid:part1.yruwZGKv.v1psmWHL@centurylink.net>

On 2/4/2025 9:04 AM, Greg Wilburn wrote:
> I just observed the oddest thing... I have several SQL statements that aren't terribly complex.  However, they would not finish in ACS (would not show any results and ran for almost an hour).
>
> If I copy the same SQL statements into the green screen STRSQL, they show results within seconds.
>
> I ended the QZDASONIT jobs after canceling the action in ACS.  I also restarted the ACS Run SQL scripts application.
>
> Anyone ever encounter this?
>
> TIA
> Greg
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@totalbizfulfillmentcom>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>