Multiple fields | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Multiple fields

I am using all text boxes for my sql report, i am able to display 1 value for each field, how can I display multiple values for a single field?
For example report shud be in this way
ActNo DeptNo Amount
01 203 3456
Can any one has any idea about it. Thanks!
Do you want concatenation?
Post some sample data and the result you want Madhivanan Failing to plan is Planning to fail