Sergiy, wouldn't that be storing a date as a char datatype? Why would you ever not want to use datetime datatype? I have always thought it was...

Sergiy, I kept getting strange errors when I tried to insert directly from the inserted table. Now I wish I had made note of the errors. I do...

I made some assumptions on what you need to do, based on what little info you gave. Is this a new database you are setting up? If so...

If you post your table structure for all three tables, and what you want to go where, it should be easy enough to figure out an insert trigger to capture...

Just curious, why does it have to be through DTS?.

Greg

David I do not have the sample databases, so I improvised. I think this may be what you are looking to do? I am fairly sure this is...

It kind of seems to me David is looking for a rolling three day average. If today is the third day of the month, say 10/3, then he needs...

Thanks mjw. It does not work for what I am doing. I tried using the char function in various positions in the function to no avail. I...

Sergiy it is not as bad as it seems. Suffice it to say...

I would definately make two separate procedures, but that is just my opinion. If you are going to run them from Access I am pretty sure you can manually...

Thanks again Kenneth. That stuff is a bit over my head for now. I have no idea what bitwise and hexidecimal and binary are, so I think it...

I feel like a kid in a candy store now. Thank you all so much for the valuable help. In BOL for PERMISSIONS() the following is listed and...

Wow, Adam, I guess I am going to have to learn more about system procedures. The ones you have listed I think will take me a long way toward...

That was so freakin easy. Thanks guys for your help. I never gave any thought to the master, nor did I realize I could retrieve stuff from other...

Geez, I guess I did not see that huge sid column in both tables.