Viewing 15 posts - 1,831 through 1,845 (of 2,840 total)
I can hold m ground in English but I am not coming anywhere near you Gus.... 😛
June 30, 2009 at 1:42 pm
So I assumed, and was apparently incorrect in that. (I hope this wasn't obfuscatory. I'm trying to be as precise as possible here, and am now assuming singular English literacy.)
That...
June 30, 2009 at 1:16 pm
Lynn Pettis (6/30/2009)
Mind decoding your dates??
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...
June 30, 2009 at 1:11 pm
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...
June 30, 2009 at 1:05 pm
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...
June 30, 2009 at 12:53 pm
LOL... I got my post count high...:hehe:
June 30, 2009 at 12:33 pm
At least I am not dead yet.... I am not a ghost....:hehe:
June 30, 2009 at 12:23 pm
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
June 30, 2009 at 12:11 pm
Today I actually felt that I am invincible or totally ignored. It was as if I was a ghost... 😛
June 30, 2009 at 12:08 pm
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...
June 30, 2009 at 11:38 am
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...
June 30, 2009 at 11:34 am
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...
June 30, 2009 at 11:12 am
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...
June 30, 2009 at 11:09 am
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'
??
June 30, 2009 at 11:04 am
Viewing 15 posts - 1,831 through 1,845 (of 2,840 total)