Last Sunday
Needed to return the week ending date as Sunday for daily transactions multiple times, for several aggregate reports. This function returns the last Sunday for past or future weeks.
2009-05-11 (first published: 2009-04-15)
606 reads
Barkha Javed
Blogs
Microsoft Tools That Help Query Tuning
Query tuning is not easy. In fact, for a lot of people, you shouldn’t...
Author of the Year 2019 Nomination at MSSQLTips
This year I’ve been nominated again for the Author of the Year award at...
Extended Events Misperceptions: Profiler is Easier
I know, I know, I’m on #teamexevents so I think that Extended Events can...
Forums
Upgrading SQL Service Packs on multiple versions
Hello SSC, My company has SQL versions that range between 2008 R2 to SQL...
Dynamic images within my report
Hi, Im trying to get dynamic images in my report based on a Tablix...
Setting fill factor on an auto-increment INT clustered index
Hi all, Please consider the following table structure. CREATE TABLE [dbo].[Transactions]( [Id] [int] IDENTITY(1,1)...
Ask SSC