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...
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
June 24, 2005 at 7:37 am
Michael - can you not create a stored procedure and do separate updates based on "(lastpd < nextperiod)" ?!
**ASCII stupid question, get a stupid ANSI !!!**
June 24, 2005 at 7:31 am
sorry - that doesn't conditionally update either....will get back on this!
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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!
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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 &...
**ASCII stupid question, get a stupid ANSI !!!**
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!
**ASCII stupid question, get a stupid ANSI !!!**
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....)
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
June 23, 2005 at 1:55 pm
Viewing 15 posts - 2,071 through 2,085 (of 2,469 total)