• Updating a field and counting unique field values from another fields all in the same query?

    How can I structure the following query to allow me to count the number of unique entries in a field named "amount" and using the same query, update another field named "unique" Here is what I am doing: SQL = "select amount, count(amount) from tblmessagein group by amount having count(*) = 1" If...

    Grantp40 pointsBadges:
  • Creating a new database

    I want to create a Part Identification database using images in the left (Navigation) pane which link via hotspots to other images and information which can then be displayed in a new window. I have worked with a database of this nature created by somebody else and I cannot seem to change anything...

    Vanguard115 pointsBadges:
  • query function that results in latest date

    Have 2 linked databases, one with name/address/ect, the second with dates service was provided for each address. I would like to query with the result being the address and other data with the date of latest service. I don't know the function that will result in only the latest date. I can get >...

    Wbfiv25 pointsBadges:
  • AccessDataSource and ‘?’ parameters asp.net

    I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an EmailAddress....

    OrangeMiro20 pointsBadges:
  • How to automate getting the .CSV file from IFS folder to local desktop

    I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open the .CSV files...

    Richapd5 pointsBadges:
  • DB2/400 stored procedures

    Can you please tell me how to create stored procedures in AS/400 and when they are to be used?

    ten20081,150 pointsBadges:
  • design a strategy for implementing various applications in one database

    how can i design a strategy to run multiple applications on one database to ensure a conflict-free database storage?

    Faisal2420 pointsBadges:
  • Trying to learn – How to filter dates…

    I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only get current dates needed. I need to know a way...

    Beginner095 pointsBadges:
  • Where to place the tempdb log file?

    I've heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Data mart architecture

    In a data mart only architecture what will the development team(s) encounter?

    Robsonsamuels15 pointsBadges:
  • error message pop up

    error message is(File or directory C: is corrupt and unreadable. Run chkdisk utility.) I don't understand how to do this or what to go under to fix it. Please help me I tried to read over the troubleshooting ways you have listed on your website but I still don't understand.

    Athreedogs5 pointsBadges:
  • Access 2003, calculating dates

    I have a database and I need the following to calculate based off a date field. My problem is that regardless if the date entered in that field is the beginning, middle, or end of month, I need another field that will produce a due date, which has to be the end of that month, which could be 6...

    Helen123415 pointsBadges:
  • front end tools

    My company is in the process of building out a DW. Although there has been many discussion topics within the individual end users, the one area of conflict is on what front end tool to use. More specifically, we have some expert users who want to directly access the DW and others who are ok with...

    AJB1005 pointsBadges:
  • implement large database application in network environment

    how can i choose the best of the network architecture to implement a large database application in a network environment?

    Faisal2420 pointsBadges:
  • Looping,Array On Procedure MYSQL

    For All IT I have Data string "123". How to create procedure (MySQL) for string "123" to Be : 1. 123 2. 132 3. 231 4. 213 5. 312 6. 321 Point 1-6 is array. Please Help Me an Thanks Thanksss

    Allies5 pointsBadges:
  • Can’t access drives of local machine

    when i login to client machine with domain user id, nothing local drives are display....

    Chinmay10 pointsBadges:
  • Date a specific record in Microsoft Access

    I have a database where I would like to specifically date a record when a value/change is made in one of the fields of the record. Specifically, my database has addresses for donation solicitation, and I wish to date a donation made by a receipient at a particular address. So, basically, if I...

    Sfd41065 pointsBadges:
  • Database connection with OLE DB

    we are connect the database with the help of oledb data adapter.data are updating on screen but data not update in backend.

    Katni5 pointsBadges:
  • Journaling and commitment control

    Is it mandatory to journal a file to open it under commitment control? thanks

    ten20081,150 pointsBadges:
  • Access rights for Storage Team members

    We are having to justify the access rights that our storage team members have to the Windows, VMWare, and Unix servers. Our storage team is also responsible for all backups, restores, and disaster recovery. Can any one provide a best practices or a already compiled list of access rights that they...

    Smonroe5 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