TheSQLGuru (4/1/2010)

---

I only mentioned the index cleanup investigation because the OP stated concern about having so many indexes on the table.

I disagree with your statement that not many...

Bob

ISDATE returns zero for a NULL date.

Thank you, Bhuvnesh 🙂

The following code illustrates three possible solutions:

DECLARE @Table

TABLE (

group_id INTEGER NOT NULL,

...

I would tend to prefer the synonym approach - assuming the database in question is SQL Server...

Yes. Compatibility levels are not perfect. ...

chrismat (4/1/2010)[hrApparently the entire query window becomes the SP and doesn't stop at the END; statement at the end of the CREATE PROCEDURE... I didn't realize it would do...

Setting up a robust and efficient auditing scheme can be a lot of work, and hard to get right.

If you are planning to upgrade to SQL Server 2008 any time...

One simple approach is to script out all the...

I wonder how long it will be before someone complains that this QotD is misleading and incorrect since the question specifies "(yyyy/mm/dd)" format and the answers are all in YYYY-MM-DD...

Hugo Kornelis (4/2/2010)

---

Here you specify a string constant, using the 'yyyy-mm-ddd' format. SQL Server will convert the string constant to a date. Although the 'yyyy-mm-dd' format is not guaranteed to...

Ok, I have fixed the code in the original post to avoid anyone else using it by mistake.

The new version uses a nested REPLACE:

GO

CREATE FUNCTION dbo.IF_CleanWithReplace

...

The following code is not fully robust (it may depend on evaluation order in places) but should give you some ideas.

DECLARE @Garbage

TABLE (

...

If only...:-)

I absolutely agree.