Looks like you're trying to update the existing (float) column with a date, which won't work. you'll need a new column, and then (if you want) you can drop the...

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...