• 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

    Rmason335 pointsBadges:
  • abort query handle 0001 is invalid

    Has anyone see this error message before when running a query in Bex

    Hedm15 pointsBadges:
  • 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...

    Jlshelton35 pointsBadges:
  • Alpha to numeric

    How to converet a field from alpha to numeric in query

    Buzzy5 pointsBadges:
  • Query Criteria question

    I am designing a query. One of the fields in the query is "department". In my form there is a pull down menu with about 20 departments. In my query, I am making the department field have a criteria so that when you run the query, it asks for which department. However, if you do not type the...

    Jena5 pointsBadges:
  • 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...

    Mayuri155 pointsBadges:
  • 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>...

    Lambrite5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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)...

    Anykey15 pointsBadges:
  • 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 where ref_id='1001',” it returns 1002, 1003...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    Phixious15 pointsBadges:
  • Access Query Tag

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

    Rklawson5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 it everytime? Thank you!

    Jameb1220 pointsBadges:
  • query user rights

    how can you script collecting user rights on local servers?

    Rsc5 pointsBadges:
  • 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 can answer the questions posted by the...

    V-Ger5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 from the database?

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following