Create stored procedure to show employee details as per filtered range in sql

Axapta Code solutions Education and Entertainments Earn Money its Real Experience of knowledge Imortant Weblink collections Fun and Entertainment God thoughts Get Ways to Invest your money Products overview and details
Create stored procedure to show employee details as per filtered range in sql

SET ANSI_NULLS ON
Go
SET QUOTED_IDENTIFIER ON
Go CREATE PROCEDURE spx_GetEMploye
@Filter VARCHAR(50) AS BEGIN
SET NOCOUNT ON;
IF @Filter = 'ALL'
SELECT ContactName, City, Country, PostalCode FROM Employee
ELSE IF @Filter = '10'
SELECT TOP 10 ContactName, City, Country, PostalCode FROM Employee
ELSE SELECT ContactName, City, Country, PostalCode FROM Employee WHERE mailto:Country=@Filter
END GO