Database

SELECT DISTINCT p.prod_id, p.model, p.showpricing, p.image_file, p.image_width, p.image_height, p.image_border, p.name, m.manufacturer,
  CASE WHEN sp.price IS NULL THEN 0 ELSE sp.price END AS list_price, 
  CASE WHEN sp.price IS NULL OR ssp.discount IS NULL THEN 0 ELSE sp.price - ssp.discount END AS sale_price, 
  CASE WHEN NOW() BETWEEN p.mfgrebatestart AND p.mfgrebateend THEN p.mfgrebate ELSE 0 END AS mfgrebate 
  
  FROM comm_product p
  INNER JOIN comm_manufacturer m ON p.mfg_id = m.mfg_id 
  INNER JOIN comm_dept_prod dp ON p.prod_id = dp.prod_id
  INNER JOIN comm_partners_products pa ON p.prod_id = pa.prod_id 
  LEFT JOIN comm_sku_price sp ON p.default_sku_id = sp.sku_id AND NOW() 
  
  BETWEEN sp.date_start AND sp.date_end 
  LEFT JOIN comm_sku_sale_price ssp ON p.default_sku_id = ssp.sku_id AND NOW() 
  BETWEEN ssp.date_start AND ssp.date_end 
  
  WHERE pa.p_id = :partnerID 
  
  AND p.avail_type < 3 AND p.image_file > '' 
  AND p.model NOT LIKE 'EBAY-%' 
  AND p.dept_ad = 1 
  AND dp.dept_id = :deptID 
  
  ORDER BY rand() LIMIT 4

jkirkerx wrote:

Wow thanks

jkirkerx wrote:

I don't understand the ANSI JOIN versus the implicit, guess I can Google that to
learn exactly what was wrong.

abhi17_6 wrote:

Problem is that this app is not able to connect to oracle 10g database server
though it is able to connect to some other 11g R2 database server.

Samarjeet Singh@india wrote:

Exec master.dbo.xp_cmdshell 'C:\My Test'\<<DATE>> then its throwing
error.

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'master.dbo.xp_create_subdir'.

Exec master.dbo.xp_cmdshell 'mkdir "C:\My Test\<<DATE>>"'

Gennady Oster wrote:

catch(Exception e){ res = e.Message; }
return res;

Object sqlResult = ExecuteScalar(sql);
if (!(sqlResult is byte))
{
    return sqlResult.ToString();
}