Recent content by georgia51390

Is there a way to encrypt one column of data in a table? I have a table that stores user ids and passwords, but I want the passwords to be encrypted, so that if the table is opened, the passwords cannot be seen. Could a procedure be created to do this? Thanks so much!

Hey, THANKS Terry! I will try on a sample table and see if it works. Thanks so much!

It is kind of complicated. I have patient IDs, admission dates, and discharge dates. I need to look at every patient and their discharge date. I need to select, for each patient, their earliest discharge date. Then I need to look at their next admission date and only select those records...

Hi there, I have a table(table A) that contains patients and appointment dates. A patient may be in the table numerous times. I need to create a new table that has each record from table A for each patient ordered from the earliest to latest date. Is there a way to create a new column that...

I guess I am willing to try anything! Let me know what you think. . . thanks so much!

This is a tough one! I have a table of patient enrollment data. The table has a patient ID, an enrollment date, and a status value. Patients are in the table for every month that they are enrolled, and the date is always the last day of the month. I need to write a statement to look at each...

I have a question about deleting rows from a table. I have 2 tables of patient data (group number, birthdate, gender). I want to delete all those from table A that are also in table B, but I need for them to have a matching group number, birtdate, AND gender to be deleted. They have to match...

Hi there, I have a table of patient IDs and appointment dates. Patients may be in the table a number of times with different appointment dates. I need to create a new table with each patient ID only once and their EARLIEST appointment date. Is that possible with the MIN function? Thank you!

thank you!! It worked perfectly!!

Hi there, I have a table that has one column of ID #s. The ID's represent people and can be in the table any number of times. I have a second column of dates - these are dates that the ID/person was active in the system. For each unique ID, I need to count how many times were they active (how...

Thanks, that is probably what it is. . . I am running a script to check that now. . . THANKS!

I am trying to convert a column in my table that contains dates in this format: 5/21/01. Could someone give me the correct syntax to convert the datatype from char to datetime? I keep getting the error "The conversion of a char data type to a datetime data type resulted in an...

Due to hard drive space issues, I was told to delete some transaction logs on my database after truncating the logs. The data file (.mdf) file is still intact, however, my database is now marked "suspect". I have tried to reset the status without success. The error logs report that...