Thank you all for the responses. Substring and replace will not work on binary value unless we do the conversion to a string, did the conversion in the following way...

I am approx adding 2% of the total. Unfortunately, I don't have access to some of statistics procedures and system tables

Which permission can I check for the all_columns

I'm not sure why none of the view.columns are making it to sys.all_columns, but the views are created under sys.all_objects

Thank you all!

Thank you Adi. View name is student_master_vv2

This is fairly small sample table, I'm dealing with 30 - 40 tables having at least 3-4 similar columns . Also, I'm thinking by doing * , I don't have...

Thank you all. Since the output of the result needs to be inserted into another table. The other option would be to do this programmatically with loops , if-then-else statements.

Thanks Sean. What will be an alternative solution

Thank you so much jcb. This is exactly what I need. I'm curious on how the performance is for cross joins

Thanks everyone.

I can't post the data as it is sensitive therefore I was trying to take Employee Dept example. Since, I'm new to SQLServer and this forum,I was hoping an...

Some of the batch jobs at the destination can use this column to compare what changed in the source and update the changed rows in destination table.

Thank you all. Probably an example will help !

Source Table --- SQL Server 2000

Table A

Col1 nvarchar(100)

Col2 datetime

Col3 timestamp

Source Table A Data

Col1 Col2 ...

Thank you all .My source column has timestamp data type, should I create rowversion, date time data type to hold the same value as in source