how to put the query in a stored procedure

create procedure SP_ProcedureName
--(@storecode varchar(50)) //if you want to pass this as parameter, you need to pass it as comma seperated value string format
  --and you need to convert the   CSV to a table format
as
begin
USE RAUSDXT02
 
--drop table ##tbl_STORE_LIST
 
select store_code INTO ##tbl_STORE_LIST from store
 
where 
 
 store_code not in ('722','803','8000') and 
--store_code not in (@storecode) and 

date_closed is NULL and 

global_tax_code is not NULL and

store_type='S'

--select * from ##tbl_STORE_LIST
 
DECLARE @store_code nvarchar(20)
 

DECLARE store_code_cursor CURSOR FOR SELECT DISTINCT store_code FROM ##tbl_STORE_LIST
OPEN store_code_cursor
FETCH NEXT FROM store_code_cursor INTO @store_code
 

WHILE @@FETCH_STATUS = 0
BEGIN
EXEC XP_CmdShell 'BCP "Select * from ##tbl_STORE_LIST" queryout "\\dalsqlposdev2\RADATA\Debopam\TRAFFIC\ACTIVESTORES.txt" -c -T'
 
FETCH NEXT FROM store_code_cursor INTO @store_code
END
CLOSE store_code_cursor
DEALLOCATE store_code_cursor
 
DROP TABLE ##tbl_STORE_LIST
end