What happens if there are more than one Attachment?  What is the pattern? 

Are you changing the c:\ to h:\ in place?  DTS might not be the tool for you.

Can the...

SELECT e.Employee, e.ChildName, e.ChildSex, e.Age

FROM EmployeesChildren e JOIN

(SELECT Employee, ChildSex, Max(ChildAge) as Age

FROM EmployeesChildren

GROUP BY Employee, ChildSex) a

ON e.Employee = a.Employee

and e.ChildSex = a.ChildSex

and e.Age = a.Age

This would return the result you ask for if I had a way to distinguish the two patient 01 rows

select t.Patient, t.arm, t.bestres, t.delay

from t

inner join

(

select

arm,  bestres, min(patient) as...

Your example has a flaw.  What is the difference between the two Patient 01 rows?  There is nothing to distinguish them.  You need some key:  a date, an identity.

I found the execute process task in SQL 2000 DTS.

I have basic workflow (Task2 starts on success for Task1, Task3 starts on success for Task2).  I would prefer not to link the sets in a workflow.  I'm not sure...

The following is clumsy, but it works:

CREATE FUNCTION dbo.GetEmployeesByUserID

 (@userid int)

RETURNS TABLE

AS

 RETURN SELECT e.EmployeeID from mstEmployees e

         where (exists (select 1 from secUserMasterMappings s

             where s.UserID = @userid

              and...

This is puzzling.  The executesql step 1 is not disabled is it?

I had a couple puzzles with your script (you have the wrong table in your second append query). Also, I didn't understand your result for user 1. Since all of...

What derived table did you try?  What are you trying to achieve?

select o.*

from z_inquiry o

inner join

where inquirydatetime = (

    select frontend_id, max(inquirydatetime) as maxinq_dt

    from z_inquiry i

    group...

Have you tried doing a backup and restore?  That many times can be easier.  When trying to move an entire database I get into problems with relationships.

Do you have logins...

You can store them in an image datatype.

The problem is that you need application code to load the data.

I have set the priority for the Task3 steps higher than normal.  I will watch to see if that achieves the results I want.

Is there a reason that you are not using the execute process task?  I find that when the batch file returns an error, the execute process shows an error.

dim dt

dim sdt

dim stm

sdt = "2006/01/01"

stm = "10:50:30"

dt = dateserial(cint(left(sdt, 4)) cint(mid(sdt, 6, 2)), cint(right(sdt,2))) + cdate (stm)