Viewing 2 posts - 1 through 2 (of 2 total)
You can do all in one query; you just need to add an extra row_number column with the extra partition by criteria and then add an extra self join. This...
May 16, 2008 at 10:23 pm
I would add a rownumber column to the dataflow pipeline and then use a conditional split to send the rows to the destination where rownumber>6....
January 31, 2007 at 7:47 am