Using [Northwind].[dbo].[Orders], how can I get the [OrderID] that
corresponds with the latest [OrderDate] for each [CustomerID]? Grouping on
[CustomerID] and using MAX([OrderDate]) doesn't get me the [OrderID], and I
don't want  to include [OrderID] in the group by clause.

What does it mean when my servers have a white circle instead of a
green circle with a white arrow in it in SQL Server Management
Studio?   My dbs are 2000.
Thanks

I have a stored procedure that has few temporary tables for manipulating
records from multiple tables. In the final temp table i have the following
code:
create table #temp4

I run a DTS package regulary, and have to keep track of the qty's of files
for each part of the DTS. The "results" window at the end cannot be expanded,
thus the results/qtys I have to write down manually, using the scroll bar to
see all the results.

In my table I have a column called Start which contains date and time when
the certain P.O. was added. The same P.O. may be added several times, since
each P.O. may contain many serial numbers. Let's say, P.O. added today, can
be updated tomorrow when more serial numbers added to ...

I have the following query which is need of converting the Height,
Width, Depth data into a number.  It is currently being stored as text
in the database it comes from.  Any thoughts?
SELECT top 100     ltrim(rtrim(UPC)) as UPC, rtrim(HEIGHT) as H,rtrim

I have a table containing some sequence numbers that are being used by a
stored procedure. The procedure reads the current value, increases it,
chacks that it is below athe max allowed value and returns the number. If
the max value is passed, it checks the "allow wrap" flag, and ...

Hi Freinds,
How can I use with commande instead of the loop?
here is what I am doing, but I think there might be smart way of doing
it.

Hi Freinds,
sqL 2005
I have this URL and need to call and pass some parameters and retreive
some other parameters from SQL server

I'm stumped and need some help please... how do I return data from this type
of SP with a SQL statement (this is a simplified SP as an example but
essentially the one I'm working with )?
CREATE PROCEDURE zzzTEST

Between Sql Server 2000 and Sql Server 2005, it looks like operator
precedence changed to give multiply/divide higher precedence than unary
negation.  Which, to my mind, just seems completely bizarre and backwards.
In other words

Let's say I have this table:
field1            field2    field3
4:30:00            5        45
4:30:00            1        45

2 questions:
1. Where can I 'physically' see my DTS job which I created in SQL 2005?  I
can see the inherited 2000 ones.
2. How do I edit a SQL 2005 DTS job?  I need to change the SQL statement.

I have a simple  SQL Agent job that it's one command is to run an sp in the
msdb database, but when it runs I get the following error, " Could not find
stored procedure", even though the sp is clearly in the database. Any ideas?
BTW, here is the error message in the job history:

My problem is : I need converting a column with data type nvarchar (in SQL
SERVER 2000) with format “ddmmyyyy” to other column with data type datetime
(in SQL SERVER 2005) also with format “ddmmyyyy”.
The scene is : There is a OLE DB Source, where in SQL Command text box we