question

KatiS avatar image
KatiS asked

Using function in select

I have this select Select * from test t1 left join dbo.ft_BO_Allowances(t1.code,@REP_START,@REP_END) test2 on test2.code=t1.code I get error message The multi-part identifier "t1.code" could not be bound Would you please help me to fix this Thank you
sqlselectfunction
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DenisT avatar image
DenisT answered
Have you tried OUTER APPLY instead?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KatiS avatar image KatiS commented ·
Thank you. It works now
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.