drew.allen (12/14/2016)

---

Matt Miller (#4) (12/14/2016)

---

drew.allen (12/12/2016)

---

SQLUSERMAN (12/10/2016)

---

Suppose I want to find customers in the customers table who are not in the US or the UK.

To me the query for the...

ChrisM@Work (12/15/2016)

---

Actually it won't, it's the same problem....

I'm with you there 🙂 . The question is a ambiguous as "week" can be interpreted differently. Still had to point out , for anyone who may be looking to...

Jacob Wilkins (12/14/2016)

---

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

...

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

)

RETURNS...

Seems like the OP got his answer to this old thread.

Plus

DATEDIFF(wk, @StartDate, @EndDate)

Is cleaner and more readable, answers the one question posted here.

Koen Verbeeck (12/14/2016)

---

Igor Micev (12/14/2016)

---

Nowhere in the question is stated that the SSMS is 2016 version. "Compare Showplan" is not available in the lower versions.

So the answer is not...

Quick answers,

a) Creating a surrogate key should be a normal routine

b) If there is no business ID (primary key usually) in your source data , try communicating to the...

Thanks for the feedback Kevin. That looks like a star schema coming together now. What about the account type? That can be an attribute in the account dimension. As far...

You may want to archive...

JesseBizInt (12/12/2016)

---

In my environment I have many different departments that need to be kept separate from each other, yet share some data elements such as calendars and employee profiles. ...

I would bet this is the type of situation where the script is easy and fast to run and the fix is complex to where they keep putting it off...

Do you have any index on...

spidey73 (12/6/2016)

---

The job step runs with a proxy. The account used in the proxy/credential is a domain account with privileges on the folder, but NO privileges on the server on...

Referring to the article on the calendar table, you could add a [month] column that would makes this easy for you.

You would create the field and update it by...