OK

CREATE TABLE my_table (col1 nvarchar(25) NULL, bit_flag nvarchar(3) NULL)

INSERT INTO my_table VALUES('A', '100'), ('A', '001'),('B', '010'),('A', '001');

expected output from query :

A 101

B 011

The bit_flag column contains 12 flag (and is...

I be happy to use the built in T-SQL functions if that is possible.

But the function needs to work as an aggregate function.

I have to be able to execute queries...

And I need to use a destination table so that would not fix the insert statement.

I am using a SQL command but SSIS changes the statement (I have captured the statement from a trace).