Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by atilley
-
Allocate a numerical order to data
If the number of tiers is fixed, I think you're going to need to join the table to itself for the number of tiers you have. Like this: SELECT lev0.PK, lev0.Name, lev0.DisplayOrder, lev1.PK, lev1.Name, lev1.DisplayOrder, lev2.PK, lev2.Name, lev2.DisplayOrder from ( SELECT * FROM TIER WHERE...- atilley
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure Quotes Issue
At the end of the proc where you're building the WHERE clause, you need to put quotes back onto @strAssignedRecruiter in order to use it in your built SQL statement. This should do it: SET @strWhere = @strWhere + ' AND tblJobRequisitions.strAssignedRecruiter = ''' + @strAssignedRecruiter + ''''- atilley
- Post #15
- Forum: Microsoft SQL Server: Programming
