Popular Posts

  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • The easiest way to start using variables in #dax
    SQLblog.com - The SQL Server blog spot on the web The easiest way to start using variables in #dax I just published a new blog post...
  • The March of AI
    SQLServerCentral » Latest topics The March of AI Comments posted to this topic are about the item [B] The March of AI [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Friday, October 13, 2017

calculation

SQLServerCentral » Latest topics
calculation
Hi,

TOTAL  datatype is (numeric(10,0),null)
STR  datatype is (numeric(20,15),null)


REPLACE(FORMAT(CAST(ROUND((
      CASE
       WHEN SUM(CASE WHEN a.TOTA
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)