USE [PSRS]
GO
/****** Object:  StoredProcedure [dbo].[DeleteCase]    Script Date: 01/18/2012 16:03:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Subi Thayamkery
-- Create date: 07/28/2008
-- Updated date: 
-- Description:	Delete Case Vehicle By VehicleId
-- =============================================
CREATE PROCEDURE [dbo].[DeleteCase]
(		
		 @UserId			VARCHAR(7) 
		,@CaseId			INT	
)
AS

CREATE PROC [dbo].[usp_UPD_myMessage_complete]
	  @myMessage_Id								nvarchar(50)			-- And Id for 'Group_Trans_Id' or 'Business_Key_Id'
	, @myMessage_Id_Type                        nvarchar(20)			-- Literal Values
	, @User										char(12)	
	, @rc int OUTPUT, @Error int OUTPUT,  @Error_Message varchar(255) OUTPUT, @Rowcount int OUTPUT
	
AS 


--
--                 Enterprise Solutions
--
--           File:      \\paerscns20\ss\GBTS_Systems_Projects\Projects\myActions\Database\SQLServer\NJROS1BBLD0304\DEV2K08\Sprocs
--           Date:      08/16/2011
--         Author:      Brett Kaiser
--         Server:      NJROS1BBLD0304\DEV2K08
--       Database:      myActions
--          Login:      myActions_User99
--		Procedure:		usp_UPD_myMessage_complete
--    Description:      Update a Row in the User_Message table
--
--   Return codes:		-1	Unsuccessful Execution 
--						0	Successful Execution
--						1	Zero rows returned or modified
--
--    Tables Used:		myMessage
--
-- Tables Created:		None
--
--
--  Row Estimates:
--	name						rows        reserved           data               index_size         unused
--	--------------------		----------- ------------------ ------------------ ------------------ ------------------
--	User_Message				0           0 KB               0 KB               0 KB               0 KB
--
-- sp_spaceused User_Message
--
--Change Log
--
-- UserId    	Date         	Description
-- -----------  --------------  ------------------------------------------------------------------------------------------
-- X168161		08-26-2011		Initial Release
-- X002548		09-08-2011		Change Inputer Parameters to be 	  
--								  @myMessage_Id	nvarchar(30)			
--								, @myMessage_Id_Type nvarchar(20)-- Literal Values 'Group_Trans_Id' or 'Business_Key_Id'
--
--
-- X002548		01-12-2011		Change the input variable parameter @myMessage_Id to be nvarchar(50) from nvarchar(30)
--
--
--

/*
--Sample Execution:

--
-- Test
--

Create PROC [dbo].[Test]
AS
PRINT 'TEST'

GO