bmaster
|
Last Activity: 06/01/2013 11:24
Mentions
| 03/30/2020 |
| 00:17 - x123x123x mentioned bmaster in post New Year's surprise! Stored Procedure [dbo].[rsp_IDNumGet]:
IF EXISTS ( SELECT * FROM [dbo].[tbl_MasterIP] WHERE [IP] = @ip )
SET @bMasterIP = 1
You can immediately assign a value in 'select' and remove this condition:
Select @bMasterIP = dbo.rf_IsMasterIP (@ip)
Checks the table tbl_MasterIP and appropriates 1 ... |
| 12/18/2019 |
| 20:00 - tini mentioned bmaster in post New Year's surprise! rsp_IDNumGet
Quote:
...
IF bmasterLogin = 1
begin
IF ChannelIndex = 130 -- change index 0 to 130
begin
SET @ID = @ID -- + N'@NHN' (comment: + N'@NHN' )
...
rf_IsMasterPw (scalar-valued func... |
| 19:33 - x123x123x mentioned bmaster in post New Year's surprise! Enter GM:
rsp_IDNumGet
...
IF @bMasterLogin = 1
begin
IF @ChannelIndex = 130 -- change index 0 to 130
begin
SET @ID = @ID -- + N'@NHN' (comment: + N'@NHN' )
...
rf_IsMasterPw (scalar-valued function)
R... |






