What does tblid represent?
How many previous settings rows are there for a tblid?
How do you want the output to look like (Why PIVOT?)
Please supply table DDL, sample data and expected output.
Far away is close at hand in the images of elsewhere.
Anon.