Sergiy (8/24/2016)

---

There was an article from Jeff Moden how to replace any number of consecutive spaces with a single one without recurring REPLACE calls.

I don't have it handy, but it...

I mean that instead of the proposed solution:

SELECT DISTINCT

ID,

Brand = STUFF(( SELECT ',' + Brand

...

GilaMonster (8/24/2016)

---

Which will behave exactly the same as the DISTINCT. Since he wants distinct values,...

Let's see if I understand correctly.

You want to change the value of a column to track changes on the table? Are your queries prepared to handle soft deletes? If you...

chozhanvijay 23273 (8/24/2016)

---

hi Luis,

I think i should use the STUFF instead of the coalesce here. As coalesce is for returning the non null values. Can you please help me out...

Why do you think that you need coalesce? What do you think coalesce does? If you're not sure, read the following link: https://msdn.microsoft.com/en-us/library/ms190349.aspx

To solve your problem, you might want to...

You can use Cross tabs.

SELECT Region, District, LocID,

MAX(CASE WHEN Title = 'IT Director' THEN Cnt ELSE 0 END),

MAX(CASE WHEN Title = 'IT Manager' THEN Cnt ELSE 0 END)

--etc

FROM...

Great! Do you understand why and how it works?

Here's another option. Note that these solutions won't eliminate tabs, line feeds or other spacing characters. I created a function to avoid making the query too complex and to reuse...

If you want to create the table with a column named as the first occurrence, you need to use dynamic sql. That's just wanting problems, IMHO.

Otherwise, you could do this:

IF...

JALLYKAMOZE (8/23/2016)

---

Luis Cazares (8/23/2016)

---

You can use a CASE expression for this:

SELECT CASE WHEN Monday = 1 THEN 'Monday'

WHEN Tuesday =...

You can use a CASE expression for this:

SELECT CASE WHEN Monday = 1 THEN 'Monday'

WHEN Tuesday = 1 THEN 'Tuesday'

---etc

...

tstagliano (8/23/2016)

---

I have the below script and when i run it i keep getting the error "Conversion failed when converting the varchar value '?' to data type int" and i...

JALLYKAMOZE (8/23/2016)

---

I HAVE A TABLE RANGING FROM MONDAY, TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY,SUNDAY

THESE TABLES HAVE VALUES BETWEEN 0 AND 1 EG,

MONDAY : 0, TUESDAY :1,WEDNESDAY : 0,THURSDAY:1,FRIDAY:1. SATURDAY:1 SUNDAY:1

HOW CAN I SELECT ONLY...

Here you go:

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