>>What is the advantage of using Where Exists here?

The advantage probably only appears once you reach a certain volume of data being returned from the IN () sub-query. How many...

>>Now my question is, is there any issue in using a subquery instead of an Inner Join here?

There is a huge difference depending on the cardinality of the data.

If table...

>> can only tell which part of the proc is running by view what files it is updating and by check for certain data values I expect to see

If you...

Are you in the correct database context when running this ?

>>where 'obs_object_types' is the name of a table (this does exist and with the expected stucture)

If you use full...

IF EXISTS (

  SELECT *  from t_RATE a

   join t_ZIP b ON a.state=b.state

   WHERE a.zip = @ZipFrom&nbsp

BEGIN

END

>>In SQL2000 the list is ordered by parentlft and in SQL2005 the list is unordered. 

It was/is a hack in Sql2000 and worked by accident.

A view is just a virtual...

When importing from Excel, the driver reads a small number of rows from the worksheet and makes a best guess as to their datatype. In this case, it is probably...

>>why would you want to leave this for programmers to have to remember to do. 

Well, someone, somewhere has to rememebr

What happens when a...

If an error has a high enough severity, you can't trap it because the entire batch is terminated and rolled back at that point. Your "If @@Error .." statement never gets to...

You can find the program name of the session from this:

Select program_name from master..sysprocesses where spid = @@spid

You can run the trigger code conditionally on what that returns. However, it...

2 choices.

If you have a transform data task, then for the column in question use a VBScript transform and use the VBScript Replace() function to strip the '-'.

Alternatively, load it as is,...

Some questions & observations ...

- How many rows are in temp table #t ? it is being table-scanned.

>>where CSP.ProductId in (Select ProductId from #Products)

How many rows does this sub-select return ?...

What is the maximum number of values that can be in the DataValue column ?

SQL 2K is version 80.

That means you are running the database in Sql Server 7.0 compatibility mode, which means SQL2K features aren't available.

What is your database compatibiliy level set to ?

sp_dbcmptlevel 'NorthWind'