USE [lin2world]
GO
/****** Object:  StoredProcedure [dbo].[lin_SetLastTaxUpdate]    Script Date: 01/23/2018 01:07:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO






/********************************************
lin_SetLastTaxUpdate

INPUT
@income  datetime,
@tax datetime
OUTPUT
made by
 carrot
date
 2004-02-29
********************************************/
ALTER PROCEDURE [dbo].[lin_SetLastTaxUpdate]
(
@income  varchar(50),
@tax varchar(50),
@manor varchar(50)
)
AS

SET NOCOUNT ON

DECLARE @d_income datetime = CONVERT(datetime, REPLACE( @income, '-0-', '-01-' ), 120)
DECLARE @d_tax datetime = CONVERT(datetime, REPLACE( @tax, '-0-', '-01-' ), 120)
DECLARE @d_manor datetime = CONVERT(datetime, REPLACE( @manor, '-0-', '-01-' ), 120)

IF EXISTS(SELECT * FROM castle_tax)  BEGIN
 UPDATE castle_tax SET   income_update =  @d_income, tax_change =   @d_tax, manor_reset =   @d_manor
END  ELSE  BEGIN
 INSERT INTO castle_tax VALUES (  @d_income, @d_tax, @d_manor)
END