Viewing 15 posts - 42,496 through 42,510 (of 59,067 total)
Gianluca Sartori (8/5/2009)
1) You could send a mail to all users from a trigger.
2) Insert the rows into a message table from a trigger and...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 11:35 pm
AND you posted this on both the 2k and 2k5 forum! You know better than to double post! All it does is tick people off. Stop it....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 11:29 pm
Duplicate post... no responses here please. Goto http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 11:26 pm
Duplicate post... no responses here please. Goto http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 11:24 pm
Duplicate post... no responses here please. Goto http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 11:21 pm
Gianluca Sartori (8/5/2009)
select
nameofmarket as "market",
sum(sales) as...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 11:05 pm
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 11:01 pm
AND you've been around long enough to know how to post data to get help. If not, please reread the article at the first link in my signature below....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 10:50 pm
...and the checksum algorithm is nothing more than a simple "Exclusive OR" at the byte level. It does NOT quarantee that two rows are different and it doesn't guarantee...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 10:46 pm
Heh... get busy Karthik... you know how to use a Tally table with an outer join. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 10:39 pm
Ian Scarlett (8/5/2009)
Jeff Moden (8/5/2009)I do wish that MS would come out with type inheritance in the definition of parameters and variables.
Isn't that what UDTs go some way to providing,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:33 pm
Ok... here's the code that actually does the split by month segment instead of by day. The reason this had to be done is that the 11 row example...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:26 pm
aktikt (8/5/2009)
Jeff, thanks for your patronizing complements... Just kidding.
By the way Aktikt, just to be clear... I never patronize... it's either praise or pork chops. No in between....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 8:09 pm
As a side bar... There is a rumor (and I STRESS the word RUMOR!) I heard and I can't confirm it or deny it. The rumor says that when...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 7:53 pm
RBarryYoung (8/5/2009)
Dang, someone told me last year what causes that and I can't remember ... 🙁
Heh... obviously you can't remember who that someone is either. 😛 If you...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 7:35 pm
Viewing 15 posts - 42,496 through 42,510 (of 59,067 total)