Pam/Mike thanks this is great!

Thanks noeld, unfortunately I'm looking for a method for capitalizing all words, this works only for the first word.

Define an ISOLATION LEVEL at the beginning of your stored procedure.

An isolation level determines the degree of isolation of data between

concurrent transactions. The default SQL Server isolation level is

Read Committed....

Begin Tran ChooseAName

Set @Error=0

update

set [field]=value

Set @Error=@Error+@@error

delete from

where [condition]

Set @Error=@Error+@@error

--keep store the last @error value, if there is no error the value of @@error will be zero...

I'm missing the key between #Requests and #RequestAuditTrails. stax68 says t.RequestID = r.RequestID but there is no...

It means that usually providers creates a folder named PUBLIC, this folder usually has write permissions.

Do you see a folder named PUBLIC in your website?

Or, do you host your website?...

Nether do I. Degree in Economics and Commerce, I "always" worked in the "computer" environment. And, I AM A WOMAN. This is usually a MEN's job....

The fist job that I've...

What do you mean?

You can do this

Insert into Table (column1,column2....)

select columna, columnb....

Where [condition]

Is this the answer that you were looking for?

Claudia

Usually I get this message when I don't have write permission on the folder, in your case the root. I think that you have to move your database and change...

Why don't you use this one

CASE

WHEN Application+UserID = 'APP11' THEN 'P'

WHEN Application+UserID  in  'APP12' THEN 'R'

WHEN Application+UserID  in  'APP13' THEN 'R'

ELSE 'UNKNOWN'

If UserID is a number you need to convert the number in varchar...

Try this one

SELECT *

FROM Table1

WHERE not exists (SELECT 1 FROM MyView where Table1.ClientNumber=MyView.ClientNumber and Table1.CaseNumber=MyView.CaseNumber )

As you can imagine this can be extended to n columns.

Claudia

Are you sure that you need all rows?

You could do

Select top X * from

and use a button to show all datas if users need it