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.

No its not to do with UNION, its to do with how big your query is.

SP_MSFOREACHDB has a maximum length at 2000 characters or if quoted_identifies is on its 128.

Dont...

Can you please elaborate?

What is the problem?

Scripts, error messages?

Write the query to get it working on one DB first, then find and replace all ' with ''

Care to post the error?