Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 What's the best solution for querying with multipl

Author  Topic 

comn8u
Starting Member

9 Posts

Posted - 2007-11-23 : 13:55:48
x

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-11-23 : 14:27:30
It really comes down to your definition of "relevant data".



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-11-23 : 15:18:34
I'm guessing you have a dynamic search condition. give this a read:

http://sommarskog.se/dyn-search.html


elsasoft.org
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-11-25 : 15:23:24
Why?

If you cared about a viable solution, maybe you should explain WHY you are not getting RELEVANT data?
It is because you pass EMPTY instead of NULL? Have you checked?

You query above should work as is, if you use NULL as value for unused parameter!
Don't complain and whine, please let us understand why you think it is not returning relevant data.

We are not beginners with this kind of problem.
But hey, you come to us for guidance and if you can't take a pointer, we couldn't care less.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-11-26 : 00:11:42
whoa, settle down. you aren't likely to get much help from anyone in the future with that attitude.

besides, Peso has some of the most amazing posts on this whole forum - you'd do well to study them.


elsasoft.org
Go to Top of Page

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2007-11-26 : 16:19:18
quote:
Originally posted by comn8u

I came here seeking a solution, which someone intelligent gave me. You just left a comment. If that's how you gain your points, that's pretty sad.




Coming here all high and mighty and rude and disrespectful is not likely to encourage people to help you.

Peso is right. If you can't ask an intelligent question, you can't get an intelligent answer. Even jezamine's answer was a lucky one, as the post says:

[quote user="jezamine"]
I'm guessing
[/quote]

So perhaps people could find it easier to answer if you provided enough information with your question, and when asked for the information you did not provide you weren't rude in response. After all, it wasn't Peso that left out the information in your original question, was it?
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-11-27 : 08:59:58
comn8u: i regret helping you.


elsasoft.org
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-27 : 10:47:51
quote:
Originally posted by comn8u

jezemine I still thank you for helping me. I'm not a person that goes around message boards name-calling. I've been posting on different message boards for many years without a problem. I have never had a person respond in the manner that Peso did. I apologize to anyone that reads this for wasting post on ridiculous topics.


You really do have an attitude problem, don't you. I think you'll find by re-reading the post that Peso's question to you was very relevant. Try thinking about what someone who knows nothing about your situation would read into your post. Ther fact that jezemine guessed the answer was just a bonus to you.

Instead of getting stressed when people (who do not get paid for this!) try to help you, think about what they ask you in return.
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-11-27 : 23:41:58
or, be a coward and just delete all your posts. that might work for ya.

good luck dude.


elsasoft.org
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-01 : 15:04:07
I interpret it as the problem was using EMPTY instead of NULL.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -