Alvin,

The code makes clear that there's a concatenation based on multiple values on a single column.

CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck' + ',' ELSE '' END +

CASE WHEN...

I agree, a redesign to normalize the tables should help you solve this and other issues.

I can't see why would you want to use COALESCE as you're not evaluating nulls.

Something like this?

DECLARE @date = '20140701'

SELECT TOP 1 *

FROM MarketShare

WHERE StartDate <= @date

ORDER BY StartDate DESC

Don't be so sure about the control that you expect by the limit on the ID. The rows are still being generated and you can easily check it with the...

You need to use brackets.

DAY([DATE_ACTIVATION])

That should help with the error.

I forgot to mention. Thank you for the article Ed. It's nice,I wish that I could use it more, but we haven't migrated to 2012 (or 2014). I have to...

Pedro Gomes-379488 (5/27/2014)

---

It's good to know about LAG and LEAD, that I didn't know of, but I use the approach below when faced with that kind of problem and don't...

This is a possible solution but I'm not sure that it will work as it is for your data because I can't test it. This won't need a calendar table...

Hi,

This sounds relatively simple, but there's a problem. We need something to work with. Please post DDL, sample data (as insert statements) and expected output based on the sample data.

Read...

Have you tried pressing F1 and looking for REPLACE? You should get to this nice article:

http://msdn.microsoft.com/en-us/library/ms186862(v=sql.110).aspx

Answer in the following thread:

http://www.sqlservercentral.com/Forums/Topic1574051-3077-1.aspx

The alternative could be the official unpivot.

SELECT Val

FROM (SELECT CAST( '1 cod ' + CAST( cod AS varchar(10)) AS varchar(20)) col1,

...

I assume that the code you posted is part of a stored procedure. That stored procedure might be part of the procedures listed in here:

SELECT PROCEDURE_NAME FROM PROCEDURE_TO_EXECUTE WHERE EXECUTE_PROCEDURE=1

That...

Maybe you didn't play enough with bcp. This article might help you.http://sqlsouth.wordpress.com/2014/05/23/export-xml-from-sql-server-using-bcp/