How to modify SQL server 2005 query syntax to run in visual studio when I click a button.

Visual Studio 2005
vb.net

Hi
I use the following sql syntax manually in a sql server query to identify records in a table that have the same task description.  If the task description occours within a certain time period then it is a replica task and if it doe not occour in the same time period it is related task.

Problem:
I want the the syntax to run and update the records in a table when I click a button that saves the data to the data base.  I added the syntax right after the cmd.CommandText = but Visual studio treates the statement differently and does not like like the way the statement is sturcted on multiple lines.  I tried placing all the lines on on row, but it treates this section like a comment.  

Please suggest a way to get this sql statement to work in visual studio.

update t
set t.replica = Case When b.Description='replica' THEN 1 ELSE 0 END,
    t.related = CASE WHEN b.Description='related' THEN 1 ELSE 0 END
from
tblTask t
join
(
SELECT     Description = CASE WHEN ranking1 = 1 AND ranking2 = 1 THEN '' WHEN ranking1 > 1 AND ranking2 > 1 THEN 'replica' WHEN ranking1 = 1 AND
                      ranking2 > 1 THEN 'related' END, TaskID

FROM         (SELECT     ranking1 = row_number() OVER (partition BY Task, Occurrence
                       ORDER BY Task ASC), ranking2 = dense_rank() OVER (partition BY Task
ORDER BY TaskID ASC), *
FROM         tblTask) a
) b on t.TaskID = b.TaskID"

behind aspx page
 
saveData_onclick
 
Dim cmd As New SqlClient.SqlCommand()
cmd.Connection = New SqlConnection(Me.SqlDataSource1.ConnectionString)
cmd.Connection.Open()
 
 
cmd.CommandText = "update t
set t.replica = Case When b.Description='replica' THEN 1 ELSE 0 END,
    t.related = CASE WHEN b.Description='related' THEN 1 ELSE 0 END
from
tblTask t
join
(
SELECT     Description = CASE WHEN ranking1 = 1 AND ranking2 = 1 THEN '' WHEN ranking1 > 1 AND ranking2 > 1 THEN 'replica' WHEN ranking1 = 1 AND
                      ranking2 > 1 THEN 'related' END, TaskID
 
FROM         (SELECT     ranking1 = row_number() OVER (partition BY Task, Occurrence
                       ORDER BY Task ASC), ranking2 = dense_rank() OVER (partition BY Task
ORDER BY TaskID ASC), *
FROM         tblTask) a
) b on t.TaskID = b.TaskID"
 
cmd.CommandType = CommandType.Text
cmd.ExecuteNonQuery()
cmd.Connection.Close()
GridView1.DataBind()

Select allOpen in new window