select case

when c2 =

(select min(c2)

from mytable

where c1 = o.c1

group by c1) then c1

else null

end,

c2

from mytable o

This seems to work for what you have described. Try it and...

I have posted a solution in reply to the "Execute Package task" post in the DTS forum.

There is a property 'Join Transaction if present' for a task. look into using this. i do not have experience with it. But this might be what you need.

I...

Hi

I do something similar to what you do. By cycling and displaying all the global variables in the sub (executed) package, I found that the variables passed from the...

quote:

---

Hi,

I am using a DTS Package to call another DTS Package using the 'Execute Package' Task. I need to pass a value...