ALTER PROCEDURE [dbo].[Stat] @city nvarchar(50), @company nvarchar(50), @lastname nvarchar(50) AS SELECT DISTINCT s.Lastname, s.Firstname, s.Fathername + ' ' + s.Lastname AS Fname, s.Birthday, s.City, s.Phone, s.Cellphone, s.Company, s.Mothername + ' ' + s.Mlname AS Mname, s.ID, s.Cbirth , i.TK , i.Name FROM Staff s INNER JOIN dbo.Settings i on s.StaffID=i.ID WHERE (((s.City)=@city) AND ((s.Company)=@company)) AND ((s.Lastname)=@lastname) Return
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)