It doesn't seem possible in the application to edit a Service Request created by a template and apply a different template. (wrong template applied in the first place).

Is there a DB query that can accomplish this? I want to get rid of some obsolete templates but I can't since they are being used. (marked for no further usage now). If I could get the request id's that are using the obsolete templates, (which I have a query for already), then I would like to apply the newer template to the request. Keeps reporting nice and neat.

Regards,