Hi ,

with your second query using openquery give me solution for using paramerter

my query is something like this.

declare @birthdate varchar(8)

set @birthdate = CONVERT (varchar (8), DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()),...