Hi Luiz,

I have two tables[transactions table and Header table] and merging them make one table [Grand Table] , along with that I need to add few more column with few...

Hi Luiz,

I am really thankful for your conversion script, can you suggest me, based on this function logic, I need to add extra columns in SSIS, could you tell...

Hi Nevyn,

I am glad for your reply, I would happily to share the scope the project but at the moment the company haven't explained to me itself, all I need...

Hi Sir,

Your code helped to create full stored procedure.

This is the script I have wrote.

CREATE PROCEDURE SP_STAT_CURR

(

@I_NET_AMOUNT NUMERIC(10,3),

@I_DOCUMENT_CURR VARCHAR(3),

@I_TARGET_CURR VARCHAR(3)

)

AS

BEGIN

IF (@I_TARGET_CURR = @I_DOCUMENT_CURR)

BEGIN

SELECT @I_NET_AMOUNT AS O_TARGET_CURR...

Hi Jim,

I really appreciate your gesture of helping sign. I am using script to built the required Function.

Many Thanks.

I have created this function get USD exchange rate from currency exchange tabe( The table gives all countries exchange rate with respect to USA)

CREATE FUNCTION [dbo].[CurrencyRate] (@Currency AS varchar(3))

RETURNS numeric(15,...

Hi Jason,

Your script nearly satisfies the two cases, but I need it as function or store procedure to satisfy all the 4 cases. I am glad for your script.

Hi dwain,

We don't update currency exchange rate daily or monthly, it's a fixed table with standard exchange rate, our company will update the exchange table if there is...

Hi dwain,

We don't update currency exchange rate daily or monthly, it's a fixed table with standard exchange rate, our company will update the exchange table if there is...

I don't have access to my company Computer. Yeah the function works. I gave function name as fn_USD_currency converter.

I have created a function which gives country list and exchange rate with respect to USD.

COUNTRY RATE

INR ...

The Table at the moment we had in the database.

CREATE TABLE [dbo].[Dim_Date](

[DateKey] [date] NULL,

[CalendarDate] [date] NULL,

[CalendarYear] [int] NULL,

[CalendarQuarter] [varchar](10) NULL,

[CalendarMonth] [varchar](10) NULL,

[CalendarWeek] [varchar](10) NULL,

[CalendarQuarterStartDate] [date] NULL,

[CalendarQuarterEndDate] [date] NULL,

[CalendarHalfYearlyStartdate] [date] NULL,

[CalendarHalfYearlyEndDate]...

Hi,

We haven't created standard holiday table yet,

The function

create function [dbo].[ufn_NextBusinessDay]

(

@startdate date,

@numdays int

)

returns date

as

begin

declare

@nextBusday date,

@weekday int

set @nextBusday = @startdate

declare @dayloop int

set @dayloop = 0

while @dayloop < @numdays

begin

set @nextBusday...

Hi,

I am glad for your detailed explanation, I will try to implement asap and let you know the success rate on this.

Many Thanks

NA