Instead of using a where clause on the conditional values you need you may want to use a CASE statement incorporated into the select list of the select statement to...

I love this, "read his posts and tear him apart" mentality you employ GSquared.

the folks on this forum are way to sensitive, I never ask questions that are intentionaly rude, that is just the way you interpret the question. If I tell you...

I like all the interpretations of my question but still no answer. I imagine if I asked the question what is 2 + 2, I would get people telling me...

There is also this proclivity for answering questions with questions or turning the question on the asker, like most of the replies to my question will inevitably be.

I didn't explain what the whole job is about and I don't need to since the raiserror solved my problem, if the query returns rows then the job is not...

The job failure triggers an email sent to an operator which is done

Please review the specs on RAISEERROR

http://msdn.microsoft.com/en-us/library/ms178592

If you know the code for this, then, please by all means put it in the thread

Oh and BTW this code does work

I'm not really testing to see if a table exists or not but if rows in a table exist:

and I figured it out here is my answer for my question:

...

p[

'kl[pl

oh and while we are at it, what is a "table-value-parameter" because that is a new term, that I don't see in any setting in ssrs

or maybe I need to define how sql databases use a "query" to get data, or maybe define what a stored procedure is?

just how simple do my statements need to...

do you think the words "concatenate" or "multi select" are too hard for people to understand?

Ok here is a very simple question. I have a multi select parameter, where I'm setting the Label = (company + '-' + companyid)

so a concatenated Label, I have created...