Use cursor in SQL

 

Declare @ SS varchar (300)
Declare @ CSR cursor
Set @ CSR = cursor
Select statpartno from catalog where flag = 2

Open @ CSR
Fetch next from @ CSR
-- Print @ fetch_status
While @ fetch_status = 0
Begin
Fetch next from @ CSR into @ SS
Print @ SS + '|'

-- ============================================
Declare @ A varchar (8000)
Set @ A = @ SS

Declare @ substr varchar (8000)
Set @ A = rtrim (@)

Set @ substr = left (@ A, charindex ('-', @ A, 0)-1)
Set @ A = right (@ A, Len (@ A)-charindex ('-', @ A, 0 ))
Set @ substr = left (@ A, charindex ('-', @ A, 0)-1)
Set @ A = right (@ A, Len (@ A)-charindex ('-', @ A, 0)-1)
Set @ substr = right ('000000' + @ A, 6)


Print @ substr
-- ============================================

End
Close @ CSR
Deallocate @ CSR

-- DBO. getdistance 'ftm-8020c-s'