CREATE function [dbo].[terjemahkan] (@nilai as decimal)
returns varchar(200) as
begin
/****************************************************************
created by zimmy gurning - 08 agustus 2004…begadang lg euy….pdhal mau tujuhbelasan neh..
fungsi ini untuk nerjemahin huruf
parameter input:
1. angka masukan dari fungsi terbilang
*****************************************************************/
declare @ts varchar(200), @st varchar(200), @s integer, @p integer, @r1 integer, @bil varchar(200), @tp varchar(200), @hasil varchar(200)
set @st = right(rtrim(str(@nilai + 1000)), 3)
set @s = cast(right(@st, 1) as integer)
set @p = cast(substring(@st, 2, 1) as integer)
set @r1 = cast(left(@st, 1) as integer)
set @bil = ’satu    dua     tiga    empat   lima    ‘
set @bil = @bil + ‘enam    tujuh   delapan sembilan’

if @s = 0
set @ts = ”
else
set @ts = rtrim(substring(@bil, @s * 8 - 7, 8)) + ‘ ‘

if @p = 0
set @tp = @ts
else
if @p = 1
if @s = 0
set @tp = ’sepuluh ‘
else
if @s = 1
set @tp = ’sebelas ‘
else
set @tp = rtrim(substring(@bil, @s * 8 - 7, 8)) + ‘ belas ‘

else
set @tp = rtrim(substring(@bil, @p * 8 - 7, 8)) + ‘ puluh ‘ + @ts

if @r1 = 0
set @hasil = @tp
else
if @r1 = 1
set @hasil = ’seratus ‘ + @tp
else
set @hasil = rtrim(substring(@bil, @r1 * 8 - 7, 8)) + ‘ ratus ‘ + @tp

return @hasil
end
go

CREATE function [dbo].[f_terbilang] (@angka as decimal(19,2))
returns varchar (200) as
begin
/****************************************************************
created by zimmy gurning - 08 agustus 2004…begadang lg euy….pdhal mau tujuhbelasan neh..
fungsi ini untuk gen terbilang
parameter input:
1. angka masukan
*****************************************************************/
declare @b decimal, @r decimal, @j decimal, @m decimal, @t1 decimal, @koma1 decimal, @koma2 integer, @hasil varchar(200)
declare @s_t varchar(200), @ribu varchar(200), @juta varchar(200), @miliar varchar(200), @tx varchar(200), @angka1 varchar(200), @tx1 varchar(200)
set @s_t = case when len(rtrim(cast(cast(@angka as bigint) as varchar(20)))) < 15
then replicate(’0′,15 - len(rtrim(cast(cast(@angka as bigint) as varchar(20))))) + rtrim(cast(cast(@angka as bigint) as varchar(20)))
else rtrim(cast(cast(@angka as bigint) as varchar(20)))
end
–set @z = cast(15 - len(rtrim(cast(cast(@angka as integer) as varchar(20)))) as varchar(20))
–+ rtrim(cast(cast(@angka as integer) as varchar(20)))
set @r = cast(right(@s_t, 3) as integer)
set @b = cast(substring(@s_t, 10, 3)  as integer)
set @j = cast(substring(@s_t, 7, 3)  as integer)
set @m = cast(substring(@s_t, 4, 3)  as integer)
set @t1 = cast(left(@s_t, 3)  as integer)
set @ribu = case when @b = 0 then ‘ ‘ else case when @b = 1 then ’seribu’ else [dbo].terjemahkan(@b) + ‘ribu’ end end
set @juta = case when @j = 0 then ‘ ‘ else [dbo].terjemahkan(@j) + ‘juta ‘ end
set @miliar = case when @m = 0 then ‘ ‘ else [dbo].terjemahkan(@m) + ‘miliar’ end
set @tx = case
when @angka < 1000 — ratusan
then [dbo].terjemahkan(@r)
when @angka < 1000000 — ribuan
then @ribu + ‘ ‘ + [dbo].terjemahkan(@r)
when @angka < 1000000000 — jutaan
then [dbo].terjemahkan(@j) + ” + rtrim(’juta ‘ + @ribu) + ‘ ‘ + [dbo].terjemahkan(@r)
when @angka < 1000000000000 — miliaran
then [dbo].terjemahkan(@m) + ” + rtrim(’miliar ‘ + @juta + @ribu) + ‘ ‘ + [dbo].terjemahkan(@r)
when @angka >= 1000000000000 — trilliun
then [dbo].terjemahkan(@t1) + ” + rtrim(’trilliun ‘ + @miliar + @juta + @ribu) + ‘ ‘ + [dbo].terjemahkan(@r)
end
set @angka1 = rtrim(cast(@angka as varchar(20)))
set @koma1 = case when charindex(’.', @angka1) = 0 then 0 else cast(rtrim(substring(@angka1, charindex(’.',@angka1) + 1, 2)) as integer) end
set @koma2 = len(case when charindex(’.',@angka1) = 0 then ‘0′ else rtrim(substring(@angka1, charindex(’.',@angka1) + 1, 2)) end)
if @koma1 > 0
begin
if @koma1 < 10 and @koma2 = 1
set @koma1 = @koma1 * 10
set @tx1 = [dbo].terjemahkan(@koma1)
set @hasil = @tx + ‘rupiah ‘ + @tx1 + ’sen’
end
else
set @hasil = @tx + ‘rupiah’
return (@hasil)
end

Bookmark It

Hide Sites

Your car insurance is one of the most important bills that you have to pay each month. Depending on the factors that contributed to your premium, you will be paying quite a bit to your policy. No one wants to throw money away, so it is important that you ensure you are paying a fair amount on your premium.

As the New Years celebrations roll around, people find themselves reassessing the year they have had, and their future goals and plans for the forthcoming year. It is always a good idea to take into account all the things that you want to change in your new year, and saving money should be a contributing factor.

Luckily, the New Year can be an excellent time to review your car insurance policy. If you have had the same car insurance company all year long, and are happy with them, then perhaps you do not need to reassess your policy. But it also never hurts to look around and see what else there is to offer. Firstly, it is important to keep in mind that a lot of car insurance companies bring out new deals and special offers at the start of a new year. They may be feeling the pressure of surrounding competition, and have lowered their prices and deals. This is why it is a good thing to obtain some quotes from competing insurance companies at the beginning of a new year, you could be pleasantly surprised.

The next thing you need to do in the New Year is have your car’s value reassessed. Your insurance premium is most certainly also calculated on the value of your car. Unfortunately, your car’s value will depreciate each year. This means that you should not have to pay the same insurance premium that you were paying before on a car that costs less. Have your car revalued and request forth some insurance quotes regarding this.

Furthermore, in the New Year it is important that you ensure that you have taken all the necessary measures to get yourself the lowest premium. If your car does not have a good alarm system, now is the time to install one. Simply installing a better alarm system and even a tracking device can save you a truckload in premiums! Make it a New Year’s resolution to keep your car in as good a condition as possible. Have it serviced regularly according to the booklet; check the tires and windshield wipers and oil and water on a regular basis, even every time that you fill up with gas. If you hear a strange noise coming out of your vehicle, have it checked out immediately, this stops a minor problem from becoming a major one. Problems on the running of your vehicle can easily cause you to have an accident, especially problems with your brakes. Any noise emitting from your brakes and any impairment in their functioning must be looked into immediately.

As the New Year is the time to look back in retrospect, and forward in hope, make it a new year of cost effectiveness in everything that you spend your money on.

To obtain the most competitive of vehicle insurance quotes visit http://www.payasyoudrive.co.za.

Article Source: http://EzineArticles.com/?expert=Danny_Aaron

Bookmark It

Hide Sites

by: Sandra Stammberger

Supply chain management can be defined as the process of planning, implementing and monitoring the everyday operations of a supply chain. Supply chain management is an all encompassing process as it undertakes the management of availability of raw materials, their processing into finished goods and the distributions of the same. The aim of all this is to provide the highest level of satisfaction to the customer and thus increase the business of the company. And with the increasing complexity of the supply chain, supply chain management has also become about coordinating and collaborating with the different trade partners now involved in the supply chain.

Supply chain management is supposed to be undertaken by the high level management committee of the company. The employees have to willingly adhere to their decisions in order to bring about maximum efficiency in the supply chain.

Supply chain management decisions are made on three different levels- the tactical, strategic and operational levels. Strategic level involves long term decisions while tactical level includes medium term decisions while operational level is concerned with very short term day-to-day operational concerns. The problems that the supply chain system is supposed to address includes the following:

* Distributor Network Configuration: Quantities and locations of people involved with the entire process of the supply chain including the suppliers, customers, warehouses, production facilities and distribution centers.
* Strategies for distribution: Centralized, direct shipments, push and pull strategies, cross docking and third party logistics.
* Information: Integrating systems and processes through supply chain to share relevant and significant information consisting of demand signals, forecasting, transportation and of course, inventory.
* Management of inventory: Number and location of inventory and also covers raw materials, finished goods as well as work in progress.

The flow of the supply chain execution is always bi directional and basically manages and coordinates movement of material, information and finances of the supply chain. There are some key supply chain management processes that have been identified. They are:

* Management of customer relations.
* Management of customer service
* Management of demands.
* Fulfillment of orders.
* Manufacturing flow management.
* Management of supplier relations.
* Developing the product and commercializing it.
* Managing returns.

Other key business processes which are used as supply chain procedures and are a vital part of the process and include:

* Customer service management: Steps used by companies to build successful customer relations include focusing on mutually satisfying goals; establishing and maintaining customer relations; produce feelings of positivity and trust between the customers and organization.
* Procurement processes.
* Product developing and commercializing: This includes coordinating with customer relationship management to identify customer articulated needs, selecting suppliers and materials and developing production technology to integrate and produce the best supply chain flow.
* Manufacturing flow management processes.
* Physical distribution.
* Outsourcing and partnerships.
* Performance measurement regarding cost, productivity measures, customer service, asset measurement and quality.

Together with all of these the supply chain management system has managed to put into place an integrated supply and demand management within and across business firms.

Bookmark It

Hide Sites