asked on
CROSS APPLY Issue
Not much experience with CROSS APPLY. Running into an issue LEFT JOIN would generally resolve, though not applicable here.
select
t.refID
z.dataPiece
from
MyDataTable t
CROSS APPLY myFunction(t.refID) z
t.refID may not always be what myFunction expects or is null, therefore those t.records are dropped. So if there's 100 records in MyDataTable, only 90 may result. I can't arbitrarily change t.refID if NULL or not the expected combination of characters (It's a vehicle's VIN btw). I also can't change the function to deal with it, as its used in other applications. Ideally the function would simply return NULL as a JOIN would. Thanks in advance for any assistance.
select
t.refID
z.dataPiece
from
MyDataTable t
CROSS APPLY myFunction(t.refID) z
t.refID may not always be what myFunction expects or is null, therefore those t.records are dropped. So if there's 100 records in MyDataTable, only 90 may result. I can't arbitrarily change t.refID if NULL or not the expected combination of characters (It's a vehicle's VIN btw). I also can't change the function to deal with it, as its used in other applications. Ideally the function would simply return NULL as a JOIN would. Thanks in advance for any assistance.
Microsoft SQL ServerSQL
Last Comment
Rickzzz
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Vitor - thanks for the input.
ASKER
Thanks!
Open in new window