Hi

Yeah I know how outer join works. Just wondering why it is not updating tab1.id when select returning the result set. Anyway, how can this be achieved then?

Hi,

There 3 rows in tab1 where ID is null and 3 rows in tab2 where ID's are 1,3,4.

tab1 contains only one column which is null in all records and tab2 also contains one column which is not null and having data. I want to update tab1.id with...

Thanks All. I was able to update XML column successfully. It was nice working with XML in SQL Server.

Hi

Actually, I have one xml column and it contains data as below. I want to update value of all VCReqId in one update to another int column in same...

Hi

Thanks Again! Is that possible to make those two separate updates into single update statement to update ID1 and ID2?

Hi,

Thanks. That was really helpful.

Guys,

I had received below error in Analysis Services Process task.

Internal error: The operation terminated unsuccessfully.

Initially I did not understand where was the problem since it runs successfully when we run...