[belajar-access] select field di udf/stored procedure dengan menggunakan variable

 

Dear agan-agan, suhu-suhu,

kumaha daramang selamat berjumpa kembali dengan aq.

mau nanya-nanya nih maklum udah lama nggak ngoding,

 

saya buat coding seperti dibawah, saya ingin buat udf/stored procedure di sql server 2008 yg dinamis dalam menentukan fieldnya, yaitu dengan menggunakan variabel.

namun ada kendala dalam clause wherenya, kalau type fieldnya selain dari string bermasalah;

kira-kira kurangnya dimana ya?

 

salam,

 

Andria

 

create FUNCTION [dbo].[udfCurrencyAlternate] (@Currency nvarchar(10),@Date datetime,@Price float,@CurrAlt varchar(3))

RETURNS

float AS

BEGIN

declare @curRate float

declare @udfCurrency float

declare @CurrField varchar(4)

declare @KursID int

declare @Sql varchar(100)

set @CurrField=(select cField from dbo.tblCurrency where cID=@Currency)

set @KursID=(select cID from dbo.tblKurs where cDateStart<=@Date and cDateFinish>=@Date)

set @Sql='Select '+@CurrField+ ' from tblKurs where cID='+ convert(varchar,@KursID)

---/ tadinya disini pengen langsung aja seperti ini set @Sql='Select '+@CurrField+ ' from tblKurs where cDateStart<='+@Date+' and cDateFinish>='+@Date

jadi nggak perlu set @KursID, cuma nggak keluar hasilnya (filternya nggak ke detect)

if @CurrAlt=@Currency

begin

set @curRate=1

end

else

set @curRate=convert(int,@Sql)

Return

(@Price/@curRate)

END

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___