The article implies that logic to maintain integrity should not reside in the database.  I couldn't disagree more.  You either put logic in the database, or you clean garbage out.  It's...

Remi:

Using a permanent table instead of a temporary table to hold the information is a bad idea for a couple of reasons.  First, it is much more difficult to support multiple users...

The temporary table method works fine from both ado and ado.net.

You create a temporary table by executing a "CREATE TABLE #tableName" statement from the connection object in ADO.  On the...

You're going to need a loop, and if you have multiple rows, a cursor to fetch through the rows.

For each row, first replace every LF with CR

SET @value = REPLACE(@value, CHAR(10),...

I learned many years ago not to completely trust any other developer.  A stored procedure could be called by another application written by another developer.  It only costs a few extra...

You can pass a temporary table to a stored procedure.  Just create the temp table and populate it before you call the sp, and drop it after you've executed it.  That's...

In order to do that, you must ensure that you are using set-based operations in the triggers.  If you must use a cursor, use an INSTEAD OF INSERT trigger and...

Be careful when using this UPDATE syntax.  Make sure you always specify OPTION(MAXDOP 1).  I've been burned in the past.  Another problem is that you cannot specify an ORDER BY clause...

Here's a quick and dirty example of how to select the result of dynamic sql into a variable.  You need to wrap the sql statement in a temporary stored procedure...

I ran into the same kind of error.  It turned out that the query I sent it was just too much for poor SQL Server 2000 SP4.  I called Microsoft...

Look up KB296642.

Why don't you try an instead of update trigger?  Replace the MODIFIED_DATE with GETDATE() in the UPDATE statement.  Since the instead of update eliminates one of the update statements, the deadlocks should...

OOPS! You're right, it should be / 5) * 5

Assuming that your table is like:

CREATE TABLE temperatures

(

TempTime DATETIME NOT NULL,

Tempurature FLOAT NOT NULL

)

Here's your query:

SELECT [Hour], CAST(StartingInterval AS CHAR(2)) + '-' + CAST(StartingInterval + 4 AS CHAR(2)) AS interval,...