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 Mike Lewis 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
- Order by date
-
Trimming varchar(255)
This should return just the numeric: SELECT SUBSTRING('Filler Order ID: <10190968MMDSCR> Filler Facility ID: <RAD>',CHARINDEX('<','Filler Order ID: <10190968MMDSCR> Filler Facility ID: <RAD>')+1,CHARINDEX('>','Filler Order ID: <10190968MMDSCR> Filler Facility ID: <RAD>')-CHARINDEX('<','Filler...- yaanmonkey
- Post #8
- Forum: Microsoft SQL Server: Programming
-
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
Thanks bborisov, That was because i cut out some of the fields in the select statement to keep it smaller on the post. The select works fine, it is only when i come to use similar syntax and use: SET AssignedTo=@AssignedTo (Passed to the stored proc) that SQL says there is a problem with the...- yaanmonkey
- Post #3
- 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
