Viewing 15 posts - 2,071 through 2,085 (of 2,469 total)
Steve - you've done it again!
It always amuses me to see the meandering path that a post takes & see it veer totally off course....it's amazing the vast array of...
June 24, 2005 at 10:10 am
Jay - gender reversed Lysistrata (LOL) is absurd indeed - kinda like digging your own grave that....
As for men being workaholics (more men than women ie) - I think it's...
June 24, 2005 at 8:07 am
okay - if you want a single statement then this should work...
IF (SELECT count(*) from contracts where (nextperiod) - (lastpd) > 0) > 0
BEGIN
UPDATE contracts
Set printedpd = nextperiod,lastprinted = getdate...
June 24, 2005 at 7:37 am
Michael - can you not create a stored procedure and do separate updates based on "(lastpd < nextperiod)" ?!
June 24, 2005 at 7:31 am
sorry - that doesn't conditionally update either....will get back on this!
June 24, 2005 at 7:27 am
AJ - your query checks if the rows meeting the criteria exist but do not do a conditional update....
Michael - you may want to try something like this (haven't tested...
June 24, 2005 at 7:08 am
Andy - I spent so much time looking at that money datatype and still couldn't come up with this....GREAT!
June 24, 2005 at 5:00 am
Do you mean you want to prevent giving them access ?! Why can't you just delete them from the roles that they are members of or delete the individual users...
June 23, 2005 at 11:47 pm
I think password set to "blank" is a stroke of genius - who'd ever think it could be that?!?!
Are you sure the "little book" wasn't to write down names &...
June 23, 2005 at 11:26 pm
Remi - you don't read carefully enough - I did qualify by saying that it is a "fact" (proven) - not my personal opinion!
June 23, 2005 at 10:44 pm
Remi - Curtis may mean using "alter procedure"....since he says he cannot change it directly in the database!
Of course I could be totally wrong (not surprising that....)
June 23, 2005 at 10:41 pm
"Behind every great man...."
I keep coming back to this everytime - telecommuting is such a perfect solution that I cannot see why more companies do not offer this to their...
June 23, 2005 at 10:31 pm
here's a link that discusses the exact same request - you might find your solution here...though there's nothing quick and easy!
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=151824
June 23, 2005 at 3:12 pm
yes - I read the article - (there would never have been a fight 'cos I'm too nice!) <;-)
I don't give a %$#& if he's GOD himself - yes, I...
June 23, 2005 at 2:17 pm
Did you win ?! When ?
is it weekend in Canada already ?!
ps:I know you're a huge fan but I'm sorry I don't like his style - it's one thing to...
June 23, 2005 at 1:55 pm
Viewing 15 posts - 2,071 through 2,085 (of 2,469 total)