I can hold m ground in English but I am not coming anywhere near you Gus.... 😛

That...

I think it is the number of days since 01/01/1930.

"This system uses "date" field that are calculated as # of days since 01-01-1930, and...

Same with me Lynn, Same with me. I am supposed to be writing out a Document/Presentation explaining to the Business owners and Stake holders what they will gain by moving...

David, That was funny... Gail, Grant, Lynn, Jeff, GSquared and all of you the Ghost busters... :hehe:

Lynn, you were posting at break neck speed today.. Jumping one forum to the...

LOL... I got my post count high...:hehe:

At least I am not dead yet.... I am not a ghost....:hehe:

Yes, I think I need more coffee....:-D

In oracle this used to work (If my memory serves me right)..

Select * from tablea where (col1,col2) in (Select col1,col2 from tableb)

You could try that

Today I actually felt that I am invincible or totally ignored. It was as if I was a ghost... 😛

db_datareader is to do Select queries directly on the table, and datawriter to modify. If it is stored procs, you have to give execute rights to the stored proc for...

db_reader and db_writer is not enough to execute stored procs. If all operation is through Stored procs, then you can as well remove those rights and give execute permission for...

Did you try running a profiler to find out what exactly the app is doing that it needs the db_owner? Then you could refine the rights according to what it...

Why not just make stored procs for each job and put a comment in each of these SPs to find out what ticket number it is created for? You can...

Cant you do a

Select a.* from employee as a

JOIN

(Select distinct empNum, fName,LName from Employee) as b

on a.empNum = b.empNum

where date = '30-Jun-2009'

??