You can use MERGE clause:

MERGE INTO aaa a

USING(

SELECT id_aa ,

id_bb

FROM bbb

)e

ON(a.id_a =e.id_aa)

WHEN MATCHED THEN

...

davidadlington78 - maybe next article will be about this.

OldFashionGang - Thank you for your comment. Next time I will try to choose a better title

In T-SQL, you cannot modify any data in a function. There is no straightforward way around it. There are some obscure hacks, but I would not use them.

Example:

CREATE FUNCTION...

Create procedure on your database:

CREATE PROC __FindText

@query varchar(100)

AS

SELECT DISTINCT name, type

FROM sysobjects so INNER JOIN syscomments sc ON so.id =...

You can use SUMMARIZE:

EVALUATE

SUMMARIZE (

'Transactions',

'Transactions'[Salesman],

"Trans. value by Salesman", SUM('Transactions'[Trans_value])

)

BCP would be fastest option. To import to a table you can use OPENROWSET with ot without BULK option.