Results 1 to 5 of 5

Thread: Stored Procedure ? double parameters

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2007
    Posts
    4

    Red face Stored Procedure ? double parameters

    Hello guys;
    I am Turkish people. Why ? Because my question is not %100 english language ok?

    Now my question..

    i'm using VB6 and database is MSSQL

    my Stored Procedure is
    Code:
    create procedure dbo.AracYuklemeProc 
    @personel varchar(10),
    @guntarih datetime
    AS
    SELECT     SUM(hesaptoplami) AS AracPerToplam, perkodu, tarih, SUM(ISNULL(paramiktari, '0')) AS ToplamTutar,
    SUM(ISNULL(personelbakiye, '0')) AS PerKalan, 
                          SUM(ISNULL(tutar, '0')) AS BorcTutar
    FROM         dbo.AracYukleme
    WHERE     (hesapkapat_flag IS NULL) and perkodu=@personel and tarih=@guntarih
    GROUP BY perkodu, tarih
    GO
    
    tarih =date
    perkodu=personel code
    hesapkapat=close the acount
    others is others :-)
    now..

    in VB DAtaenvironment name=Sigara
    connection(OBDC) name = baglanti
    commandname=AracYukle

    tarih from -> dtpicker1.value
    perkodu from ->text10.text

    and Question

    how can i this procedure (double parameters) use in my forms

    Please.. I need your help ?

    Pardon .. VB to MSSQL Database connection
    ADODC1 (ODBC)
    Last edited by Hack; Nov 25th, 2007 at 04:40 AM. Reason: Added Code Tags

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Stored Procedure ? double parameters

    Moved to Database Development

  3. #3

    Thread Starter
    New Member
    Join Date
    Nov 2007
    Posts
    4

    Re: Stored Procedure ? double parameters

    ok. i'm happy for read my post. but ask ? because i need your help

  4. #4
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Stored Procedure ? double parameters

    I tried to comprehend what you are asking but I cannot.

    Please try to reword what you are trying to accomplish. Don't write a book - a couple of sentences to see if we can better communicate.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  5. #5

    Thread Starter
    New Member
    Join Date
    Nov 2007
    Posts
    4

    Re: Stored Procedure ? double parameters

    ok. i'm not writing this message, you to think. Thanks All.

    but i want to just help. if you dont understand my message. you can write "i dont understand your messages, more explanation".

    but! no problem. thanks all again..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width