I have a query just to show 1 client code as a demo. I would like to update the [strshort] column to be populated like this:
any words not in the TblWordTags to be used in the creation of the short string:
word 1= "A3"
word 2 ignore as it is in TblWordTags
Word 3 = Sport
query must update StrShort in this example to A3 + chr32() + Sport
The order of the rebuilt short string goes in same order just minus the words we dont want.
I am in a vb.net windows application pulling data from Sql server db Dictionary. I am not sure how to create this query, can it be done soley in sql server and then run as a stored procedure or do I need to pull the data in and create a function to do it?
. I only need to do the operation for clientcodes that have tagged words in TblTagWords.