Micah
4Penny.net
Points: 7059

12/22/2016 1:03:39 PM

dd_UPR00100_SEL_cbo

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

This is a stored procedure that returns EmployID and the Full Name (both last name and first name first), and is sorted by a parameter.

Using a variable to sort a SQL statement is an unusual technique, the statement is work studying just for that.

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3