You may want to spend a little time reading about sp_executesql in BOL (Books Online). Based on the example there this is the code I came up with, but...

Need to ask why? Presentation of datetime values should be handled by the UI.

Is there a trigger on the dbo.Lead table that may be causing a rollback of the transaction? Are you getting any kind of error message?

Flo,

You indicated that this is an x86 version (32-bit) of SQL Server 2005 and that PAE is enabled on the OS, is AWE enabled for SQL Server 2005?

Is the server...

I have to ask, but why can't you modify the restore method?...

Gift Peddie (10/27/2009)

---

Lynn,

That is very good example but you will find most T-SQL developers write the old one even in SQL Server 2005 and 2008 and SQL Server in most...

Gift Peddie (10/27/2009)

---

I am not talking...

Gift Peddie (10/27/2009)

---

I had a multi-table query with a left join against some of the tables, one table in particular was not referenced (yet) in the select nor in...

I have to agree that experience is extremely helpful. You learn about things that you may not have known about otherwise. I have experience in computer operations, systems...

Alvin Ramard (10/27/2009)

---

Jack Corbett (10/27/2009)

---

Thanks Jon. I think I've seen it before, but couldn't remember. Just feels weird typing jcrawf02 when replying or referring to you especially in...

J-F Bergeron (10/27/2009)

---

Well, the first thing I saw was the multi cross join you have between the deleted, inserted, and your table, in your select, in the trigger. Next is...

I just did a little research myself and it appears that w3wp.exe is part of IIS.

Gift Peddie (10/27/2009)

---

But we aren't talking about ANSI Standard. We are talking about MS SQL Server and most of us will use the features and capabilities of MS SQL Server...

Please read the first article I reference below in my signature block regarding asking for assistance. Follow the instructions in that article regaring posting the DDL (CREATE TABLE statements),...

The problem with your question is that there isn't enough information to actually give you an answer. We really need more information to help you.