Thursday, February 9, 2012

count string Occurrences in a column and stuff string by number of space stored in another column

select len(YourCol)-len(replace(YourCol,'1','')),space(col2) + col3
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Elevating LLM Deployment with FastAPI and React: A Step-By-Step Guide

  In a   previous exploration , I delved into creating a Retrieval-Augmented-Generation (RAG) demo, utilising Google’s gemma model, Hugging ...

  • 15401 error
    Error 15401: Windows NT user or group '%s' not found. Check the name again. SELECT name FROM syslogins WHERE sid = SUSER_SID ('Y...
  • Change SQL Server Collation in a clustered environment
    start /wait D:\Servers\setup.exe /qn VS=[VIRTUALSERVER] INSTANCENAME=[MSSQLSERVER] REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=[CUR...
  • Epicor E4SE and eBackoffice Go Live
    Finally, it is time. E4SE 811 and eBackoffice 736 will replace our current 810b/735a environment after staying so many years. Just got the n...