422,754 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,754 IT Pros & Developers. It's quick & easy.

convert this query into storeprocedure

P: 1
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
Share this Question
Share on Google+
1 Reply


Frinavale
Expert Mod 5K+
P: 9,731
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.