Adding any of those lines would cause an error due to the ; at the end of the previous line of code.

Having is last not group by. Answer is wrong.

Don't know what the question should have been for that set of answers. Certainly not an error. +1

The correct answer is commented out so would return nothing. Are we to guess that the first select is commented and the second is not? Two poor questions to...

What am I missing here?

The CustomerId in the subqueries Select list and Order By has not been qualified with the table alias, so would give an ambiguous column...

Use a subreport within the invoice to hold the invoice lines.

1. Report (1) - This is primarily the invoice header dataset. Include in a tablix of your choice. ...

Yes, rdl includes the query as written but...

Using a single textbox cell within a tablix you can :

1. Set the value of the cell using an expression as :

=IIF(ISNUMERIC(Fields!Value.Value),VAL(Fields!Value.Value),Fields!Value.Value)

2. Set the format property of the cell as...

This is two's complement numbers being used.

When converting down from varbinary to an integer data type you only get the last (least significant) byte. In this case the least...

Paul, probably different understanding of the word USE. I took it to mean "support" rather than "need". If I had read the question as was probably intended then...

Thanks Andy for the attempt at creating another question.

But the question is very ambiguous and wantonly misleading again. It seems to ask which of the three HA/DR...

+1

You are...

Ok I have just recreated the requirement as this.

CREATE TABLE dbo.entries(entry varchar(20))

INSERT INTO dbo.entries values ('0')

INSERT INTO dbo.entries values ('0888')

INSERT INTO dbo.entries values ('324')

INSERT INTO dbo.entries values ('0')

INSERT INTO dbo.entries...

So just to be clear, the numbers you are showing are individual rows from your dataset, not 2 rows as shown with ; between the columns.

Fitz