IF EXISTS

(

SELECT *

...

Do read Lynn's article - and make sure there's a useful index (leading on cdate).

If you are deleting a substantial proportion of the rows in the table, you might find...

That's not unpredictable...it's a (good) design trade-off.

It's...

We can help the optimiser even more by adding a computed column. This won't add any data to the table - it's just a metadata change - but the...

skcadavre (6/25/2010)

---

Paul, that's great! I was hoping that when the other thread about this came up one of you gurus would come in and shatter my little code. There's always...

Only on 2005 and above, but it is an example of how sophisticated...

Gianluca Sartori (6/25/2010)

---

I can speak for myself: I never read an article on the subject. To arrive at reading an article you have to look for it, if it...

Eugene Elutin (6/25/2010)

---

I though that the join to FeesCategory table in a function, whould ensure something... But I have overlooked that the LEFT JOIN has been used. However, function also...

Eugene Elutin (6/25/2010)

---

Paul, it is quite strange that there aren't many SQL developers aware of it and most of examples of writting UDFs do not mention this at all. I...

Try to avoid writing scalar user-defined functions. Try even harder to avoid writing scalar user-defined functions that access data tables. Instead of writing a function to process one...

SELECT SU.SystemUserID,

SU.ForeName,

SU.SurName,

SR.RoleName,...

You're welcome. Be sure to test before...

Thanks. Sorry I didn't notice your reply before.

Just one question: what does schemabinding mean here? The return value depends only on the input...

Other options:

CREATE TABLE #TransactionTable

(

clientcode VARCHAR(50) NOT NULL,

...

CREATE FUNCTION dbo.IntToDate

(

@Input INTEGER

)

RETURNS TABLE

WITH...