One other idea I can suggest is to have the SSRS reports call a stored procedure instead of pasting all of the sql query in the query window. That can...

You have been presented with ideas. What have you you tried so far ?

I should...

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