From ss2k5 help:

You can use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from...

I think it will delete the old backup files only if you have not created them in separate sub directories.  This a know bug.

ron

If you put the information that they "just know" into the database then you will be able to run your query

I'm not sure that query will allow the use of any index that may exist on ARJOBHD.INVDATE.

Could be a big problem if there are many rows!

RON

From BOL:

< select_list > ::=

    {    *

        | { table_name | view_name | table_alias }.*

        |     { column_name | expression | IDENTITYCOL | ROWGUIDCOL }

            [ [ AS ]...

As David pointed out,

begin

select ls_action = 0

end

and

BEGIN

SELECT 0 AS ls_action

END

are equivalent.  The first form is from very early versions of sql server and dates back to the...

SET NOCOUNT ON

CREATE TABLE #TEMP1 (

C1 int NOT NULL,

C2 char(1) NOT NULL,

ROWID int IDENTITY (1,1) NOT NULL)

INSERT #TEMP1 VALUES (1,'A')

INSERT #TEMP1 VALUES (1,'A')

INSERT #TEMP1 VALUES (1,'B')

INSERT #TEMP1 VALUES (1,'C')

INSERT #TEMP1...

If we could see the relevant portions of the actual code we might be able to spot the problem.

ron

It sounds like your application has a table named 'staff table' and in addition to all you have done, someone needs to enter the new user id into the staff...

Have been looking for a way to do this myself.  So if someone has a solution please post it.  Thanks.

BTW, where i.col2 <> d.col2 will NOT give the...

And to complete the quote from the article:

"...I say "usually" because with the addition of nulls to the relational model things get a little more complicated.

Nulls add a third value...

"...However, I have never understood NULL to work like this. Not even in other relational DBs I have worked with. It always behaves as if NULL is 'unknown'..."

Yes! I could...

The ALTER statement will only take affect at the end of the batch.  The end of the batch in this case is the entire stored procedure.

If you put your code...

In some cases an error in a stored procedure will cause it to abort without ever setting the return code.  If the variable you are using to store the return code...

The position of the column within the table does not matter.  If the datatype is "timestamp" then do not reference the column name in the list of columns and do...