If you can I would change the code so that the input parameter is VARCHAR and use discreet values 'All','One','Multi'

There is no context behind the 0,1,2 so how would...

Bump, Set, Spike!

@sushantkatte

Kudos for seeking out assistance when you don't know the answers and well on finding SQLServerCentral forums. Jeff, Lynn, GilaMonster and Koren are all experts in this...

Nikku,

On a less facetious note, The other are correct, in a straight file format (CSV, EDI, flat file) or another table you would not be able to identify the...

This is a perfect example of why you should have an N-tier approach to the application development and MVC lends itself to this. MVC is a generic pattern but...

goodjob a_k. Glad that the suggestions were useful to you and for posting your resulting code for others to learn from. as you can see dynamic pivot / unpivot...

I agree that they are static, but I was referring more to the source of the script rules, If you use UNPIVOT, you do that on named fields. In...

@hugo,

That might work but it is data-centric rather than schema-centric. When the company introduces a new product line and creates 'CATE-5' you have to modify the query...

Slightly OT but 'no date' as NULL, '1753-01-01' or '9999-01-01' will have different performance impacts depending on your database collation and indexes. My understanding is that under most...

For What it is worth, If I have to repeat the CASE logic in the WHERE or GROUP clauses, I prefer to wrap the original query as a CTE and...

The short answer is NO.

The longer answer is YES. (by one character :-D)

In order to produce the data in table 3, you need to UNPIVOT the data in table 2...

I think your problem is the way you are trying to find the start and end dates. The end date is

2016-01-13 09:00:00.000

and you are asking for where the end...

@jacob and @jeff

SSRS is not my natural home 😀 so I was not aware that IIF(x AND y) is a bitwise operation. Maybe I wasn't...

Jacob Wilkins (1/13/2016)

---

I might be misunderstanding you, but if you're starting with the integer value (it sounds like you are?), then I find this method a bit more straightforward, using...

Thanks Jeff,

I will be comparing a subset of the output to another data set to carry out reconciliations: missing records from both sets and discrepancies in values.

The business scenario is...