UFN_FINANCIALINSTITUTION_SINGLEBANKID_2
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ROUTINGNUMBER | nvarchar(9) | IN | |
| @SORTCODE | nvarchar(8) | IN | |
| @BSB | nvarchar(7) | IN | |
| @INSTITUTIONID | nvarchar(8) | IN | |
| @BANKNUMBER | nvarchar(7) | IN | |
| @BIC | nvarchar(11) | IN | |
| @BANKCODE | nvarchar(25) | IN |
Definition
Copy
create function dbo.UFN_FINANCIALINSTITUTION_SINGLEBANKID_2
(
@ROUTINGNUMBER nvarchar(9),
@SORTCODE nvarchar(8),
@BSB nvarchar(7),
@INSTITUTIONID nvarchar(8),
@BANKNUMBER nvarchar(7),
@BIC nvarchar(11),
@BANKCODE nvarchar(25)
)
returns bit
with execute as caller
as begin
if (@SORTCODE = '' and @BSB = '' and @INSTITUTIONID = '' and @BANKNUMBER = '' and @BIC = '' and @BANKCODE = '') or
(@ROUTINGNUMBER = '' and @BSB = '' and @INSTITUTIONID = '' and @BANKNUMBER = '' and @BIC = '' and @BANKCODE = '') or
(@ROUTINGNUMBER = '' and @SORTCODE = '' and @INSTITUTIONID = '' and @BANKNUMBER = '' and @BIC = '' and @BANKCODE = '') or
(@ROUTINGNUMBER = '' and @SORTCODE = '' and @BSB = '' and @BANKNUMBER = '' and @BIC = '' and @BANKCODE = '') or
(@ROUTINGNUMBER = '' and @SORTCODE = '' and @BSB = '' and @INSTITUTIONID = '' and @BIC = '' and @BANKCODE = '') or
(@ROUTINGNUMBER = '' and @SORTCODE = '' and @BSB = '' and @INSTITUTIONID = '' and @BANKNUMBER = '' and @BANKCODE = '') or
(@ROUTINGNUMBER = '' and @SORTCODE = '' and @BSB = '' and @INSTITUTIONID = '' and @BANKNUMBER = '' and @BIC = '')
return 1;
return 0;
end