Wow, that's a crazy attitude to me, but I don't know the situation.There are valid reasons sometimes why not to change a process.

Certainly building something very complex that few...

• This reply was modified 5 years, 7 months ago by  petitpere.
• This reply was modified 5 years, 7 months ago by  petitpere.
• This reply was modified 5 years, 7 months ago by  petitpere.

YES, but amongst the managers ...

"There are a number of things people lack that lead to...

I agree on most of the points and disagree on some others. Huh that's why debates are interesting.

Often, when I speak about SQL with colleagues, they all pretend "Yes, I...

Well, to be honest I did not expect to be the first one to reply after 3 days. 😉

Let me first clarify who I am. I graduated from...

Thanks to all of you for your answers ...
I'm sorry I can't reply currently because of closing issues running wrong!

Thanks Jeff for sharing your thoughts with me.

I personnally think that SQL queries scares those who are familiar with algorythmic programming unlike set-based programming.

Did you...

Thanks Thom for your answer; security is the first argument; using "parametrised SQL" could be less secure than storing this process in SPs. I did not think of it. :)

GOT IT !

If I run  following query, it's all fine ...

select

Thanks Luis!
I did not know/remember about the ASCII function.
The result is
3802 Berlin 105
3802 Berlin 110
26880 Berlin 66
26880 Berlin 101
26880 Berlin 114
26880 Berlin 108
26880 Berlin 105
26880 Berlin 110
26880 Berlin 0
40921 Berlin 66
40921 Berlin 101
40921 Berlin 114
40921 Berlin 108
Now I need to find...

thanks alastair.beveridge ... I'll have a look at this ... it will not be as easy to implement as I initially thought of, but the power behind can be very...

A field in your SELECT returns a NULL and thus the entire concatenated line is NULL.
Replacing "cast(Count(Number of Items))" by "cast(COALESCE(Count(Number of Items), 0) as varchar)" would do the trick...

Vielen Dank HanShi for sharing your script.
At first sight I can't see any matrix inversion in it (that's in fact the function I need most in matrix calculations ;-)...