Sql Script for blank values

Maahi

9y906

I have uploaded a bulk data having 20 columns.

in SQL am trying to bind 3 column join against the employee master.

For Example

select * from #temptable

select tmp.*

from #temptable tmp , employeemaster em

where em.employeeno= tmp.Employeeno1 and

em.employeeno= tmp.Employeeno2 and

em.employeeno= tmp.Employeeno3

the above query will return records if all the condtion are matched in the where clause.

But lets say am passing the value only for tmp.Employeeno1 =123 and tmp.Employeeno2=456

and tmp.Employeeno3 as empty record.

Its a valid records how can i allow it in my script using blank or null values.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel9y ago
Or you can just modify your query to use Joins and remove the condition checks from query and let server handle it.
Instead of employee ids as column, you can store them in rows in #tempTable and rest should work as shown in below query.
select  tmp.*
from employeemaster em
left outer join #temptable tmp on em.employeeno= tmp.Employeeno
where em.employeeno
in(
select distinct Employeeno from #temptable
)
0
Amit Gupta9y ago
If you want to validate one among of 3 condition then use OR operator instead of AND
0