<div>
To Insert in another table flag for unniqueness<br />
<br />
Select 1 from TM_C_details where PrimaryKey &lt;&gt;&nbsp;current row Primary Key <br />
If return 1 then put 1 in [TM_NEW_TABLE] 
</div>


To Insert in another table flag for unniqueness

Select 1 from TM_C_details where PrimaryKey <> current row Primary Key
If return 1 then put 1 in [TM_NEW_TABLE]

<div>
thanks @Patel<br />
<br />
Unfortunately NO PRIMARY KEYS HAVE BEEN DEFINED FOR THE TABLES..
</div>


thanks @Patel

Unfortunately NO PRIMARY KEYS HAVE BEEN DEFINED FOR THE TABLES..

<div>
@Kamal thanks so much.. <br />
It worked
</div>


<div>
<div class="content wysiwyg-content">
Hi all<br />
<br />
I have very simple requirement... I have a table [TM_C_details] with accountno,custname,city,co<wbr />untry,zone<wbr />.<br />
now i have to create new column 'Unique A/c' into another table [TM_NEW_TABLE] if the acountno is unique then Unique a/C should be 1 else 0.<br />
<br />
Hope am clear... any suggestions are highly appreciated.
</div>
</div>


Hi all

I have very simple requirement... I have a table [TM_C_details] with accountno,custname,city,country,zone.
now i have to create new column 'Unique A/c' into another table [TM_NEW_TABLE] if the acountno is unique then Unique a/C should be 1 else 0.

Hope am clear... any suggestions are highly appreciated.

select query

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.