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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. yaanmonkey

    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...
  2. yaanmonkey

    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...
  3. yaanmonkey

    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...
  4. yaanmonkey

    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...

Part and Inventory Search

Back
Top