DELETE Procedure. How To Do This?

Hello,

I created a delete procedure which is working but I still have a
problem.

When I delete a localized content from dbo.by27_ContentLocalized given
a ContentName and ContentCulture I want to check if this is the only
record in ContentLocalized for that ContentName.

If it is then I also want to delete the record in dbo.by27_Content
which has that ContentName.

How can I do this?

Thanks,
Miguel

Here is my DELETE procedure:

-- Define the procedure parameters
@ContentCulture NVARCHAR(5),
@ContentName NVARCHAR(100)

AS

-- Allows @@ROWCOUNT and the return of number of records when
ExecuteNonQuery is used
SET NOCOUNT OFF;

-- Declare and define ContentId
DECLARE @ContentId UNIQUEIDENTIFIER;
SELECT @ContentId = ContentId FROM dbo.by27_Content WHERE ContentName =
@ContentName

-- Check if ContentId is Not Null
IF @ContentId IS NOT NULL
  BEGIN

    -- Check if ContentId is Null
    IF @ContentCulture IS NULL
      BEGIN

        -- Delete all localized contents from dbo.by27_ContentLocalized
        DELETE
        FROM dbo.by27_ContentLocalized
        WHERE ContentId = @ContentId

        -- Delete content from dbo.by27_Content
        DELETE
        FROM dbo.by27_Content
        WHERE ContentName = @ContentName;

      END
    ELSE

      -- Delete localized content from dbo.by27_ContentLocalized
      DELETE
      FROM dbo.by27_ContentLocalized
      WHERE (ContentID = @ContentID   AND ContentCulture = @ContentCulture)

  END