I think there are definitely multiple questions within your one question.

1 - are you working for the job, or the money?

2 - if your passion paid the same amount,...

Advice requested -

trying to develop a searcheable db of our available reports for end users, including description, author, screenshots, blah blah blah.

We have a standard documentation template that...

Thanks for the feedback, and thanks Stewartc for the solution.

it's because you're not correctly using coalesce(). You cannot simply find the first non-null value (which is what coalesce() or isnull() do) and make your column equal that, especially by...

Rock, can you provide us with sample table structure, sample data, what you're trying and expected outcome? This will help us to understand your dilemma a little better. (See the...

GilaMonster (5/17/2010)

---

If that is plagiarised, MS needs to be informed (I know a couple people I can speak to there), seeing as that is an MSDN blog.

Note that there's...

Um, Steve, not sure what's going on here, but the Database Weekly newsletter shows a link to this article: Are you Making This Common RAM Mistake?, which seems to have...

The other alternative is to, you know, take the class you're referencing, do the homework, read the lectures, and I'll bet they'll teach you how to do that. As...

For those of you sick of working on real problems, feel like helping a JC (not a JHC) out?

it's ok Chris, Jack can have my beer, I'm not a big fan anyway.

Chris Morris-439714 (5/14/2010)

---

jcrawf02 (5/14/2010)

---

Chris Morris-439714 (5/14/2010)

---

Paul White NZ (5/14/2010)

---

You would have loved my first draft reply 😉

Celko is undoubtedly a...

Chris Morris-439714 (5/14/2010)

---

Paul White NZ (5/14/2010)

---

You would have loved my first draft reply 😉

Celko is undoubtedly a reasonably bright individual,...

rockingadmin (5/7/2010)

---

i tried with different scenario

ex:

declare @userid int,@username nvarchar(300),@companyname varchar(300),@job varchar(30)

select * from jobspec where userId=coalesce(@userid,userid) and username like coalesce(@username,username)+'%' and job=coalesce(@job,job),companyname like coalesce(companyname,@companyname)+'%'

.

.

.

.

it is working properly.But i have a...

hfxDBA (5/13/2010)

---

before I get jumped on some more... sorry didn't mean to ruffle feathers (my smilies didn't work their magic like I had thought). I will unsubscribe and move...

hfxDBA (5/13/2010)

---

Geeeeesh, talk about bad questions??? What about bad replies... the ones that have nothing to do with the question and a lot of people may have subscribed to to...