DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
SITE SEARCH SQLUSA.com HEADLINES NEWS
SQL E/BOOKS  SQL 2012 PROGRAMMING  DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
How to use expression with the TOP clause?

Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to find employees with the TOP 10% hourly compensation rates:

-- T-SQL SELECT with TOP expression

USE AdventureWorks

GO

 

DECLARE  @factor1 INT,

         @factor2 INT;

 

SET @factor1 = 2; SET @factor2 = 5;

 

SELECT   TOP ( @factor1 * @factor2 ) PERCENT WITH TIES Name = c.LastName + ', '+

                                                       c.FirstName,

                                                       e.Title,

                                                       Department = d.[Name],

                                                       Gender

FROM     HumanResources.Department d

         INNER JOIN HumanResources.EmployeeDepartmentHistory edh

           ON edh.DepartmentID = d.DepartmentID

              AND edh.EndDate IS NULL

         INNER JOIN HumanResources.Employee e

           ON edh.EmployeeID = e.EmployeeID

         INNER JOIN Person.Contact c

           ON e.ContactID = c.ContactID

ORDER BY Name DESC

 

GO

/*

Name                    Title                         Department  Gender

Zwilling, Michael       Production Technician - WC60  Production  M

Zimmerman, Kimberly     Production Technician - WC10  Production  F

Zabokritski, Eugene     Production Technician - WC30  Production  M

Yukish, Gary            Production Technician - WC40  Production  M

Yu, Nuan                Production Technician - WC50  Production  M

Young, Garrett          Production Technician - WC30  Production  M

Yalovsky, David         Production Technician - WC30  Production  M

.....

*/


 

Exam Prep 70-461
Exam 70-461
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE