Database

"SELECT " & _
"  SUM(FSHIPQTY * FCOST) " & _
", SUM(FSHIPQTY * FPRICE) " & _
", SUM(FAMOUNT) " & _
", SUM(FSHIPQTY * FPRICE - FSHIPQTY * FCOST) " & _
" FROM " & _
"( " & _
" SELECT " & _
"     h.FSHIPQTY " & _
"   , h.FCOST " & _
"   , h.FPRICE " & _
"   , h.FAMOUNT " & _
" FROM ARTRS01H.dbf h " & _
" WHERE " & _
" h.FSHIPDATE >= @startDate AND h.FSHIPDATE <= @stopDate " & _
" AND " & _
" h.FITEMNO = @FITEMNO " & _
" UNION  ALL " & _
" SELECT " & _
"     v.FSHIPQTY " & _
"   , v.FCOST " & _
"   , v.FPRICE " & _
"   , v.FAMOUNT " & _
" FROM ARTRS01.dbf v " & _
" WHERE " & _
" v.FSHIPDATE >= @startDate AND v.FSHIPDATE <= @stopDate " & _
" AND " & _
" v.FITEMNO = @FITEMNO " & _
") "

var query = (from sub in db.myTable
                            where  (sub.Deleted == null || sub.Deleted == 0)
                            select new
                            {
                                sub.ID,
                                sub.UpdatedByAdmin,
                                sub.UpdatedBy,
                                sub.Deleted,
                                D1 = sub.UpdatedByAdmin.Equals(true ? sub.Date1 : sub.TimesForDate1),
                                D2 = sub.UpdatedByAdmin.Equals(true ? sub.Date2 : sub.TimesForDate2),
                                D3 = sub.UpdatedByAdmin.Equals(true ? sub.Date3 : sub.TimesForDate3)


                            }).ToList();

System.ArgumentException: DbComparisonExpression requires arguments with comparable types.

Dhyanga wrote:

I thought byte is equivalent to tinyInt.

Ibrahim.elh wrote:

what you proposed?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

SELECT *
FROM
(
SELECT * FROM   #TABLEA A 
UNION ALL
SELECT * FROM   #TABLEC C 
)t   
WHERE LIS_KEY  = '047600055/R'

• Product the Cartesian Product of the two tables - each row in the left-hand table is matched with each row in the right-hand table.
• Remove the rows where the JOIN condition is not met.
• Depending on the JOIN type:
  
  
  • INNER JOIN: Nothing to do.
  • LEFT (OUTER) JOIN: Any rows in the left-hand table but not in the results are added back, matched with a row of NULL values for the right-hand table.
  • RIGHT (OUTER) JOIN:: Any rows in the right-hand table but not in the results are added back, matched with a row of NULL values for the left-hand table.
  • FULL (OUTER) JOIN: Apply the rules for both LEFT and RIGHT joins.
• Filter the result based on the conditions in the WHERE clause (if any).