Below is my target table and data should be inserted like below.

Date RepCurr Earning

1/1/2010CAD1.0520

1/1/2010CZK18.3475

1/1/2010EUR0.6977

1/2/2010CAD1.0532

1/2/2010CZK18.3985

1/2/2010EUR0.6957

1/3/2010CAD1.0517

1/3/2010CZK18.3360

1/3/2010EUR0.6982

1/4/2010CAD1.0377

1/4/2010CZK18.1624

1/4/2010EUR0.6935

1/5/2010CAD1.0371

1/5/2010CZK18.2541

1/5/2010EUR0.6943

1/1/2010USD0.9506

1/1/2010USD0.0545

1/1/2010USD1.4333

1/2/2010USD0.9495

1/2/2010USD0.0544

1/2/2010USD1.4374

1/3/2010USD0.9508

1/3/2010USD0.0545

1/3/2010USD1.4323

1/4/2010USD0.9637

1/4/2010USD0.0551

1/4/2010USD1.4420

1/5/2010USD0.9642

1/5/2010USD0.0548

1/5/2010USD1.4403

Thanks in Advance!!!

Please find the details below

Date CAD CZK EUR

1/1/20101.052018.34750.6977

1/2/20101.053218.39850.6957

1/3/20101.051718.33600.6982

1/4/20101.037718.16240.6935

1/5/20101.037118.25410.6943

Sometimes we may receive additional(new) columns like GBP,...

No, Columns positions will be same but we may receive new columns that

may not be exists in previous sheet which we received.

For Example,

First time, we receive the Sheet with...

Below is the query i was looking for 🙂

create table #num (n int not null)

go

declare @i int

set @i = 0

while @i < 1000

begin

insert into #num select (@i)

set @i...

As per requirement we are not supposed to use UDF

Hi Livingston ,

Thx for ur quick response.

Can you help with out using UDF functions.

In a Table..