<div>
Just for clarification, if Table A has a code of HRT, how many records will be inserted in Table B? &nbsp;Just 1 or depends how many times HRT exists in Table A?<br />
<br />
If you just want a record inserted to Table B if there's a HRT in Table A, this should work:<br />
<br />
INSERT INTO Table B<br />
SELECT 8<br />
WHERE EXISTS (SELECT 'X' FROM TableA WHERE Code = 'HRT')
</div>


Just for clarification, if Table A has a code of HRT, how many records will be inserted in Table B?  Just 1 or depends how many times HRT exists in Table A?

If you just want a record inserted to Table B if there's a HRT in Table A, this should work:

INSERT INTO Table B
SELECT 8
WHERE EXISTS (SELECT 'X' FROM TableA WHERE Code = 'HRT')

<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm trying to write a script that will do the following:<br />
It will verfiy what code is in Table A and then it will write a pre determined number into Table B.<br />
<br />
Example:<br />
Table A Codes<br />
HRT<br />
HRA <br />
OA<br />
<br />
So if the code in Table A is HRT it will write 8 into Table B.<br />
<br />
I don't know if I should use If or Case statement.<br />
<br />
TIA,<br />
<br />
Frank
</div>
</div>


Hi,
I'm trying to write a script that will do the following:
It will verfiy what code is in Table A and then it will write a pre determined number into Table B.

Example:
Table A Codes
HRT
HRA 
OA

So if the code in Table A is HRT it will write 8 into Table B.

I don't know if I should use If or Case statement.

TIA,

Frank

If or Case Statement

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.