Recent IT Questions

1 - 20 of 54
<<PREVIOUS 1|2|3 NEXT>>

Slow query response time in SQL Server 2005

Software/Hardware used: sql server 2005

View Answer   |  Oct 26 2009  4:30 PM GMT
Query, Slow SQL Query
asked by SQL Server Ask the Experts

  2420 pts.

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

Answer Question   |  Jul 28 2009  11:46 AM GMT
make-table, parameter, append
asked by Shdrc

  5 pts.

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

View Answer   |  Jul 6 2009  2:32 PM GMT
Query
asked by Booya

  10 pts.

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]., =...

View Answer   |  Jun 29 2009  5:32 AM GMT
SQL, Update, Query
asked by GPNel2006

  75 pts.

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?

View Answer   |  Apr 17 2009  8:30 PM GMT
Calculating fields, Query
asked by MahiraAgate

  15 pts.

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

View Answer   |  Jan 19 2009  11:14 AM GMT
SQL, Query, SQL Query
asked by GPNel2006

  75 pts.

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

View Answer   |  Dec 30 2008  8:24 AM GMT
AS/400, Query
asked by Ezis

  15 pts.

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

View Answer   |  Dec 18 2008  6:16 PM GMT
AS/400, Query, SSN
asked by Rmason

  335 pts.

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

Answer Question   |  Nov 7 2008  7:06 PM GMT
LANDesk, Query, LANDesk 8.x
asked by Jlshelton

  35 pts.

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?

View Answer   |  Oct 14 2008  4:51 PM GMT
Query, STRQMQRY
asked by Fonz

  15 pts.

Alpha to numeric

How to converet a field from alpha to numeric in query

View Answer   |  Oct 10 2008  2:34 PM GMT
Development, Programming, Query
asked by Buzzy

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

asked by Mayuri

  155 pts.

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

View Answer   |  Sep 25 2008  8:03 PM GMT
T-SQL, XML, Query
asked by Lambrite

  5 pts.

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?

View Answer   |  Sep 16 2008  3:14 PM GMT
SQL, Query, SQL Server 2005
asked by SQL Server Ask the Experts

  2420 pts.

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?

View Answer   |  Sep 11 2008  5:51 PM GMT
SQL, Query, Primary keys
asked by SQL Server Ask the Experts

  2420 pts.

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?

View Answer   |  Sep 8 2008  8:14 PM GMT
Query, SQL Server database
asked by SQL Server Ask the Experts

  2420 pts.

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

Answer Question   |  Aug 30 2008  6:41 AM GMT
Project management, Delphi, Query
asked by Anykey1

  5 pts.

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

View Answer   |  Aug 21 2008  4:16 PM GMT
SQL, Query, tables
asked by SQL Server Ask the Experts

  2420 pts.

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

View Answer   |  Jul 30 2008  6:23 PM GMT
Microsoft Access, Query, Access 2003
asked by Phixious

  15 pts.

Access Query Tag

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

Answer Question   |  Jul 29 2008  2:50 PM GMT
Microsoft Access, Query
asked by Rklawson

  5 pts.

1 - 20 of 54
<<PREVIOUS 1|2|3 NEXT>>