• Access Database, columns, calculatons

    Hello to everyone. I really need an answer to this question. anyone that can help, it is extremely appreciated. I have a database that has a number column, which relates to a text colum. the text colum has two differnt types of information in it. i need to add the number column, but only for...

    Mstweety10 pointsBadges:
  • MS Access-Query

    I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?

    FranktheMan15 pointsBadges:
  • how do i display session id on the web

    hi, I am doing a login page with mysql and asp.net/c#. I would like the program to run in the following sequence. 1. the user login 2. the login page will search through mysql database, 3. when it is Authenticate, it will allow the user to access. my concern now is how to you use the session id to...

    Blue50 pointsBadges:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • execution plan is same even though it takes 10 times longer to run

    I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!

    Abbi20 pointsBadges:
  • Using Access Data Bases on My Web Site

    I have a library of information that I maintian on my web site. Because it is getting large, it is difficult for a reader to find what is there. Is there a good example of an MS Access Data Base Application that allows different sorts of the information? For instance: By title, By Publication, By...

    Strategist15 pointsBadges:
  • ms sql case statement

    I have written a case statement in MS SQL that is returning a single phone number for a single id. This is valid as the database contains multiple phone numbers attached to the same id number, with differentiation based on phone type. Once I have found the prefered phone number, I do not want to...

    Espqueen5 pointsBadges:
  • Equivolent SQL Server function for Access DoCmd.TransferText

    I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?

    Paul4815 pointsBadges:
  • Wireless solution for Condo project?

    I am on the HOA board for our condo complex. We ordered a qwest business internet package and we are trying to find a good cost effective method to distribute the internet to everybody via wifi. The complex is 4 stories high, and has about 50 units total, with a big shared open lobby in the middle....

    Dorkisfoo5 pointsBadges:
  • Question on LoadAll Subfile.

    Hi, How to load more than 9999 records in the case of loadall subfile??? And i don't want delete previously loaded records. Thanks, Rama Krishna

    0 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??

    gvdsswami20 pointsBadges:
  • Why is the query using the index even though the perecentage of unique values is 52%?

    I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity ratio), the table has a ratio of 52% unique values. I thought an index should be at least 90% unique in order for it to be used. Yet when I run the query...

    Abbi20 pointsBadges:
  • Stored Procedure for dropping indexes

    I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name as...

    Dangagne30 pointsBadges:
  • Local replication

    I have a database that resides on a server. Many users have access to this database to add and edit documents. When this database is replicated to a local machine not all documents will replicate. Can someone tell me what I need to do to correct this problem? Thanks,

    Awkohl0 pointsBadges:
  • Connect to Microsoft Access database

    I want to connect to an access database that is placed on an internet server. i use the following syntex when i want to connect localy. With DB .Provider= "Microsoft.Jet.OLEDB.4.0" .Properties("Data Source").Value= "C:\Data.mdb" .Open .CursorLocation = adUseServer End With Can't i just change the...

    Blink.j5 pointsBadges:
  • How do I copy a table from one database instance to another database instance?

    How do I copy a table from one database instance to another database instance?

    Lakshmimadhuri5 pointsBadges:
  • Microsoft Access – Find and Replace Issue

    In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...

    Santino35 pointsBadges:
  • How can i express the percent margin in a query for Microsoft Access?

    How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and...

    Peljo20 pointsBadges:
  • Test cases for Ethernet switches

    I'm working on a project which is on the Ethernet switch. I'm totally new to it. Could you help me with access control lists (ACL), Quality of Service (QoS), and packet filtering concepts in detail? I find it difficult writing test cases for it.

    NetworkingATE1,545 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 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