Excellent question ... keep it up!!! 🙂

good question ... thanks

😀 ... yeah rite

Thanks everyone for the comments

"Mike Dougherty" its a funny world, anything can happen !!!

"btw, if return is encountered while a transaction is uncommitted - does it rollback?" And the...

really nice question ... Thanks 🙂

Thanks for the comments 🙂

i like the case sensitive thing 😛

a bit delayed response from my side .... but a good question !!!

For Some reason ... Excel and SSIS dont really like each other 🙂

Thanks Hugo for taking so much from the other for me ... really appreciated !!!

For the explanation weak thing ... i accept the explanation is not as detailed as it...

Hope it helps u and others !!!

DECLARE @t Table

(

AreaID int,

AreaName nvarchar(100),

Responsible nvarchar(100)

)

Insert Into @t

Select 1, 'Finance',Null

Union All

Select 2, 'IT','Internal, External'

Union All

Select 3, 'Audit, Security', 'Internal'

Union All

Select 4, 'Health, Safety, Compliance',...

Thanks for the comments guys.

@kingston Dhasian: your explanation is the correct one.

Actually this was a real time issue, when people just write queries in a hurry and forget...