We're currently waiting for SQL 2017 as we're thinking of getting a separate BI server. It won't have as much of a punch as the main box, but will have...

Are you returning the dataset into a datatable? If so, you can filter these. In VB, I think the syntax would be something along the lines of:
Dim sqlConn As...

In your example data, seq 2 already has a value of 41. Seq 1 has a value of 21. I've guessed that, perhaps, you always want the highest ReasonCode. Also,...

With your statement T1.Field3 > T2.Field3, that part of your join will limit the rows to only those where the value of is T1.Field3 greater than T2.Field3. If you...

For the evaluation side of your IIF, you would need:
Fields!LicenseValue.Value = 0.00 OR IsNothing(Fields!LicenseValue.Value)

Nested IIF is one day, yes:
=IIF(Fields!ColumnA.Value > Fields!ColumnB.Value AND Fields!ColumnA.Value > Fields!ColumnC.Value, "ColumnA", IIF(Fields!ColumnB.Value > Fields!ColumnA.Value AND Fields!ColumnB.Value > Fields!ColumnC.Value, "ColumnB", "ColumnC"))
You might need to tweak this a...

This should do the job:
CREATE TABLE #Sample
  (cobdate date,
  TradingType varchar(10),
  Tradeamt decimal(12,2),
  RevenueAmt decimal(12,2),
  IsActive bit);
GO

Assuming that all rows >0 and <1 are offending rows, then this should work. Note, I do not update the OrderID, as generally reseeding your IDs is a bad idea....

How do you tell that the value is duplicated, is it only is the following ID has a decimal value between >0 and <1?

If so, you declare you...

Please supply a valid Sample table with DDL and DLM. The example you have has shows 6 columns, however, several of your rows only have 5, and varying data types...

As vulpes said, when using Select in that format, you don't use values. Your SQL should be in the format:
INSERT INTO [DestinationTable] ([List], [of], [Column], [Names])
SELECT...

I assume, by your post, you are trying to get the results you show above for TableA and TableB. As a result I'm not sure why you are using a...

Yes, SSMS comes with some SQL 17 CTP stuff, as it includes compatibility for it. This will probably change to "Microsoft SQL Server 2017" update your SSMS and after SQL...