Display query results

[BFT1303]

I am running a query on Microsoft SQL Server 2000. I need to display the results to the screen. What is the easiest way to do this?

SELECT SUM(BIN_QTY) AS "TOTAL AVAILABLE" FROM plm_brad.LEI_WAREHOUSE WHERE PART_ID = 'N142' AND BIN_ID = '03LOC';

Thanks

 

[Dashley]

BFT what front end language are you using?

 

[TysonLPrice]

Run it in Query Analyzer?

 

[BFT1303]

Dashley I am using GTL 5.1 IT is a barcoding software that uses SQL. THe select statement works great in Query Analyzer however if I could even store it directly into a memory variable that would work in my favor.

 

[Dashley]

BFT,

I've never userd GTL so I dont know what its capacity is.
I normally create an object/Variable and store the query response in it. Will GTL let you do that, How flexable is it?

 

[BFT1303]

Not very flexible. I can get the sum with multiple reads, I was just trying to find a way to increase the processing speed of my program