example - sql query -

select price as Price,dbo.fnGetFExc(getdate(),'US$',0,'General') as FExc, price*dbo.fnGetFExc(getdate(),'US$',0,'General') as F.Price

from sales

function is select column, due to i need function use (database name variable)

thank you..

example - sql query -

select price as Price,dbo.fnGetFExc(getdate(),'US$',0,'General') as FExc, price*dbo.fnGetFExc(getdate(),'US$',0,'General') as F.Price

from sales

function is select column, due to i need function use (database name variable)

thank you..

thank you ,

but, may be 1000 database in SQL Server and database name i don't know...

date is parameter use, but databasename is not parameters use..

thank you john

thank you John,

but is not work

--- function example -- (executesql)

CREATE FUNCTION fnGetFexc(@exchange varchar(5),@dbname varchar(30)) RETURNS float AS

BEGIN

DECLARE @rate float ,@Sql varchar

set @rate=0

set @sql=N'select top 1...