Please use this way to aviod looping.

--Please pass through Query string

Declare @sParameter varchar(max)

Begin

Set @sParameter = 'select ''WA'' union all select ''AZ'' union all select ''CA'' union all select ''TS'''

Declare @tStates...

There is an issue held to copy table for this way .Key and identity are lost.Only use the query to use take Backup ony.