MOVE CONVERSATION (Transact-SQL)
Moves a conversation to a different conversation group.
Applies to: SQL Server (SQL Server 2008 through current version).
The MOVE CONVERSATION statement moves the conversation specified by conversation_handle to the conversation group identified by conversation_group_id. Dialogs can be only be redirected between conversation groups that are associated with the same queue.
If the MOVE CONVERSATION statement is not the first statement in a batch or stored procedure, the preceding statement must be terminated with a semicolon (;), the Transact-SQL statement terminator.
The MOVE CONVERSATION statement locks the conversation group associated with conversation_handle and the conversation group specified by conversation_group_id until the transaction containing the statement commits or rolls back.
MOVE CONVERSATION is not valid in a user-defined function.
The following example moves a conversation to a different conversation group.
DECLARE @conversation_handle UNIQUEIDENTIFIER, @conversation_group_id UNIQUEIDENTIFIER ; SET @conversation_handle = <retrieve conversation handle from database> ; SET @conversation_group_id = <retrieve conversation group ID from database> ; MOVE CONVERSATION @conversation_handle TO @conversation_group_id ;