I would like to...

The ABS function returns all values as positive. Syntax: [Code]ABS(arg)[/Code]

Thanks, all.

[Quote]Goodguy, I know my code fails on one of those tests but I kept the date manipulation as per original logic. I don't know why but seems he is intentionally...

FORMULA#1 - BARRY

Select Room

From Rooms R

WHERE Not Exists

(

Select * from ReservationRooms RR

Where R.Room = RR.ResRoom

And CHECKINDATE < @DATEOUT

And...

Remove the quotes around the zeros.

[Code]ADD column1 money NUlL DEFAULT 0,

column2 int NUlL DEFAULT 0,

column3 money NUlL DEFAULT 0[/Code]

Thanks, both of you. GSquared, your solution is more accurate.

I decided against triggers and instead will extend all my INSERT and UPDATE statements to include the app.user.name and date.time values for the InsertedBy and InsertedOn columns which I can...

What about [Code]UPDATE inventory SET iLease = ABS(iLease - 1)[/Code]

[Quote]I am notr getting clear with the difference between a login, user and a role.[/Quote]

A LOGIN is an account that allows you to connect to a specified instance of SQL...

Thanks, I think I figured out the solution I need.

Phew, this is more complicated than I'd bargained for. No, the INSERT, UPDATE, DELETE statements are not executed via sprocs but via ADO in VB6 instead.

My thinking was to...

Thanks to all those who responded.

Pardon me if I sound a bit junior, but depending on why it is required, wouldn't it be a good idea to simply generate a table script to get all...

Shouldn't that make it obvious that the Public role has no rights beyond SELECT?