select TW.ClientCode,tw.word - sequence column here from next bit of sql from Tblwords TW where clientcode='54553002' group by TW.ClientCode, TW.ClientCode,tw.word
declare @string varchar(1000)='OCEAN' this would become tw.word select ( select cast(ascii(substring(@string,N,1)) as varchar(5))+',' from [dictionary].[dbo].[fnTally]() nr where nr.N<=len(@string) FOR XML PATH('') ) as ascii_seq
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.