MS Access DB – Query
I have an Access database this is in place for in person registration at a convention. The registration system uses a few data fields then prints a report. I can’t get the report to work the way that i want it to. I need the report to pull the record that i just entered via [...]
Answer Question
| August 5, 2008 6:23 PM
Access 2003, Microsoft Access, Query
I have an Access database this is in place for in person registration at a convention. The registration system uses a few data fields then prints a report. I can’t get the report to work the way that i want it to. I need the report to pull the record that i just entered via [...]
Answer Question
| August 5, 2008 6:23 PM
Access 2003, Microsoft Access, Query
Access Query Tag
Is it possible to tag an access query with keywords like you can do in other MS applications?
Answer Question
| July 29, 2008 2:50 PM
Microsoft Access, Query
Is it possible to tag an access query with keywords like you can do in other MS applications?
Answer Question
| July 29, 2008 2:50 PM
Microsoft Access, Query
WRKQRY Security Flaw / Users can Alter/ Replace Data in Production Files
Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY…??? I have an auditor who believes in the “Define the Query” display, 2nd to last option (“Select output type and output form”) you can specify 3 in the output type (3 = datafile file) [...]
Answer Question
| October 21, 2009 7:03 PM
AS/400 security, Query, WRKQRY
Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY…??? I have an auditor who believes in the “Define the Query” display, 2nd to last option (“Select output type and output form”) you can specify 3 in the output type (3 = datafile file) [...]
Answer Question
| October 21, 2009 7:03 PM
AS/400 security, Query, WRKQRY
Saving the results of a SQL Server 2005 table query in a XML file
I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?
Answer Question
| July 23, 2008 5:08 PM
Query, SQL Query, SQL Server 2005
I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?
Answer Question
| July 23, 2008 5:08 PM
Query, SQL Query, SQL Server 2005
abort query handle 0001 is invalid
Has anyone see this error message before when running a query in Bex
Answer Question
| December 1, 2008 10:44 AM
BEx, Query
Has anyone see this error message before when running a query in Bex
Answer Question
| December 1, 2008 10:44 AM
BEx, Query
Current Date in Excel Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input [...]
Answer Question
| July 17, 2008 6:32 PM
Excel 2003, Excel formulas, Excel queries, Microsoft Excel, Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input [...]
Answer Question
| July 17, 2008 6:32 PM
Excel 2003, Excel formulas, Excel queries, Microsoft Excel, Query
Running a lengthy query on SQL Server 2005
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it [...]
Answer Question
| May 28, 2009 8:21 PM
Query, SQL Server 2005, SQL Server performance, Windows Server 2003
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it [...]
Answer Question
| May 28, 2009 8:21 PM
Query, SQL Server 2005, SQL Server performance, Windows Server 2003
Writing a specific query in SQL Server 2005
I have a table called “ticketing” and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?
Answer Question
| July 16, 2008 8:28 PM
Query, SQL Query, SQL Server 2005
I have a table called “ticketing” and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?
Answer Question
| July 16, 2008 8:28 PM
Query, SQL Query, SQL Server 2005
query user rights
how can you script collecting user rights on local servers?
Answer Question
| July 15, 2008 12:37 PM
Query, Scripts, User rights
how can you script collecting user rights on local servers?
Answer Question
| July 15, 2008 12:37 PM
Query, Scripts, User rights
Access 2007 form from a query
I have an Access 2007 database that lists rules for specific types of systems. I’ve run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users [...]
Answer Question
| July 11, 2008 2:34 PM
Access 2007, Access forms, Query
I have an Access 2007 database that lists rules for specific types of systems. I’ve run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users [...]
Answer Question
| July 11, 2008 2:34 PM
Access 2007, Access forms, Query
Toggling a case sensitive query in SQL Server 2005
It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?
Answer Question
| July 10, 2008 5:48 PM
Query, SQL Query, SQL Server 2005
It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?
Answer Question
| July 10, 2008 5:48 PM
Query, SQL Query, SQL Server 2005
Increasing the performance of a slow query in SQL Server 2000
I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this [...]
Answer Question
| July 10, 2008 6:04 PM
Query, SQL Server 2000, Windows Server 2003
I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this [...]
Answer Question
| July 10, 2008 6:04 PM
Query, SQL Server 2000, Windows Server 2003
Looking for a database name query in SQL
Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?
Answer Question
| July 4, 2008 5:49 PM
Database, Query, SQL, SQL Query, SQL Server
Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?
Answer Question
| July 4, 2008 5:49 PM
Database, Query, SQL, SQL Query, SQL Server
Is there a quick way of running a query to select records based on” current sysdate – 1″ i.e yesterday.
Is there a quick way of running a query to select records based on current sysdate – 1 ie yesterday. Using Martin Gilbert’s suggestion I get the current date & it works perfectly CD CHAR(CURRENT(DATE)) CURDAT SUBSTR(CD, 1, 2) || SUBSTR(CD, 4, 2) || SUBSTR(CD, 7, 2) Then use CURDAT in your selection However I [...]
Answer Question
| June 23, 2008 2:27 PM
AS/400 Query, Query
Is there a quick way of running a query to select records based on current sysdate – 1 ie yesterday. Using Martin Gilbert’s suggestion I get the current date & it works perfectly CD CHAR(CURRENT(DATE)) CURDAT SUBSTR(CD, 1, 2) || SUBSTR(CD, 4, 2) || SUBSTR(CD, 7, 2) Then use CURDAT in your selection However I [...]
Answer Question
| June 23, 2008 2:27 PM
AS/400 Query, Query
Copying a SQL Server stored procedure with a query
I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?
Answer Question
| June 19, 2008 8:11 PM
Query, SQL Server 2005, Stored Procedures
I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?
Answer Question
| June 19, 2008 8:11 PM
Query, SQL Server 2005, Stored Procedures
Using co-related queries in SQL
How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?
Answer Question
| June 19, 2008 3:46 PM
Co-related queries, Query, SQL, SQL Query
How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?
Answer Question
| June 19, 2008 3:46 PM
Co-related queries, Query, SQL, SQL Query
how to access the p2p networks in a simple client
can p2p network (emule bit torrent or kad network) can be queried with a native client as telnet ? if so, where can this query syntax are documented ? (white paper or an ISO ref. documents)
Answer Question
| June 6, 2008 3:59 PM
Bit Torrent, P2P, Query, Telnet
can p2p network (emule bit torrent or kad network) can be queried with a native client as telnet ? if so, where can this query syntax are documented ? (white paper or an ISO ref. documents)
Answer Question
| June 6, 2008 3:59 PM
Bit Torrent, P2P, Query, Telnet
mdb talk to jdbc
is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not [...]
Answer Question
| June 6, 2008 3:40 PM
Flat files, JDBC, Microsoft Access, Query
is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not [...]
Answer Question
| June 6, 2008 3:40 PM
Flat files, JDBC, Microsoft Access, Query
Can SQL make noises?
can you get SQL to ‘make a noise’ to indicate when a query has been executed? I.e. for long running queries, you wouldn’t have to keep checking
Answer Question
| June 3, 2008 2:14 PM
Query, SQL
can you get SQL to ‘make a noise’ to indicate when a query has been executed? I.e. for long running queries, you wouldn’t have to keep checking
Answer Question
| June 3, 2008 2:14 PM
Query, SQL
Combined Address
I have one tblContacts that has “Home” and “Work” address included within it, I also have an option button 1=”Work” and 2=”Home”. I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is pulling the [...]
Answer Question
| May 12, 2008 5:29 PM
Microsoft Access, Query, SQL
I have one tblContacts that has “Home” and “Work” address included within it, I also have an option button 1=”Work” and 2=”Home”. I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is pulling the [...]
Answer Question
| May 12, 2008 5:29 PM
Microsoft Access, Query, SQL
