thank you for all the reply :)
i made it. now my program is 90% done :)
thanks again :)
akocjello
Last Activity: Mar 12 '13, 06:07 AM
Joined: Jan 10 '13
Location:
-
How to call stored procedure in vb?
this is my stored procedure... how can i get the value of a datetimepicker1 in vb.net form and stored it in @date1 and @date2
...Code:CREATE PROCEDURE SAT @date1 datetime, @date2 datetime AS SELECT DISTINCT cnsgne, 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
-
Sorry NeoPa im new in this forum and i dont know that... thanks for telling me
sorry again :)Leave a comment:
-
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?Leave a comment:
-
How can I convert this sql query to a stored procedure?
Code: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
No activity results to display
Leave a comment: