You can use a WHERE clause with an UPDATE statement in T-SQL.

UPDATE Table

SET database_name = db_name()

WHERE database_name IS NULL

Unless the table has a defined IDENTITY column, or you've come up with your own sequencing scheme, the system has no way of magically tracking which rows were inserted last.

Even...

Let's make sure the logic is working as expected first.

Try adding a little debug code just before you send the email. Write out...

I believe you are confusing EXEC @sql with "parameterrized dynamic SQL" which requires that you EXEC sp_executeSQL.

If you want to use EXEC by itself,...

Nyuck, nyuck, nyuck.

Jeff Moden (12/6/2010)

---

The Dixie Flatline (12/6/2010)

---

If I understand you correctly, you always want the start and end dates from the prior month, regardless of the starting and ending date that...

If I understand you correctly, you always want the start and end dates from the prior month, regardless of the starting and ending date that you provide. ...

To all the people in the U.S.: Have a happy Thanksgiving.

To everyone else. Have a happy Thursday. 😀

Yes, it will mean less space and better I/O.

As has been pointed out, this approach makes you responsible for remembering to divide by 10 forever. If you...

I can't get this out of my head now.... and I can't stop myself from posting this.

Instead of vuvuzelas for soccer, fans could start carrying bokkens to rugby matches in...

GilaMonster (11/18/2010)

---

CirquedeSQLeil (11/17/2010)

---

I love finding out that a project has a dependency on a task assigned to you - when everything else is done and ready to be deployed. ...

Paul, thanks for the reply. I understand now.

Paul, I ran the code and saw the log entries, but I wasn't doubting his word.

Let me rephrase the question: What is the purpose...

You're very tiny! (j/k)

Nice shades though...

Congratulations, Wayne. Applause! Thunderous applause

Let me ask what logging takes place with table variables, since they are not affected by rollbacks.