Help With INSERT Procedure

Hello,
I have a procedure which INSERTS a new record in two tables [Content] and [ContentLocalized] given [ContentName] and [ContentCulture].
Here are the table structures:
   <Content>
         |----- [ContentId]   Type=UniqueIdentifier   PK
         |      [ContentName]    Type=NVarChar(100)
         |
         |     <ContentLocalized>
         |           [ContentLocalizedId]   Type=UniqueIdentifier   PK
         | -------> [ContentId]   Type=UniqueIdentifier   FK
         |           [ContentCulture]   Type=NVarChar(5)
         |           [ContentHtml]   Type=NVarChar(MAX)
 WHAT I AM MISSING:
    > If in <Content> THERE IS a record with the same [ContentName] then this record will be used AND:

           If in <ContentLocalized> for the given [ContentName] THERE IS NO such [ContentCulture] then a new will be created with [ContentCulture] and [ContentHtml]

           If in <ContentLocalized> for the given [ContentName]
THERE IS such [ContentCulture] then its [ContentHtml] will be replaced by the given [ContentHtml]
    > If in <Content> THERE IS NOT a record with the same [ContentName] then:
           A new <Content> record will be created with [ContentName] and a new <ContentLocalized> record will be created with [ContentCulture] and [ContentHtml].
I know I didn't get there yet.
Could somebody help em out?
I am posting the INSERT Store Procedure as I have now:      1 SET ANSI_NULLS ON
2 GO
3 SET QUOTED_IDENTIFIER ON
4 GO
5 ALTER PROCEDURE [dbo].[Content_CreateContentByNameAndCulture]
6 @ContentName NVARCHAR(100),
7 @ContentCulture NVARCHAR(5),
8 @ContentHtml NVARCHAR(MAX)
9 AS
10 BEGIN
11 SET NOCOUNT ON;
12 DECLARE @ContentId UNIQUEIDENTIFIER;
13 SET @ContentId = NEWID();
14 INSERT dbo.Content
15 (
16 ContentName
17 )
18 SELECT
19 @ContentName;
20 SELECT @ContentId;
21 INSERT dbo.ContentLocalized
22 (
23 ContentId,
24 ContentCulture,
25 ContentHtml
26 )
27 SELECT
28 @ContentId,
29 @ContentCulture,
30 @ContentHtml;
31 END
32 GO
33
34
35

Thanks,
Miguel