Hi Forum MemberI am Trying to converting data type varchar to datetime in sqlserver 2005. but it will not working..my Actual Procedure is USE [AFMS]GO/****** Object: StoredProcedure [dbo].[SelectAll_ExpenseDetails] Script Date: 01/05/2012 17:37:59 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: Created By Archana-- Create date: 09-12-2011-- Description: <Description,,>-- =============================================ALTER PROCEDURE [dbo].[SelectAll_ExpenseDetails]@LNK_File_ID numeric(18, 0) = NULL,@LNK_Client_ID numeric(18, 0) = NULL,@ExpanseDate datetime = NULLASBEGINSET NOCOUNT ON; SELECT E.[ExpanseId] ,CONVERT(datetime,E.[ExpanseDate],103) as [ExpanseDate] ,E.[Amount] ,E.[LNK_File_ID] ,E.[LNK_SubFile_ID] ,E.[LNK_CreatedBy_ID] ,CONVERT(datetime,E.[CreatedOn],103) as [CreatedOn] ,c.Client_FirstName as ClientName ,f.FileNo ,f.FileName FROM [AFMS].[dbo].[Expanse] E JOIN [AFMS].[dbo].[Client] c on c.ClientId = E.[LNK_CreatedBy_ID] JOIN [AFMS].[dbo].[File] f on f.FileId = E.[LNK_File_ID] JOIN [AFMS].[dbo].[SubFile] sf on sf.SubFileId = E.[LNK_SubFile_ID]Where E.LNK_File_ID = Case when @LNK_File_ID IS NOT NULL THEN @LNK_File_ID Else E.LNK_File_ID End and E.[LNK_CreatedBy_ID]= Case when @LNK_Client_ID IS NOT NULL THEN @LNK_Client_ID Else E.[LNK_CreatedBy_ID] End and E.[ExpanseDate]= Case when @ExpanseDate IS NOT NULL THEN @ExpanseDate Else E.[ExpanseDate] EndEnd
Execute Procedureexec [SelectAll_ExpenseDetails] @LNK_File_ID = null, @LNK_Client_ID = null,@ExpanseDate = '29/12/2011'
Error is Msg 8114, Level 16, State 5, Procedure SelectAll_ExpenseDetails, Line 0Error converting data type varchar to datetime.
Archana MistrySr. ProgrammerKintudesigns.com