http://www.support.microsoft.com should be able to help you find the differences.  As far as which one you should load depends 100% on what YOU are going to be doing....

instead of having SQL code inside DTS package create a stored procedure you then call that instead and no need to modify DTS

Try

CASE Code_Field WHEN 1 THEN Value + 100 ELSE Value - 100 END AS Calculated_Value

What you can do is either

A.  Build 3 different queries and then run whichever one the customer selected.  Pro cuts down execution plan.  Con multiple places to make same change

B. ...

SELECT DB_NAME()

In addition to Noel's response:  Is there data involved?  Is this Production?  Is this acceptable from your IS security team's persepective?  Was this checked to ensure that virus/worms/other nasty stuff...

Not recommended but another approach

SELECT SO.[name], SC.colorder, SC.[name]

  FROM (SELECT [id], [name] FROM sysobjects WHERE xtype = 'U') SO

    INNER JOIN syscolumns SC ON SO.[id] = SC.[id]

WHERE SO.[name] = 'YourTableNameHere'

ORDER...

Dougiii,

If you add Company as part of the SELECT TOP 1 for returning data you would get one item per Company.  I generally do not hand ALL the code...

Why not use a derived table to join to?  IE... INNER JOIN (SELECT TOP 1 stuff from CompanyContact) CNTCTS and

Short answer is no.  Once they roll off they are gone

You are trying to skin the dead cat of getting yesterday the hard way.  Why not use something like

BETWEEN DATEADD(D, -1, CONVERT(CHAR(10), GETDATE(), 101)) AND CONVERT(CHAR(10), GETDATE(), 101)

Yes I know...

The way we do it here:

We all have our own web servers (on laptop) and connect to the same DB on a test server.  We all ID what we are...

Try using QA for the View.  Granted this is not a GUI but is a better place to perform development.  This way you can specify INNER JOIN, LEFT|RIGHT JOIN etc..

I guess that I am being a little dense today.  IF you ALREADY have grouping already established WHAT is the purpose of "making up" GROUP 1, 2, etc... when based...

I know it's early but (my upfront way of saying this may be crazy) but...

1.  I know that tempdb is re-created everytime that SQL is restarted. 

2.  Doesn't it use model...