Q: on stored procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

In a stored procedure I've a WHERE condition which asks for the following
date parameters:

BETWEEN @D_Start AND @D_End

When I run the query, the window comes up with D_END and then with D_Start.

The strange thing is that D_Start should come up first and then D_End. An
other phenomenon is that D_End is converted to upper case to D_END.

I'm lost. Why is this happening?

TIA

Ana


.

Relevant Pages

  • Re: What is the "@" for?
    ... where you got that query from? ... I bet it was from a stored procedure, if that is so you cannot use it from ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: optional parameter in sql query
    ... I want to use the td column in the query only if @td variable is ... passed to the stored procedure. ... Thannks ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • RE: Saved Queries
    ... That is default for what Active Directory shows in it's browse window... ... > When I save the query, the only columns I get are: ... Prev by Date: ...
    (microsoft.public.windows.server.active_directory)
  • Help with Stored Procedure Execution Speed - Delphi 6
    ... I call the stored procedure using a TADOQuery passing the ... query because I think I read somewhere that that should help. ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Stored Procedure - Obtaining Output
    ... I would like to set up a stored procedure that does the following... ... How to I trap the output of this query! ... Wez ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)