Viewing 15 posts - 601 through 615 (of 621 total)
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 9, 2007 at 9:04 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 8, 2007 at 10:36 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 8, 2007 at 12:36 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 8, 2007 at 10:48 am
Just curious, why does it have to be through DTS?.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 8, 2007 at 10:41 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 6, 2007 at 1:30 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 6, 2007 at 12:19 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 1, 2007 at 10:39 am
Sergiy (9/28/2007)
Un-bloody-believable!How could possibly a dude having no idea about binary get any job in IT industry???
Sergiy it is not as bad as it seems. Suffice it to say...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 30, 2007 at 3:22 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 28, 2007 at 5:25 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 28, 2007 at 9:29 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 27, 2007 at 7:01 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 26, 2007 at 9:07 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 26, 2007 at 10:25 am
Geez, I guess I did not see that huge sid column in both tables.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 26, 2007 at 10:20 am
Viewing 15 posts - 601 through 615 (of 621 total)