Search results for query: *

Probably gives me the answer. Eventhough it's not the one that I want to hear. Thank you all.

I don't think that will help. This job needs to run every 30 minutes until all of it's step have completed successfully. There is a possibility that steps 1 through 4 finish, but step 5 fails. This is where it should stop at that point because step 6 depends on data received from step 5. The...

I have a need for a job to run a many times as it takes until it is completed. What is the best way to accomplish this? Additionally, there are 34 steps in the job, so if it fails after say step 5 the first time through, I would like it to pick up at the next step. Thank you in advance, Jeff

Phil, Thank you for the suggestion. Unfortunately, I could not get this to work. I added a SQL Task as advised, but when I execute the package, it never shows that this step has completed. It just sits there showing executing. Jeff

I have several Access databases that run some automated tasks through the AutoExec macro. I need to be able to open these Access databases in the last step within my DTS package. I don't care about receiving anything back from them. I just need to open them so they can run their tasks. DTS...

James, Thank you for the advice.

I would like to store my calculations within a table in SQL and then use them in a stored procedure. Is this possible? The calculation table would consist of several fields; CalculationID, Name, and Calculation. Data might look something like the following: CalculationID: 1 Name...

I need help with my query. I am trying to write a query from a table of help desk tickets that returns information on the Top 5 affected product types. I am using several fields from the Tickets table, TICKET_ID, PRODUCT_TYPE and INTIAL_RESOLVE. The INITIAL_RESOLVE field contains either a 'T'...

Wilk, Thank you for the reply. The only problem with this that I can see is that my source is an Oracle database that I do not have write access to. My target database is a SQL db. Jeff

I have created a DTS package that performs the following steps: 1) DROP TABLE ACTIVITY 2) CREATE TABLE ACTIVITY 3) Insert Records from the following query in ACTIVITY SELECT SCTR.ACTIVITY.NUMBER_SC, SCTR.ACTIVITY.TYPE, SCTR.ACTIVITY.DATESTAMP, SCTR.ACTIVITY.OPERATOR...

Terry, Thank you for quickly helping me with my problem. Can you recommend any good websites or books on SQL Server? James

I am new to SQL and am hoping that someone can help. I have a table of calls that come into our helpdesk that include the date, time, talk_time, queue_time and destination. If the destination is 0, then the call was abandoned before it could be handled by one of our helpdesk people. What my...

Thank you for the assistance. It works perfectly now. God Bless America

I have the following query that I can't get to work correctly. What I want is that when REASON = Idle 1 or Idle 2 to rename the row just Idle and leave all other REASON codes alone, and to display the sum of the durations for each REASON. SELECT CASE WHEN REASON = 'Idle 1' OR REASON = 'Idle 2'...

Unfortunately, you'll have to use ASP.Net to accomplish what you want. This version of asp allows you declare variables of certain datatypes while regular asp just allows you to declare variants. In asp.net you're could be: Dim Name As String = "Dave" Jeff