I am not in aposition to test it, but this should be cloes:

Select V.[Vendor ID], CY.TotalBags as [Bags Last Year], LY.TotalBags as [Bags This Year]

From Vendors V

Left Join (Select...

Peter (11/4/2008)

---

Case 1) If I implement the two main procs exclusively in T-SQL, the only way I know is to check the FoodType and then query the appropriate tables. Essentially,...

If you must do it in triggers (and seriously, you would be much better off using Karl's suggestion of stored procedures), then at least you should not use CONTEXT_INFO which...

As I said the first time that you asked this question:

If @@ROWCOUNT is already set then you should use it....

As I said the first time you asked this question:

The general thinking is to prefer derived tables because they leave the...

As Jonathan said: "getdate()" needs to be the definition of the column's default value, and not the definition of the column itself.

J (11/3/2008)

---

Never used CLR yet. This was supposed to be the greatest thing since sliced bread.

Jeff, would you please enlighten me as to why CLR is viewed as a bad...

Glad we could help.

Here is the VB.net code that I use to do something similar (discussed at http://www.sqlservercentral.com/Forums/FindPost494720.aspx):

Imports Microsoft.SqlServer

Imports Microsoft.SqlServer.Management

Imports Microsoft.SqlServer.Management.Common

Imports Microsoft.SqlServer.Management.Smo

Imports Microsoft.SqlServer.Server

Imports system.Data

Module Util

Public Sub Servers_List(ByVal lstOut As...

Yes, that is correct. You have to change it in the registry.

Please provide the DDL's including any keys and indexes for STAGE.DEAL_DETAIL and STAGE.REF_DEAL_STRATEGY.

Though frankly, what this suggests is that the database that you are switching to with "USE [dbname]" is different from the database where you generated the script from and where...

Please show us the version that works and the version that does not work. This is usually a matter of detail and we need to see the details.

OK, that makes more sense then. I have on very rare occasion seen things like this in SQL 2000, but never in SQL 2005 (note, this is a SQL...

What version of SQL Server? And what is the definition of the [password] column?