I need Stored Procedure "pr_DS_RandomBox_Get"

10/05/2024 18:31 shabi002#1
Who can help me
10/05/2024 18:37 azgoku0091#2
5$
HTML Code:
USE [ND_GAME_0]
GO
/****** Object:  StoredProcedure [dbo].[pr_DS_RandomBox_Get]    Script Date: 10/5/2024 6:36:56 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



ALTER PROC [dbo].[pr_DS_RandomBox_Get]
  [MENTION=3613419]cui[/MENTION]d	 int
,  [MENTION=955363]rank[/MENTION]	smallint
AS
SET NOCOUNT ON

IF EXISTS (SELECT 1 FROM ND_V03_RandomBox WHERE cuid =  [MENTION=3613419]cui[/MENTION]d and rank =  [MENTION=955363]rank[/MENTION])
	SELECT cuid, rank, nBonusCount, nBonusIndex, checkNumber1, isLock1, checkNumber2, isLock2, checkNumber3, isLock3
	FROM ND_V03_RandomBox WHERE cuid =  [MENTION=3613419]cui[/MENTION]d and rank =  [MENTION=955363]rank[/MENTION]
ELSE
	SELECT  [MENTION=3613419]cui[/MENTION]d AS cuid,  -1 AS rank, -1 AS nBonusCount, -1 AS nBonusIndex, -1 AS checkNumber1, -1 AS isLock1, -1 AS checkNumber2, -1 AS isLock2, -1 AS checkNumber3, -1 AS isLock3
10/06/2024 02:43 shabi002#3
thank you very much

it's so bad
my database version is too low,It does not support this code