It's more like:

SELECT fname, lname, MAX(location1), MAX(location2)

FROM #Something

GROUP BY fname, lname

Please don't post on multiple forums.

All replies in this thread: http://www.sqlservercentral.com/Forums/Topic1536945-3077-1.aspx

You can add a derived column on the table with a formula as used below:

WITH SampleData([Year], [Month], Productname ) AS(

SELECT '2013', '11', 'ACB' UNION ALL

SELECT '2013', '11', 'CDE'

)

SELECT...

You're welcome. I hope you understand how it works. If you don't, please post any questions that you have.

There's an easier way and it's explained in this article: http://www.sqlservercentral.com/articles/T-SQL/63681/

This is an example that might not work because I have nothing to test on.

-- Daily Report

SELECT UserID,

SUM(CASE WHEN...

The best splitter for T-SQL is right here[/url] along with several tests. It will outperform any splitter using while loops or xml.

With it, you can replace your function to this....

Sean Lange (1/31/2014)

---

VoldemarG (1/31/2014)

---

so from everything I heard/read, would that be fair to conclude that option 2 is the way to go in the majority of cases?

2) where databasename ='myDBname'...

Do you really need to do this in T-SQL? This is usually made in the front end.

If it's completely needed on T-SQL, you might need to union the detail with...

Sure, there's a different way to achieve it. I personally prefer the CROSS TABS method for pivoting data.

Here's an example. If you have questions, feel free to ask.

WITH CTE AS(

SELECT...

Chris, I think you were expecting different results than the ones the OP asked for.

I would go for the last query from o.fimin.

Define "does not work". Are you getting an error? What should it do and it's not doing? Or what is it doing that it shouldn't?

Reviving a thread twice 😛

You have 1 BEGIN and 2 END.

Would this help?

http://www.sqlskills.com/blogs/kimberly/guids-as-primary-keys-andor-the-clustering-key/

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/guid-vs-int-debate.aspx

Maybe even a post from a GUID lover:

http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx

Or even BOL on Using uniqueidentifier Data:

http://technet.microsoft.com/en-us/library/ms190215(v=sql.105).aspx

And use an errorfile to find out what failed.