While I agree that the original table name that the OP posted left some to be desired, so does the one you created.  Wouldn't Employee_Leave_Days_Taken be more...

Totally understood.  You have a heavy handed review board that seems to have gone over...

That's good to know.  Thanks, Jeffrey.

For a history table and with all else, "It Depends".

For example, a heap won't fragment or forward rows waste space (depending...

Excellent.  Thanks, Joe.  You've mentioned this site many times.  Consider adding the link to your signature line. 😀

Jonathan... they didn't say so in the original post but the OP is trying to do this in SSRS, not SSMS.

Great tip for SSMS, though!

I don't know for sure but, IIRC, SSRS renders out as HTML.  That might mean you need to use <br> instead of an actual character to induce a break in...

You don't know how to do a data model for temporal data. Please get a copy of Rick Snodgrass's book from the University of Arizona on temporal queries in...

First things, first.  Tables that use Random GUIDs are a whole different animal that what I was talking about in the post you cited.  They are one of the very...

I can't speak to the problem you're having with CMS (I don't use it) but it's a bit crazy having both of the columns in your table variable defined as...

Those are handy to help trick the network folks into thinking that you're using more space than you are so you have time to make...

Be careful of autogrowth here. Also, it's a good idea on any drive with auto-growth enabled, create an file called 'deletemeinemergencies' or similar. Make it big enough, say...

Create Table #LeaveTable(Co int, Emp int, LeaveDate date);
Insert Into #LeaveTable (Co, Emp, LeaveDate)
Values
(1, 1001, '12/22/2020')
, (1, 1001, '12/23/2020')
, (1, 1001, '12/24/2020')
, (1, 1001, '12/28/2020')
, (1, 1001,...

I've not read this entire article but there does seem to be a problem... for example, this is a quote from the article...

When I ran the code in Listing 6,...

hi folks

just after some advice

if the Log space has 98% reported free space but the physical drive has virtually no free space left

will trans logs for the db post...