Thank you Minty!
A lot of code here.
I think that there should be better way of doing it, i am trying with:
Code:
Create Proc spUseParameter
@PESEL varchar (20),
@Person_ID varchar (20),
--@Nazwisko_Imie varchar (20),
@Company_NIP varchar (20),
@Company_name varchar (20),
@Company_shortcut varchar (20)
AS
BEGIN
SELECT
[UniqueID]
,[Data_Zmiany]
,[PESEL]
,[Person_ID]
,[Nazwisko]
,[Imie]
,[Department]
,[Company_NIP]
,[Company_name]
,[Company_shortcut]
,[System_source]
FROM [SODY].[dbo].[tbl_Slownik]
WHERE (PESEL Like '%' + @PESEL + '%' or @PESEL = '%' + Null + '%')
AND (Person_ID Like '%' + @Person_ID + '%' or @Person_ID = '%' + Null + '%')
--AND (Nazwisko_Imie Like '%' + @Nazwisko_Imie + '%' or @Nazwisko_Imie is Null)
AND (Company_NIP Like '%' + @Company_NIP + '%' or @Company_NIP = '%' + Null + '%')
AND (Company_name Like '%' + @Company_name + '%' or @Company_name = '%' + Null + '%')
AND (Company_shortcut Like '%' + @Company_shortcut + '%' or @Company_shortcut = '%' + Null + '%')
END
And now:
Code:
spUseParameter '87031604634', Null,Null, Null, Null
Working!
Code:
spUseParameter '87061604634','','','',''
Not working !
Jacek