How can I convert this sql query to a stored procedure?

[akocjello]

SELECT DISTINCT  broker,
COUNT(case when cntsze=20 then cntsze end) as '20',
COUNT(case when cntsze=40 then cntsze end) as '40',
COUNT(case when cntsze=45 then cntsze end) as '45' 
FROM CYMgps
WHERE ( sysdte BETWEEN '2012-11-01 00:00:00' and '2012-11-30 23:59:59')
GROUP BY  broker
ORDER BY broker asc

[Uncle Dickie]

Start it with:

USE <database>
GO
CREATE PROCEDURE <procedure_name> AS
 
-- your query here

If you need to edit it in future:

ALTER PROCEDURE <procedure_name> AS

[ravikumarr]

hi akocjello,
create the procedure like below.
create procedure procedurename
as
begin
//write the query u want to perform
// e.g select * from tablename
end


then

execute procedure procedurename

[NeoPa]

When you choose to create or add a new Stored Procedure all these heading and trailing bits are inserted for you. You simply need to fill in the name etc. and the SQL and save it. It's hard to imagine why you would need to ask such a question unless you hadn't even looked at it for yourself first.

[ravikumarr]

how to pass the immediate values to load event

[NeoPa]

What do you mean by "load event"? I know of no such concept.

I can guess you mean literal when you say "immediate", but I'm still left with no idea what your question means.

[akocjello]

thanks for the reply

NeoPa i looked it for my self but when i tried to do it i always encountered an error... but now it works :)
can i ask another question?

[NeoPa]

You certainly may ask a new question, but just as certainly not in this thread.

Each question must be asked in a separate thread of course, but the question you want to ask should also be asked in a different forum. You won't find that many VB.NET experts that frequent this (SQL) forum ;-)

[akocjello]

Sorry NeoPa im new in this forum and i dont know that... thanks for telling me

sorry again :)

[NeoPa]

No need to worry at this stage. I can see you are new and nothing you've done yet has been a problem.

[akocjello]

thank you for all the reply :)
i made it. now my program is 90% done :)


thanks again :)