Try with:

CAST(CAST( NULLIF(NumericDatefield, 0) AS char(8)) AS datetime)

Usually this questions are to check for a mixture between knowledge and experience. There's not one correct answer, but multiple options depending on many circumstances. Basic answers that might lead...

I agree with you, I never suggested the non-dynamic approach. However, it's important to understand it before jumping into the dynamic cross tabs. Pre-aggregation can be used as well on...

Aaron,

I just wanted to point out that PIVOT is not needed (is just one option). A pre-aggregated CROSS TAB might perform better. Check the articles recommended by Lutz.

By the way,...

Maybe I sound pedantic, but a good advice is to use the help included with SQL Server. Is as easy as pressing F1.

Are you seriously asking something that is clearly documented?

http://technet.microsoft.com/en-us/library/ms175046.aspx

There's something wrong with your query. You're comparing a boolean value (EXISTS()) against an integer value.

To get better help, please post DDL for tables involved and sample data in the...

What approach did you take?

My option would be something like this:

CASE WHEN ModifiedDate > ISNULL( DateClosed, 0) THEN 1 ELSE 0 END as FieldName

Now, there's a method to obtain the correct result. It's called CROSS TABS and you can find information on the following articles:

Cross Tabs and Pivots, Part 1 – Converting Rows...

I misread the expected results, I will post a correct solution in a few minutes.

A simpler approach can be found on this article:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Here's an example on your data:

SELECT order_number,

sequnce_num,

STUFF( (SELECT...

I'm just trying to help 😀

I just hope people won't rely just on...

Antes que nada, bienvenido a este sitio.

Te recomiendo que escribas en inglés ya que así recibirás más ayuda y no te quedarás con la ayuda de sólo unos cuantos que...

With this change, he can loose the WHERE clause 🙂

:blush: Thank you.

Maybe the CROSS APPLY approach to unpivot can help you. Even to create the dynamic code for N number of columns would be easier than the built-in UNPIVOT function.

Reference: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

WITH...