I am getting a SQLcode of +1 in my query which is given below. I have to find the reason of the warning. Any help? EXEC SQL SELECT DATEDIFF(d,getdate(),DUE_DATE) ,getdate(),DUE_DATE INTO :WS-DATE-DIFFERENCE, :WS-RETURN-DATE,:WS-DUE-DATE FROM LIB_TRANSACT WHERE MEM_ID=:WS-MEMID AND BOOK_ID=:WS-BOOKID AND RETURN_DATE IS NULL END-EXEC This is the query. Arun Kumar, BAngalore
Are you trying to map the results as XML? Are you using SQLCLR? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.