-----start-----
SELECT * INTO [Sample_Intersect_Function_Phone1]
FROM
(
SELECT Customer_Number FROM [Sample_Intersect_Function]
WHERE phone1<>''
) A
SELECT * INTO [Sample_Intersect_Function_Phone2]
FROM
(
SELECT Customer_Number FROM [Sample_Intersect_Function]
WHERE phone2<>''
) N
-----end-----
Query - 1:
-----start-----
SELECT * FROM Sample_Intersect_Function_Phone1
INTERSECT
SELECT * FROM Sample_Intersect_Function_Phone2
-----end-----
Query - 2:
-----start-----
SELECT * FROM Sample_Intersect_Function_Phone2
INTERSECT
SELECT * FROM Sample_Intersect_Function_Phone1
-----end-----
About :
01 - Create Function with Return Table in SQL Server
02 - Syntax : CREATE FUNCTION - Return Table - With Parameters
03 - Example of Create Function in SQL with Returns Value
04 - Example of Create Function (No Parameter) in SQL with Returns Value
05 - How to Use Function Intersect
06 - How to Use Function Except