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!

Recent content by sqlprograms

  1. sqlprograms

    Joining Fields From 2 tables with Similiar Data

    Try this script, SELECT T_Client_FTD_Log.MessageText FROM T_Client_FTD_Log WHERE T_Client_FTD_Log.MessageText LIKE '%z253\motor\sy\253AG2161\cmd\msk_flt_tmp%' AND T_Client_FTD_Log.MessageText LIKE '%'+ (SELECT trc_tags.Col002 FROM...
  2. sqlprograms

    Basic XML question

    Hi, I have a blog article to maybe assist you with your question: http://www.sql-programmers.com/Blog/tabid/153/EntryId/10/XML-Data-Type-in-SQL-Server-2005.aspx SQL Server Programmers http://www.sql-programmers.com/
  3. sqlprograms

    conversion error varchar to int in SQL2005

    Since the field attrid is a varchar value, you might need to include single quote characters when trying to see if the attrid field equals a certain value. For example, in the value below notice the single quote characters surrounding the 1 value. case attrid when '1' THEN 'comment1' else 0...
  4. sqlprograms

    Qry Update in a form

    The error "The data was added to the database but the data won't be displayed in the form becuase it doesn't satisfy the criteria in the underlying record source" mostly occurs when the Server Filter or Filter is saved in the form, This is happens while you are opening a form using a filter...
  5. sqlprograms

    Subtract from alphanumeric string value

    Try this one, DECLARE @Temp TABLE (ID VARCHAR(50),Type VARCHAR(50)) INSERT INTO @Temp VALUES ('BD001','BD') INSERT INTO @Temp VALUES ('BD002','BD') INSERT INTO @Temp VALUES ('BD003','BD') INSERT INTO @Temp VALUES ('BD004','BD') INSERT INTO @Temp VALUES ('BD005','BD') INSERT INTO @Temp VALUES...
  6. sqlprograms

    Dynamic File and Path on Bulk Insert

    Pass the FileName as parameter and dynamically build the sql query. declare @FileName as varchar(300) set @FileName='C:\AB1000\123.pdf' declare @SQLQuery as varchar(max) set @SQLQuery='insert into Image_Table ( Customer, Invoice_Number, Document ) select...
See more

Part and Inventory Search

Back
Top