Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Sql Script for blank values
Maahi
Sep 9 2017 3:48 AM
164
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Installing SQL Server 2012 Express using bootstrapperpackage
How to get which Saturday, Sunday today is in current month