Bcz i want to put the result of the stored proc into "dbo.INFORMATION" table.but it is giving me an error "unable to begin a distributed transactions" when i run...

No, i cannot .

Thanks a lot !!

But ,How we can do with a computed column?.

I was trying to use this one.Is this right?

UPDATE #th

SET FLAG= CASE WHEN B.day2 is null then 'NO'

else 'YES' end

from #th A

left join ( select distinct...

any help on this would be great.

i am working on ssis.

thanks for code.but it is giving me error Msg 536, Level 16, State 2, Line 3

Invalid length parameter passed to the RIGHT function.

I think it is beause in there are...

I have a table name Test_name.which has two columns full_name and nick_name.I have values only in full_name where as Nick_name column is blank which i need to update as per...

yes,it has webservice.

thanks

thanks a lot

create table test (adress varchar(100),[Convert_to_format] nvarchar(100),mask varchar(100),Net nvarchar(100))

insert into Test values ('NK00:976a:c305:bef8:575c:646d::0:a/127' ,'',127,'')

,('2012:0DB8:AC10:FE01::/64','',64,''),

('NK00:976a:c305:bef8:575c::0:56/16','',16,'')

and this is result i want.

insert into Test values ('NK00:976a:c305:bef8:575c:646d::0:a/127','NK00:976a:c305:bef8:575c:646d:0000:000a',127,'NK00:976a:c305:bef8:575c:646d:0000:0000'),

('2012:0DB8:AC10:FE01::/64','2012:0DB8:AC10:FE01:0000:0000:0000:0000',64,'2012:0DB8:AC10:FE01:0000:0000:0000:0000'),

('NK00:976a:c305:bef8:575c::0:56/16','NK00:976a:c305:bef8:575c:0000:0000:0056',16,'NK00:0000:0000:0000:0000:0000:0000:0000')

Adress is IPadress and net is output after combining.

looking into this.