USE [LosaGame]
GO

/****** Object:  StoredProcedure [dbo].[game_practice_BlockList]    Script Date: 01/11/2018 11:59:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[game_practice_BlockList]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[game_practice_BlockList]
GO

USE [LosaGame]
GO

/****** Object:  StoredProcedure [dbo].[game_practice_BlockList]    Script Date: 01/11/2018 11:59:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



--IF OBJECT_ID('dbo.game_practice_BlockList','P') IS NOT NULL	
--
--	DROP PROC dbo.game_practice_BlockList
--
--GO

-- =============================================
-- Subject		: dbo.game_practice_BlockList
-- DBA			: 
-- DATE			: 2015-06-17
-- Description	: ÈÆ·Ã µ¥ÀÌÅÍ »ý¼º
-- =============================================


CREATE PROCEDURE [dbo].[game_practice_BlockList]
 	@KickID varchar(20)
AS

	SET NOCOUNT ON;
	SET LOCK_TIMEOUT 10000;

	SELECT accountIDX FROM LosaGame.dbo.userMemberDB WHERE limitType = 100 AND limitDate > Getdate() - 3 AND userID = @KickID

GO