Keeping Phil's simple formula:

SELECT name = concat(First_Name, ' ', Last_Name),

Sports = STUFF(iif(Football = 'Y', '; Football','') + iif(Soccer = 'Y', '; Soccer','') + etc, 1, 2, '')

FROM YourTable;

Just a small update.

--===== If the function already exists, drop it

IF OBJECT_ID(N'[dbo].[ifn_WorkDays]') IS NOT NULL

DROP FUNCTION [dbo].[ifn_WorkDays]

GO

GO

...

Michael L John (1/3/2017)

---

Just putting the finishing touches on a new reporting server.

I run this old legacy ETL process that nobody knows about, and nobody remembers, when this error...

Chris Harshman (12/30/2016)

---

BOR15K (12/30/2016)

---

...I am aware of the dirty data and in this case there will be no update of the data within the selected range, hence I want to...

At first I thought it was spam.

Now, I'm surprised about the real Bobby Tables.:w00t:

You also have a TOP 1 without ORDER BY which might return inconsistent results.

You have a correlated subquery that might return more than one row and would eventually return the...

Jeff Moden (12/30/2016)

---

Very cool. Thanks.

On the two...

It's PERCENTILE_DISC or PERCENTILE_CONT which use OVER to define window and order.

The median is the first example on the BOL page:

https://msdn.microsoft.com/en-us/library/hh231327.aspx

Here are 2 other methods that seem to be faster.

WITH cteStepsTiles AS(

SELECT *, NTILE(2) OVER(PARTITION BY Rep, MileCode ORDER BY DeltaT) tile

FROM...

Do you have the Excel column set as Text before inserting the data? That would avoid a numeric format.

McCallister

Sure, it works. But, do you believe it's efficient? You're reading the...

Two ideas come to my mind.

1. You have 2 variables and you're populating one and showing another one (SSIS can cause these confusions).

2. Your variable wasn't correctly set in the...

jason.shaw (12/28/2016)

---

I need to choose multiple misc. accounts from an account table using a list from one of our accountants and then change to make account active. I am a...

1. How are you populating your variable? If the variable is not populated correctly, it will always show 0 (or the initial value that you have set).

2. The warnings are...