Query

Slow query response time in SQL Server 2005

Software/Hardware used: sql server 2005

Can a command button macro run a make-table query with an auto-inputted parameter value?

I want to run a make-table query with a parameter, using a command button click event on a form showing a single record. The parameter value needs to be inputted automatically using the value of a control in the current record of the same form. Can this be done with a macro event? If so, what...

Using the query to filter out the specifics

Hello, i was just wondering if there is any way to use the query to filter out all the list with the word "mexT" in their lines/box. For example, in the column, there are bunch of lines with lines such as "cexT3df3#", aextT3rdfad" "mexT124ef3" "mexT235tgc#", etc.... but not exactly just mexT. How...

0 Row affected

Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM], = dbo.[Elution_Report]., = dbo.[Elution_Report]., =...

Update field in table from a calculated query field

I have a form attached to a query with calculations. How do I make the calculated values write back to the table?

MS SQL query to update a table with the last entry in another table.

Hi, Could anyone please assist. I'm trying to update a Reporting Table with the last entry in another table. I've tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the table is...

AS/400 Query: How to select records with digits and/or characters

Hi, I'm doing a cleanup and I need your help. 1) Is it possible by using As/400 query to select records which containing digit or signs (1, 2, @, -, & Etc.). For example, field "customer name" with digits/signs. 2) Is it possible by using As/400 query to select records which containing characters...

Query 400 - SSN

Hi all, I need to strip all but the last 4 digits of employees SSN in a file...I cannot remember what the string is!!! Can someone help? BTW, the current field has NO dashes in the SSN. Thanks in advance!! Rick

Landesk query

Landesk version 8.7 SP 4 I am trying to write a query in the Landesk consol In the Machine components I have selected logon names. I have tried using “=” and “like” But if I insert more than one logon name, save the query and run it I get a “no results” the query will run with one name...

Edit codes using Strqmqry

I am passing a date field to a query via strqmqry command. However, my numeric edit codes are not what I defined them in the query definition. Seems a default code for numerics is used. What am I doing wrong?

Alpha to numeric

How to converet a field from alpha to numeric in query

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...

T-SQL Query- how to explode XML fragment stored as NText into table?

I'm using a commercial storefront software that offers "extension data" fields as NText to store custom data. I am storing an xml fragment that looks like this: <priceSplit xmlns="http://tempuri.org/priceSplit.xsd"> <split> <type>Credit Processing Fee</type> ...

Writing a query in SQL for use in SQL Server 2005

I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

Writing a specific query involving primary keys in SQL

I need to write a query in SQL that will get the fifth-from-last record from my database when either a primary key is defined or no primary at all is defined. How would this query look?

Making a query for a SQL Server database

I would like to make a query for my SQL Server database to specify that only unmatching records should be displayed from both tables. Can you help me in doing so?

Delphi BUY BACK or After Market Sells of OCS

Searching for any info on the existence of a Delphi OCS buy-back program or resell vendors that deal primarily with the OCS display systems. Recently acquired a complete unit (OCS9200-150 15” Color AM/TFT LCD with the full support interfaces housing unit and an IMS9000 Intelligent Modem Switch)...

Problems with the SQL query function

I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table...

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 query (or whatever if...

Access Query Tag

Is it possible to tag an access query with keywords like you can do in other MS applications?