For Distinct try like this.

select a.Number INTO One_Column FROM

(select Number from Merge_Columns

UNION

select Number from Merge_Columns1

)a

For whole data from both table try like below.

select a.Number INTO One_Column FROM

(select Number from...

Sean Lange (10/25/2013)

p.shabbir (10/25/2013)

Sean,

At my work i used to specify "NOLOCK" at the end of select statement.Hence, by habit...

Sean,

At my work i used to specify "NOLOCK" at the end of select statement.Hence, by habit i mentioned there.You...

Hi Scuby,

Try this.

select REPLACE(SUBSTRING(Your_Column,1,CHARINDEX('@',Your_Column)),'@','') Name from Your_Table NOLOCK

Thanks

sibi.

Thanks for info rohit.But i want it in script task.

Thanks for quick response Luis.

I am just practicing.

I know we can do that by tasks but, i want to learn how to do using script task only. I googled it...