High end SQL
-
Found in a stored procedure... Declare @IsClosed bit SET @IsClosed = (SELECT ISNULL(Closed,0) FROM TimeRegHeader WHERE TSID = @TSID) If @IsClosed Is Null BEGIN Select 0 END else BEGIN Select @IsClosed END
-
Found in a stored procedure... Declare @IsClosed bit SET @IsClosed = (SELECT ISNULL(Closed,0) FROM TimeRegHeader WHERE TSID = @TSID) If @IsClosed Is Null BEGIN Select 0 END else BEGIN Select @IsClosed END
Well, you really have to be sure about these things!! :rolleyes:
Knowledge is knowing that the tomato is a fruit. Wisdom is not putting it in fruit salad!! Booger Mobile - Camp Quality esCarpade 2010
-
Found in a stored procedure... Declare @IsClosed bit SET @IsClosed = (SELECT ISNULL(Closed,0) FROM TimeRegHeader WHERE TSID = @TSID) If @IsClosed Is Null BEGIN Select 0 END else BEGIN Select @IsClosed END
Arnaud Lhopiteau wrote:
ISNULL(Closed,0)
belts...
Arnaud Lhopiteau wrote:
If @IsClosed Is Null
and braces. What more do you want?
Panic, Chaos, Destruction. My work here is done.