How will this work when addresses are like:

Dummy Management Unit PO BOX 999 Dept of Energy, Training and The Arts CITY EAST DummyState 9999,

Unit 1/100 Dummy Street, DummySuburb, DummyState

For...

Thanks for the response. I was looking at the following solution which I managed to work out

SELECT

a.GBSSTATEMENT,

a.GBSLEDGER,

ISNULL(b.cumulativesum,0) as OpeningBal,

a.cumulativesum as ClosingBal

FROM

(select

x.GBSSTATEMENT,

x.GBSLEDGER,

(select sum(y.AMOUNT) from dbo.ledger_summary y where y.ranknum <=...

Full Solution is:

CREATE TABLE dbo.fuzzymatches

(

Record1 nvarchar(50),

Record2 nvarchar(50)

)

GO

INSERT INTO dbo.fuzzymatches (Record1, Record2) VALUES ('1', '2')

INSERT INTO dbo.fuzzymatches (Record1, Record2) VALUES ('2', '3')

INSERT INTO dbo.fuzzymatches (Record1, Record2) VALUES ('4', '3')

INSERT INTO dbo.fuzzymatches...

Finally figured this out using recursive CTE

Instead of using the conditional split to explicitly determining the columns that have been changed, you can use a SQL Command with an UPDATE statement to the entire table

i.e.

UPDATE...

Actually I was looking for this solution which I finally managed to figure out

First Day of Current Week

Note: Monday is first day of Week

=DATEADD("d", 1 - DATEPART(DateInterval.WeekDay, Today(),FirstDayOfWeek.Monday), Today())

Last...

Hi Jeff,

I am glad to help. I usually do not write any articles but with the feedback I am getting from people may encourage me to write some articles and...

Hi Jeff,

You can use the OLEDB Source, Lookup and OLEDB Destination tasks to do this. But you will have to configure the error output in Lookup Task to redirect row...