spResolveClassOf
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClassOfText | nvarchar(10) | IN | |
| @ClientsID | int | IN | |
| @InsertIfNotFound | bit | IN |
Definition
Copy
CREATE PROCEDURE dbo.spResolveClassOf
(
@ClassOfText nvarchar(10),
@ClientsID int,
@InsertIfNotFound bit
)
AS
IF @InsertIfNotFound<>0
IF NOT EXISTS (SELECT TOP 1 ID FROM ClientClassYears WHERE ClientsID=@ClientsID AND Name=@ClassOfText)
INSERT INTO ClientClassYears(Name,ClientsID,Guid) VALUES(@ClassOfText, @ClientsID, NewID())
SELECT TOP 1 * FROM ClientClassYears WHERE ClientsID=@ClientsID AND Name=@ClassOfText