T-SQL Tip : Cloning a record

Simple little T-SQL tip.  I wrote a stored proc today that clones a record and assignes a parentId to the cloned record to form a parent child relation between records in the same table.

CREATE PROCEDURE [dbo].[InsertChildMessage]
	@MessageId bigint,
	@Id bigint OUTPUT
AS

SET NOCOUNT ON

INSERT INTO [dbo].[Message] (
[MessageGroupId],
	[ParentMessageId],
	[CorrelationId],
	[ToPartyId],
	[FromPArtyId],
	[IsFailed]
)
SELECT 
        [MessageGroupId],
	@MessageId,
	[CorrelationId],
	[ToPartyId],
	[FromPartyId],
	[IsFailed]
FROM 
        [dbo].[Message]
WHERE 
        [dbo].[Message].Id = @MessageId;

SET @Id = SCOPE_IDENTITY()
Advertisements
This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s