The third option should say "Gives an unknown object type ERROR" otherwise you could assume (like I did) that you're saying that the sentence works and it gives you as...

Great article, points extra for mentioning Uruguay 🙂

I picked the second one, which has the same value than the last one.. But I got a wrong answer :'(

Hi! Thanks for the alternatives 🙂 but I think you've missed the OUTER APPLY + VALUES option. it may be the simplest way of doing an unpivot.

sanjaydut26 (9/29/2016)

I have a problem

This is the result what i get from my function ufn_GetHcmDesignFields

ISNULL(cast( ExtTotalExperienceUS as nvarchar) + ',' , '') + ISNULL(cast( ExtRelevantExperienceUS as...

Hi, it looks a very good and useful script 🙂 I'm just wondering on which columns should I base my decition to create or not the index. It would be...

The only thing I must disagree is with the first statement "Windowing functions are the best thing since sliced bread when it comes to T-SQL".. they only will be the...

Did you have a solution for this? I am facing the same problem, the package is not doing any call to a windows form, but when we run it on...

Jeff Moden (4/7/2013)

amd.repetto (4/7/2013)

dwain.c (4/7/2013)

As a sidebar, that format is usually referred to as an "EAV",...

dwain.c (4/7/2013)

amd.repetto (4/5/2013)

"Dwain,

Thanks for the quick answer! Don't worry, answer me when you have enough...

Sorry, I post this as a new reply and I don't know how to delete it:

"Dwain,

Thanks for the quick answer! Don't worry, answer me when you have enough time, like...

Dwain,

Thanks for the quick answer! Don't worry, answer me when you have enough time, like I said I'm new on this things and I want to learn properly how the...