varchar cause there are letter in it  'A1A00001'

status_count...

Here's another way to post "Readily Consumable Date" followed by a different solution that uses the SUM() Windowing Function.

Here's the test data construction...

--===== Create the test...

Something like this. Calling your table 'table' is a really bad idea, because 'table' is a reserved word - that is why I have surrounded it with square brackets...

The #t that Phil is using is what you...

Thank you Phil

WITH Temp
AS (SELECT tab = SUM(tab.status) --  total_nber_of_status
    FROM Table)

SELECT tab.statut_code, -- x, y, z
tab.status,
    Rate = tab.status * 100...

Honestly, I don't end up with the #t, ct etc.

I tried to replace anything regarding my data but didnt work

Sorry

It worked. I will try to do the same with my data and let you know! Thanks

• This reply was modified 3 years, 4 months ago by TheNewbie.

Thanks !

I have a table with 'statues' column. I can have the total number of each statut(x,y,z) with count. (MS SQL)

​
|status|  count(status) |
|x   ...