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
|Help in Copy Database Wizard From One SQL Server to Other SQL Server||10||33|
|Error "String or binary data would be truncated" in an update on a datatable||7||28|
|Whitepapers about how IO performance issue and cause spikes in CPU usage - Microsoft SQL Server||5||27|
|MS SQL Server - Looking to filter rows based on column value||3||9|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!