hy
i decided to write this on ole db foxpro source
SET FMTONLY OFF
exec [servername].[db].[dbo].[getWeekNumber]
this is the sp:
alter procedure getWeekNumber
as
begin
declare @weekNum nvarchar(100)
select @weekNum = convert(nvarchar(10),weekNum) from [server].[db].[dbo].[tblWeekMetadata]
where GETDATE() between fdate and tdate
set @weekNum ='select * from w' +@weekNum
end
but i get this error
command contain unrecognized pharse/keywordany suggestion?