That's true... one more reason to stick to precise definition.

From BOL :

When n is not specified in a data definition or variable declaration statement, the default length is 1. When...

I agree with you, Bryant. Asking for a diagram is the most obvious solution and I should have mentioned it. Same regarding the wiring, if it is done properly, then there...

You have my sympathy... this is really a terrible piece of code, especially with no comments. What I would probably attempt (except kicking the author of procedure in the ...) is :

- find...

Hmm... the ON/OFF/HOT/COLD test is a logical solution and it probably is the correct answer. But if I you check the question word by word, some interesting possibilities can be found (other...

I have to disagree, of course one would suppose so, but unfortunately I've seen many questions on these forums where only after several attempts to solve the problem we were informed, that...

Oh, BTW, David, I don't think it is a good idea to use CONVERT and not specify the length of result data type (just VARCHAR, instead of e.g. VARCHAR(50)). As far...

I didn't test this for performance, but there is a way how to write the code more simple - instead of CASE, like in Pam's example, you can just concatenate...

Sorry, I think you should supply more information - best would be DDL and sample data, or at least description of possibilities. We can hardly start looking for a reliable solution...

I wouldn't recommend editing data in tables opened through EM at all, and especially not if there are TEXT columns - although I admit that I don't know much about...

Well, thanks Jeff , but in fact CONTINUE is not really necessary in the function - as far as I know, it works the same...

Hello,

I'm sorry, Juliano, but I don't know what you mean by "organized by hierarchy". The only requirement in your original post was "to bring resultset like this", which is what...

Hello,

this should do the trick (it would be nice to include DDL with your question, so that we don't have to create it - sometimes guessing how it could be......

Hello,

Of course the best would be to take proper training beforehand, but supposing you need to start your job right now and can get to the training only after some time -...

Hi Kapil,

you didn't mention what is this search about and what the result should be. I see you are using OR in your WHERE clause. In an example with books that...

This is a follow up to this thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=275059

and the question was answered there - there is no reason to order the data while creating view, it can be unordered....