Thanks, am very greatfful.

@Koen Verbeeck.. Thanks Boss.. I have the book already. Nice pointer from you.

Please search for the term 'gazetteer' on-line. It's a good pointer.

Thanks all..

Cadavre , vinu512 ,dwain.c, Ravi Kumar-191606

.. you all are wonderful .. God bless.

The question is how can I achieve the expected/desired result with tsql using the 2 table structures I specified.

Thanks Boss

Good day Welsh Corgi,

I merge incremental to initial load most times, don't use to clear my staging.

I will henceforth borrow Lynn Pettis's idea.

Thanks Welsh

Thanks Lynn 😛

Hi Friend,

I would suggest you use sample data from MetOffice.gov.uk as your source. Since it's POC, you can tune the data to look like how you want.

Better still generate data...

This is my contribution. This works for me.

1. create LAST_LOAD variable as datetime

2. execute tsql command: SELECT LSET FROM [STG].[dbo].[ETL_CONFIG_LOAD] WHERE NAME = 'TABLEA' ..

return as LSET to save...

Thanks Boss. Forgive my laziness I will try that ASAP. Many thanks.

Thanks all,

Your contributions has re-sharpen how I see SCD type 2. Am only trying to base my scd type 2 on 3 column table where two of the columns are...

Thanks Koen for your help.

By my understanding, User!UserId returns windows user (i.e one who logged in to machine) .

I want to return sharepoint user (One who sharepoint FBA authenticates).

Many...

Thanks Boss,

See below

DECLARE @Stock table (

INDEX_CODE varchar(20)

,INDEX_DATE date

,[OPEN] decimal(32,2)

,HIGH decimal(32,2)

,LOW decimal(32,2)

,[CLOSE] decimal(32,2)

)

insert into @Stock (INDEX_CODE,INDEX_DATE,[OPEN],HIGH,LOW,[CLOSE])

select 'AA', '2011/01/01', 2.0, 3.2,1.2,2.4 UNION ALL

select 'AB', '2011/01/01', 0.2, 1.1,0.1,0.1...

Phil,

The function runs well.

The function returns daily/average balance for each records, based on account_id, from_date and to_date. it's an oracle function..

CREATE OR REPLACE function getAvgBal(cAcid varchar,sDate...

Phil,

Many thanks Boss ...

Yes, It's runs 4 hours. There is a particular function running the process slow...

Boss,

Am very greatful.

Aside the code, you have given me more idea on the sharing process..

Thanks