Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
select tw.ClientName, TW.StrShort, TW.clientcode, sum(CWC.asciiencode) as AsciiEncodeTotal, sum(CWC.AsciiEncodeClientCode) as AsciiEncodeCCodeTotal, sum(CWC.WordLength) as WordLengthTotal, sum(CWC.NoOfWords) As WordTotal from TblCurrentWordCounts CWC left join tblwords TW on CWC.clientcode=TW.ClientCode where TW.StrShort like'xc90%' and tw.clientcode='54553002' --and TW.ClientName='Smmt'--and TW.StrShort like'%es%118i%' group by CWC.clientcode, TW.ClientCode,TW.StrShort,tw.ClientName order by tw.ClientName select TW.ClientCodeWordPosition, TW.ClientCode, tw.AsciiEncode, tw.AsciiEncodeClientCode, tw.WordPosition from Tblwords TW where clientcode='54553002' group by TW.ClientCode, TW.ClientCodeWordPosition,tw.AsciiEncode, tw.AsciiEncodeClientCode, tw.WordPosition
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Split string into 3 separate fields||5||22|
|Problem Backingh Up Transaction Log on Old SQL000 Database||3||26|
|Access 2010 - Issue Viewing Records Added to a Linked SQL Table||13||50|
|SQL Server XML Select sub tables||4||30|