datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS
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