Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: stored procedure

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

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    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.
    MeanOldDBA
    derrickleggett@hotmail.com
    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
  •