Home Forums SQL Server 7,2000 T-SQL Modify WHERE clause in Stored Procedure RE: Modify WHERE clause in Stored Procedure

  • Hm, can you show me how to get this running?

    declare @open bit

    set @open = 0

    SELECT * FROM orders

    WHERE

    shippeddate

    CASE @Open

        WHEN 0 THEN

              Is Null

         ELSE

             IS NOT NULL

        END

    Server: Nachr.-Nr. 156, Schweregrad 15, Status 1, Zeile 6

    Falsche Syntax in der Nähe des CASE-Schlüsselwortes.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]