Viewing 15 posts - 25,246 through 25,260 (of 26,487 total)
Matt, Perfect, it was CDOSYS i was trying to come up with when I suggested doing a serach on CDO on this site!
😎
February 22, 2008 at 2:53 pm
Go up to the Search box on this page, and do a search on CDO. You will find many hits, and one or more of them may be quite...
February 22, 2008 at 2:29 pm
Actually, for me it isn't much more help. I could really use a more detailed description of what you are trying to accomplish. If you could provide DDL...
February 22, 2008 at 2:21 pm
It would help if you could provide us with some sample data. This article will help you put together wjat we need to help you better:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
😎
February 22, 2008 at 2:15 pm
There may be a better way to accomplish what you want, but to do that we really need to know the structure (or at least the relevent portions) of the...
February 22, 2008 at 2:13 pm
This could probably be done using dynamic sql. To really help you, we need more info from you to be sure we give you something useful back. Please...
February 22, 2008 at 11:54 am
Give this a try:
SELECT TOP 500
MuniAnnuals.DOCID,
MuniAnnuals.FYE,
MuniAnnuals.DOCNAME,
MuniAnnualsdocument.DocumentID,
MuniAnnuals.StateID,
...
February 22, 2008 at 11:31 am
Also, can't change the time when the jobs run, part of the process has to be completed prior to 9:00 PM local time to ensure data is transferred to a...
February 21, 2008 at 9:37 am
I wish it were that simple. All of the jobs have multiple steps, one even has 60+ (I'd have to open it to get the exact number and I'm...
February 21, 2008 at 9:17 am
And I'll third that. That should actually be the first thing you do.
😎
February 20, 2008 at 1:27 pm
Jeff, I knew there was a way to do it with dateadd, I just didn't think it through enough. Good catch!
😎
February 20, 2008 at 11:43 am
I am assuming that when you say you fixed the issue in the GUI, you meant that you set the package property DelayValidation to true. If you saved and...
February 20, 2008 at 10:35 am
We are still having a problem with this. If anyone has any ideas they would be greatly appreciated.
😎
February 20, 2008 at 10:28 am
I would do this is four steps.
1. Create a new column on the table as a datetime column: xyz_new
2. Update the new column with the following code: update...
February 20, 2008 at 10:04 am
Viewing 15 posts - 25,246 through 25,260 (of 26,487 total)