Query tuning Questions

1

Signed field to a packed field in AS/400 query
Does anyone know of a way to move a signed numeric to a packed numeric in query? Is it even possible?   Been playing with it and can’t find a way.  Any answer appreciated. 

Answer Question   |  March 15, 2011  6:39 PM
AS/400 administration, AS/400 Query, Packed Fields, Query tuning
asked by:
50 pts.

How to pass value at run time from VB 6 to Access 2000 Query for reporting
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is [...]

Answer Question   |  October 6, 2008  10:19 AM
Access, Access 2002, Query, Query tuning, VB, VB 6, Visual Basic 6, Visual Basic developers, Visual Basic for Applications
asked by:
155 pts.

Difficult SQL query, is this possible?
Two tables, First Table –FN—LN—-Reasons John | Doe | 6 | Jane | Doe | 2 | —————– That’s the end of the first table. Second Table —Reason—-Reason Detail—– 2 | Invalid SSN 4 | Invalid Date Of Birth ————————————– That’s the end of the second table. (*Note, there is NO value of ’6′ in [...]

Answer Question   |  April 20, 2012  11:37 PM
Database, Developers, Development, Query, Query tuning, SQL, SQL Query
asked by:
35 pts.

1