Search results for query: *

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

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/

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

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

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

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