That's the reason I attached the screen-shots)))))

after all, it might be not actually executing those loops but doing some kind of validation there... whatever, it still shows greens and number...

That would explain it... From that post it seems to me though, Jeff was rather llustrating use of a non-deterministic function in CASE...

Hi Kevin,

I do not currently have permissions to look at the exec plan, and using searched seems to be faster - just a bit but consistently - than simple one...

Hi,

Would be interesting to see if anyone knows how to handle that kind of things... I have exactly the same scenario with the exactly flip-flopped results though:

- SSIS task runs...

Looks like reinstalling SP3 took care of it.

Read

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/0fb52353-3b54-4ece-99d7-4fd187ca000d

So it's probably the order of installing, like in the article... Not sure, but it seems to be fixed and showing

Thanks so much for replying. Unfortunately it does not seem to be a case here since I do not even have SQL 2008 installed, 2005 only. Any other thoughts? Thanks...

How about implementing a data-driven subscription then?

If I understand your question right, you'll just have to use an appropriate query in Step 3 and then use its field...

Hi Siva,

That did the trick, thank you!

Ok, the question is still there, and here comes another one.

I am currently returning those Num of Subs in a group as fields in a query, where the query looks...

Jack,

The record's unique key consists from two fields, GroupCode & SubgroupCode

The report would look like below:

GROUP 1

........Subgroup 11

...................10.00

...................20.00

...................====

...................30.00

........Subgroup 13

...................30.00

...................====

...................30.00

.....Number of Subgroups in Group: 2

GROUP 2

........Subgroup 21

...................40.00

...................====

...................40.00

........Subgroup 22

...................50.00

...................55.00

...................====

................. 105.00

........Subgroup 23

...................56.00

...................====

..................56.00

.....Number of...

Thanks Jack, but totaling Net at the group/subgroup level is not a problem, sorry if I did not explain it well.

My question is if there is a way of showing...

lol, nevermind it too)))))))))))))

Yes, but can you - or anyone - share your wisdom?

Let's say there is a table like below

KeyField..............DescField

1....................... 'A'

1....................... 'B'

1....................... 'C'

2.......................'D'

2.......................'E'

2.......................'F'

and I need a single select returning

1.........'A,B,C'

2.........'D,E,F'

?

Thank you

Thanks!

The reason was even simpler, it was using a global temporary table dropping if already exists first, and then recreating etc. Changing to use a local one instead seems to...

Using Latin1_General_BIN seems to make a trick

Thank you