What I want to do is the following: Name_Patient......... amount........ xxxx aaa................................500.................500 bbb...............................500...................500 aaa................................500..................1000 I want to make the field named xxx to...

There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might...

How would I be able to rename a MySQL database quickly? Most of the time, I usually just dump the database and re-import it with a new name. But since this is a huge database, this isn't possible. Can anyone help me here?

I'm an IT student from tanzania. Currently I'm an intern in one of the united nation org. but I'm only doing user support activities. But I want to build my carrier in database management. Can you give me some advice on where to start and what to study?

I am having a specific problem with coding in SQL, and I was curious if you could give me any advice. I have entered this code: CREATE TRIGGER UpdateAfterPayment On SupplierTransactionDetails For Insert, Update, Delete As Update S If i.DebitValue>0 S.Balance = S.Balance + i.DebitValue else...

Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one PDF file through VBA. Access 2007 has easy way to convert one report at a time to PDF, however, I cannot figure out how to...

I was wondering is there a way to create a mass email from a query or table that would send out in MS Outlook? I know of a way of extracting a table and importing it into Outlook but my boss wants a more efficient way.

Hello everyone! Please help me with this question: Is it possible to send save files from iSeries to PC (Win2000 Server) through some batch program? The idea is to make manual connection and FTP transfer and then to create a batch program which would give possibility to schedule this FTP transfer I...

Hello all, does anyone know how to change the DHCP range that a Cisco 1200 series Access point gives out, the IP for the AP is 10.20.x.x, and it give out IP's in the 192.168.x.x range, does anyone know how I can get it to change to the 10.20.x.x range as this is the range that I want the computers...

Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...

I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, plan name what I want to happen is when...

If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.

To follow this tag...

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