sql - What is wrong with the syntax on this case statement? -


i trying insert values temp table via cursor , if have period on end, remove period. here code having syntax issues with.

while @@fetch_status = 0 begin     case select charindex('.',reverse(@category))           when 1         insert #category values (substring(@category,1,len(@category)-1))) end; 

what doing incorrectly here? i'm open more efficient answers know how solve way.

case yields expression, not statement. looking if statement.

as better way this: scrap cursor , use insert ... select ... charindex('.', reverse(category)) = 1 statement.


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -