Execute function multiple times without using a loop

Question

I have a simple table with IDs:

ObjectId
----------
100
101
102

I'd would like to execute a function fn_GetStuff(Id) multiple times like this:

fn_GetStuff(100)
fn_GetStuff(101)
fn_GetStuff(102)

Is it possible to do this without using a loop?

I tried this it doesn't work:

SELECT *
FROM myTable
INNER JOIN fn_GetStuff(myTable.ObjectId)

You need to put the schema in front of the function. This is a requirement. There are two types of answers below, one is for scalar functions and the other is for in-line table valued functions. One of them is right, but make sure to append the schema in all cases. — Eric J. Price
– Eric J. Price, Commented Mar 20, 2013 at 15:35

Eric J. Price · Accepted Answer · 2013-03-20 15:32:46Z

6

OP is using a in-line table valued function it looks like so they would need a CROSS APPLY...

Select  *
From    myTable mt
Cross   Apply schema.fn_GetStuff(mt.ObjectID) f

answered Mar 20, 2013 at 15:32

Eric J. Price

2,7851 gold badge17 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2013-03-20 15:31:54Z

2

Assuming your function is a scalar-valued function, you can just do:

select fn_GetStuff(Objectid)
from myTable

If your function is table valued, then you would need to use cross apply.

answered Mar 20, 2013 at 15:31

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

LukeHennerley · Accepted Answer · 2013-03-20 15:32:05Z

0

You don't need to join because there isn't another table. You should be okay to do this:

SELECT fn_GetSTuff(t.ObjectId)
FROM myTable t

answered Mar 20, 2013 at 15:32

LukeHennerley

6,4542 gold badges34 silver badges51 bronze badges