Well, the fact that you beat him doesn't change the fact that he beat me 🙂

Just means two people beat me, so I'm even older and slower than I feared.

Cheers!

Lynn Pettis (12/14/2016)

---

Jacob Wilkins (12/14/2016)

---

The problem is that when StartDate is not null, you convert EndDate to VARCHAR and then concatenate it with a bunch of strings without checking whether...

The problem is that when StartDate is not null, you convert EndDate to VARCHAR and then concatenate it with a bunch of strings without checking whether it is null or...

Of course DATEDIFF(wk...) has a specific meaning in SQL Server, but I don't think anyone disagrees with that.

My point is that when someone asks in English "Hey, how can I...

MMartin1 (12/14/2016)

---

James Tran (12/13/2016)

---

Something like this will return the number of weeks and remaining days + remaining work days.

CREATE FUNCTION [dbo].udfGetWeeksAndDays

(

@StartDate DATETIME

,@EndDate DATETIME...

I'm sure we all are aware of this, but just to be clear for others who might stumble across this discussion, this functionality is tied to a version of SSMS,...

Just an addition to this comment,...

As Sergiy has already indicated, the assumption that it can't be in the source data because it's CHAR/VARCHAR is incorrect.

That can be shown in multiple ways.

To pick a couple...

goher2000 (12/13/2016)

---

enable auto shrink option for the database ,it will shrink the log file if you are willing to pay price with fragmentation in the database. WHEN DOES AUTOSHRINK...

The order of returned results is never guaranteed without an ORDER BY, so if you require a result set with a guaranteed order, then yes, you must use an ORDER...

It's just a warning, and shouldn't prevent the login in question from actually creating the table.

Further, as far as I've seen it's just a quirk of SSMS when designing through...

Just in case anyone else happens upon this and is temporarily confused as I was, the accepted solutions do include a row for CustomerKey=4 in their results, which is in...

From https://msdn.microsoft.com/en-us/library/ms176057(v=sql.110).aspx:

If no rows have been inserted into the table since the table was created, or if all rows have been removed by using the TRUNCATE TABLE statement, the first...

Should be able to.

I just ran this to find everything in...

Are we sure about this?

If the requirement is YTD and 2 full years prior, then for right now that would be 2016 YTD, all of 2015, and all of 2014.

The...