![]() |
Hi All,
04 Apr 2016
| 2 comments
,
|
![]() |
I have an unusual sitution. The below query works when I don't refer to any of the fields in the 'product_table'.
17 Jun 2015
| 1 comment
,
|
![]() |
Hello I looked at this part... left join (select CCT_External_ID, CCT_Agent_ID from GDW_VIEWS. CCT_AGENT where CCT_External_ID between '0' and '999999') Rep_Trans_IDs on Rep_Emp_IDs.emp_id=Rep_Trans_IDs.CCT_External_ID
22 Apr 2014
| 4 comments
,
|
![]() |
SELECT TRIM((CASE WHEN mt.Store_state IS NULL THEN '#@@#' ELSE mt.Store_state END)) as Store_State ,TRIM((CASE WHEN mt.Company_Cd IS NULL THEN '#@@#' ELSE mt.Company_Cd END)) as Company_Cd
03 Aug 2012
| 7 comments
,
|