Thanks CELKO.

You are right. ISO 4217 currency codes look up is the best option to use.

Thanks again.

Perfect !.. thanks.Dont mind I am not familer with SQL..

select ISNULL(ts_Countries.CountryName, 'Unknown Country') as Country,

case when ts_Countries.CountryName = 'United Kingdom' then CONVERT(varchar(12), CostLocal, 1) + '£'

else ''

end,

Can we have a coulmn here instead of...

Thanks very much. it is very much useful stuff.I will test with table variable.

I have 45 countrries in table.

Here is my query snippet..i did changed as for my reqs.

select

ISNULL(ts_Countries.CountryName,...

Thanks a lot. switch case is working fine.But the excuetion time is high...

Yes.Right but that leads to be lot changes required in the DB and application side.

This report query just out of the application.

Thanks. you made my day mate!

Thanks!. I got it.I got the results .

Yes. I am very new to write sql queries.

I will try get understand your queries..Thanks for your time.

Thanks!

When i am modifying your query like below. I am getting zero rows.

Please can you check my query.

DECLARE @ts_vSignOffStatus AS TABLE(

[RequestID] INT,

[ApproveLevelName] VARCHAR(35))

--Now to the query

;WITH cte ( [RequestID], [Approval...

Please see my details below in bold text

DECLARE @TABLE AS TABLE(

[RequestID] INT,

[ApprovalName] VARCHAR(35))

INSERT INTO @TABLE([RequestID],[ApprovalName])

--- the below sample data i want query , i wnat use for tables...

Hi,

I have last question, how can i make this query for dynamic data instead of sample static data.

ex: select the rows from the table.

Thanks again..

Hi,

I want write one more select query like below:

I have written below query to get the total of each indicual items with same RequestID(requestitemsID are different)

select

(ts_a.CostLocal * ts_a.Qty)*(ts_b.ExchangeRate))...

Thanks a lot!! ..much appriciated for your help..its perfect..