dprasannain (12/10/2015)

---

create table #emps (EN varchar(10))

insert into #emps values

('A'),

('B'),

('C'),

('D')

DECLARE @Names VARCHAR(8000)

SELECT @Names = COALESCE(@Names + ', ', '') + char(39)+en+char(39)

FROM #emps

print @Names

-- This query does'nt return any values when...

Post the full code you have executed, that code isn't in my snippet so you have modified it some how to work with your environment

It all comes down to how you want to handle nulls

First COALESCE returns a null due to the null in the table

Second COALESCE returns a string but with *** in...

Forgive my ignorance but why mirror to the...

COALESCE will work, you just need to ensure that you escape any nulls in the table correctly with an ISNULL or take a look at FOR XML PATH

http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string

rodjkidd (12/9/2015)

---

So the dates and location for SQL Bits have been announced

Wed May 4th to Sat May 7th

Liverpool Exhibition Centre

http://www.sqlbits.com/

Now what do to about the ticket I have for Yes...

Why the coalesce function, does the table contain nulls in the column?

Given that its an employee table I would be shocked to find a employee with no name.

What it looks...

Do you not have the formatting toolbar in BIDS?

Kill

Not used time columns in SSRS so this may not work, but will need to create an expression in the tablix something like

Fields!Shift_Start.Value + " - " + Fields!Shift_End.Value

You may...

Stuart Davies (12/8/2015)

---

Revenant (12/7/2015)

---

ZZartin (12/7/2015)

---

DonlSimpson (12/7/2015)

---

whereisSQL? (12/7/2015)

---

djj (12/7/2015)

---

Ed Wagner (12/5/2015)

---

DonlSimpson (12/5/2015)

---

Ed Wagner (12/5/2015)

---

TomThomson (12/5/2015)

---

Welsh...

Ensure tempdb's log can grow, if it can then get a bigger drive.

From a query perspective, find everywhere you using #temp ##temp @table variables and see if you actually need...

The error your getting is an Informix error not a Microsoft SQL Server error.

I would suggest posting this on an...

Jeff Moden (11/27/2015)

---

anthony.green (11/27/2015)

---

Dont use undocumented features your setting yourself up for a fall should MS remove them, they are not documented so they dont tell us if they are...

You may be best posting this on an IBM Informix forum instead of a Microsoft SQL Server forum.