I've used the clustered PK, but I don't remember if there was an actual improvement or not. There might be, but with a small number of rows (as parameters usually...

CELKO (1/5/2017)

---

You are right. Let us post a correction i just got in a hurry. My bad.

CREATE TABLE Players

(player_id CHAR(5) NOT NULL PRIMARY KEY,

first_name VARCHAR(10) NOT NULL,

last_name VARCHAR(10) NOT...

My suggestion is that you insert parameter values into a table for each parameter.

Basically, your stored procedures would have a format similar to this:

CREATE PROCEDURE SomeReport (

...

What happens when you run them both at the same time?

Use HAVING.

GROUP BY memberid HAVING COUNT( DISTINCT membername) > 1

or

GROUP BY memberid HAVING MAX(membername) <> MIN(membername)

Maybe you were selling kitchens? Or fake documents? :hehe:

Rasmus Remmer Bielidt (1/5/2017)

---

Both options have their uses for sure.

I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it will throw an error where...

drew.allen (1/4/2017)

---

But you can...

Brandie Tarvin (1/4/2017)

---

NICE, Luis. And I can use a REVERSE(RTRIM(QuestionableColumn))...

I guess is like...

Thom A (1/4/2017)

---

Eric M Russell (1/4/2017)

---

As a side note, it would be great if all valid codes could be pre-loaded into a primary keyed master table, then data validation could...

Close, but not quite.

Method...

Does this works?

IF (SELECT OBJECT_ID('tempdb..#MyTemp')) IS NOT NULL

DROP TABLE #MyTemp;

CREATE TABLE #MyTemp (QuestionableColumn CHAR(20));

INSERT INTO #MyTemp (QuestionableColumn)

VALUES ('ABC1GKUCEEF7AR169582'), --Good value

('ABC2G1WG5E37D1157775'), --Good value

('BCD3GTU2TEC9FG119962'), --Good value

('- ...

drew.allen (1/3/2017)

---

Luis Cazares (1/3/2017)

---

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, '')...

Stay away of multi-statement table-valued functions. They're great performance killers.