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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: yaanmonkey
- Content: Threads
- Order by date
-
SQL Server Ordered Append Syntax
Hi, I am looking for a solution to this problem: I would like to create a stored proc that will accept certain criteria parameters (E.g. Letter from... Where LastName >=@LetterFrom or similar). I also need to be able to specify the TOP 'x' number of rows depending on a user entered...- yaanmonkey
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Order By in SQL Update Stored Proc
Hi, i have an ASP.net page that has a gridview where the source is: set rowcount @Top SELECT ID, Title, FirstName, Surname, FROM Leads_Source WHERE (ISNULL(Surname, '') LIKE @Surname + '%') AND (ISNULL(County, '') LIKE @County + '%') AND (ISNULL(Postcode, '') LIKE...- yaanmonkey
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
