SQL Lion

CREATE TABLE [dbo].[Employees](
	[EmployeeName] [VARCHAR](50) NULL,
	[DeptName] [VARCHAR](50) NULL
) ON [PRIMARY]

DECLARE  @emptemp  TABLE
(
	[EmployeeName]  VARCHAR(50)
	,[DeptName] VARCHAR(50)
)
 
DECLARE @dept INT
DECLARE @employee INT
SET @dept = 65
SET @employee = 70
 
WHILE @dept < 70
BEGIN
	WHILE @employee < 90
	BEGIN
		INSERT INTO @emptemp
				   ([EmployeeName]
				   ,[DeptName])
			 VALUES( CHAR(@employee), CHAR(@dept) + CHAR(@dept + 1) )
 
		SET @employee = @employee + 1
	END 
 
	SET @employee = 70
	SET @dept = @dept + 1
END   
 
INSERT INTO [dbo].[Employees]
           ([EmployeeName]
           ,[DeptName])
   SELECT [EmployeeName]
           ,[DeptName] FROM @emptemp
 
SELECT * FROM dbo.Employees

/*
The below script will show random 10 records from each department from Employees table.
*/
 
DECLARE @deptColumn VARCHAR(50)
--For creation of a temporary table with no data.
SELECT * INTO #temporaryT
FROM dbo.Employees WHERE 1=2
 
DECLARE UserCursor CURSOR FOR
SELECT DISTINCT DeptName FROM dbo.Employees
 
OPEN UserCursor
FETCH NEXT FROM UserCursor
INTO @deptColumn
 
WHILE @@FETCH_STATUS = 0
BEGIN
 
	INSERT INTO #temporaryT
	SELECT TOP 10 * FROM dbo.Employees WHERE DeptName = @deptColumn
		ORDER BY NEWID()  --newid() for random records
 
	FETCH NEXT FROM UserCursor
	INTO @deptColumn
END
 
CLOSE UserCursor
DEALLOCATE UserCursor
 
SELECT * FROM #temporaryT ORDER BY DeptName
DROP TABLE #temporaryT

SELECT DeptName,EmployeeName  FROM
(SELECT
ROW_NUMBER() OVER(PARTITION BY DeptName ORDER BY newid() ) AS RowID
, * FROM dbo.Employees ) InnerQ
WHERE InnerQ.RowID <= 10
--RANK() can also be used instead of ROW_NUMBER()

WITH distinctDepts AS
(SELECT DISTINCT DeptName FROM dbo.Employees)
 
SELECT InnerQ.* FROM distinctDepts  d
CROSS APPLY
(SELECT TOP 10 * FROM dbo.Employees
	WHERE DeptName = d.DeptName
ORDER BY newid()) InnerQ