Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Alpine Califormia

    Unanswered: stored procedure

    nevermind I posted on the wrong one sorry
    Last edited by desireemm; 09-16-04 at 11:09.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    This is really a SQL Server question, but I don't think you can use the BETWEEN like that on a parameter.


  3. #3
    Join Date
    Apr 2004
    Kansas City, MO
    Will it compile? If not, you're guaranteed to have some issues. (It won't by the way.)

    You have some syntax issues.

    1. The parameter thing.
    2. You seem to really like commas a LOT.
    3. I'm probably missing something obvious here, but your date logic doesn't make sense.
    4. You need to take a serious look at that last INSERT and ask yourself if you should be writing SQL. It's kind of like driving a car. You usually want to drive around in a parking lot for awhile before jumping on the race track without a helmet.
    When life gives you a lemon, fire the DBA.

Posting Permissions

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