2003-05-30
Profiler
2003-05-29
RE: Aggregate functions - First, Last, Max, Min etc
quote: In Access, the First and Last functions allow you to retrieve the first or last value (field) within a Group... That is percisely what MIN and MAX do. Example: SELECT OrderGroup, MIN(ReceivedOn) AS EarliestReceived, MAX(ReceivedOn) AS LatestReceived FROM OrderTable GROUP BY OrderGroup
2003-05-29
RE: Aggregate functions - First, Last, Max, Min etc
In Access, the First and Last functions allow you to retrieve the first or last value (field) within a Group, where the order is not by that field (i.e., ordered by some other field). Jay Madren
2003-05-29
RE: Variable where clause
Thank you! That was excactly what I wanted to know 🙂 But then I have another issue of discussion. I thought they could be related but maybe not. Our company upgraded both our software from SS 7.0 to SS 2000 and our hardware to a new cluster configuration. We have alot of similar aggregation SPs' […]
2003-05-27
RE: Row updated?
Hi John, quote: problem of 'updates'. I want to somehow know when a row has been updated. I've been reading about triggers, timestamp (rowversion), programmactically set a flag, etc and at this point I would appreciate some guidance. I'm not sure in which direction the guidance should go. If you want to know how to […]
2003-05-26
RE: Thanks for taking the test!
Very interesting test! Next time I spent more attention, that's definitely nothing you can do by the way when dealing a hedge swap on the phone. The results were devastating Cheers, Frank
2003-05-22
1 reads
RE: Need a good Internet Mail Server
Another thought just hit me. If you're just looking for SMTP (not sure why you need POP), you can install SMTP from IIS and have it with the smart host pointed at the Exchange Server you guys are using to handle Internet mail. Of course, you still have to do with the securing issue. K. […]
2003-05-15
RE: Failover Clustering
Hehehe, I'm not a big fan of partitioned views, either. You also have to consider that for it to work efficiently you have to be able to segment your data somewhat uniformly and that's not always possible. However, it's out there as a possibility. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL […]
2003-05-09
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers