Do you know any function or trick to make a string field concatenation (without a very-very-very-slow while/if-goto loop)?
e.g.: something like sum(<varchar field>) with a group by
(i'll be happier if it works with sql7).
I'm wondering why SQL designers allow MAX(varchar) or MIN or COUNT b.u.t. SUM().
Aren't they supposed to work with data? (mainly "string" data!?)
There are a lot of situations where I need to create a variable-size string based in queries & subqueries...
You actually solve the main case, I think I must forget optimizations and create temporary tables to work with variables.
My worst case scenario is a cursor-like lookup, when sql7 scalar variables are not able to concatenate subqueried values without a very slow loop.
Do you know where can I send a "suggestion" to MS Sql designers?