Thank you all for your response. You've been of great help.

Jonathan: your solution works well and its the cleanest as well. Thanks!

Around 15,000+ records get loaded on each run (records are inserted from another table as part of a transaction in a SP) and the table will be accessed by a...

Ok. I've normalised the table as follows:

Table1.ID - Table1.PlaceHolderText

------------------------------------

1 - Hello [Name], Is your age [Age]?

Table2.FKID - Table2.PlaceHolderName - Table2.PlaceHolderValue

--------------------------------------------------------------

1 - Name - John

1 - Name - Lucy

1 - Name...