Not yet. I'm not back in the office until Monday 🙂

I was thinking the same and...

Just to be sure,...

Just to be sure, my solution...

I was thinking the same and there are...

This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I...

This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I can guarantee...

This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I can guarantee the...

This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I can guarantee the data. Even...

• This reply was modified 5 years, 8 months ago by David Burrows.

OK, so what was the "silly" fix you employed?

I'll also state that it's a shame that...

Not me, back at work and getting some things done here today.

Enjoy the holiday, and be safe. My daughter had surgery last week, so we're still helping her...

My post was in jest 🙂

But agree with your post, I have a proc that calls several procs in a specific order with some logic to decide whether to call...

You said cursor, wash your mouth out and say three Hail Marys to repent :-/

This maybe due to mixed data types and if grade levels is numeric then this would be the case. You could try to make all sort values character and add...

In yours it is 'Group by', click in the fx button to show the expression box and use something like this

=Choose(Parameters!SortParam.Value+1,
Fields!StudentName,
Fields!Grade,
Fields!Team,
Fields!Teacher,
Fields!HomeroomNumber
)