rewrite code to eliminate isnull

Question

rewrite code to eliminate isnull

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

You cannot include GETDATE() inside a UDF, you can however make an input parameter to accept it. It comes from the hole deterministic/non-deterministic rules.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

To add to Antares, here's an example what can happen, when you choose to workaround this GETDATE() - UDF issue with a view, which is sometimes suggested.

http://www.insidesql.de/content/view/100/

It's in German, however the code speaks for itself.

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

Bob Snyder Right there with Babe Points: 727 More actions · Answer 3

Nullable columns do cause the query analyzer to double pass - once for nulls and once for non-null.
May I suggest creating a view of your data to handle the nulls, then select from the view.

CREATE VIEW tableA_vw AS
SELECT ISNULL(datecol,getdate()),
.
.
.
FROM TableA

Select col_a from some_table

where Date_col = (select date from tableA_vw where id=host_id())