If exists problem...

Results 1 to 2 of 2

Thread: If exists problem...

  1. #1
    Join Date
    Dec 1969

    Default If exists problem...

    Take a look at the following...<BR><BR>declare @id_to_show varchar(50)<BR>If not Exists (Select task_id from daily_log where task_id = 1 and protocol_number = &#039;555&#039; <BR>and datediff(day,record_date,Getdate()) &#060;&#062; 0)<BR>set @id_to_show = &#039;1&#039; <BR><BR>The if not exists statement evaluates to true however, @id_to_show still does not have the value of 1. What am I doing wrong?

  2. #2
    Join Date
    Dec 1969

    Default Read your response

    in the asp.net forums

Posting Permissions

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