468,469 Members | 2,200 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,469 developers. It's quick & easy.

convert this query into storeprocedure

SELECT org_id, count(distinct entry_id) as entry_point, sum(total_device) as total_device, sum(active_device) as active_device,
sum(total_tablet) as total_tablet, sum(active_tablet) as active_tablet,
sum(total_desktop) as total_desktop, sum(active_desktop) as active_desktop, sum(in_cnt) as din_cnt, sum(out_cnt) as dout_cnt
FROM dashboard_device GROUP BY org_id
Mar 12 '18 #1
1 1876
9,735 Expert Mod 8TB
Use the Create Procedure statement to create your procedure...

See this documentation for the CREATE PROCEDURE and CREATE FUNCTION Syntax.
Mar 12 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Michel Walsh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.