Given a large table;

a more potentially SARGable approach, and readable from my perspective is

Declare @customers table (country varchar(2))

Insert into @customers(country)

values('UK'),('US'),('FR'),(NULL)

Select*

from@customers

Except

Select*

from@customers

wherecountry in ('US','UK')

;

Have to emphasise the quote myself :-P...

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...