Author |
Message |
   
Nitho
Desanike Pedda Bewarse Username: Nitho
Post Number: 7588 Registered: 12-2004 Posted From: 161.225.129.111
| Posted on Thursday, June 15, 2006 - 2:24 pm: |    |
intg ni string loo conversion raasa when comparing two tables if class is 1 it will consider it as 01 |
   
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 22989 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Thursday, June 15, 2006 - 2:15 pm: |    |
nitho mama... (case when (len(convert(varchar(3), dept_i)) = 1) then ('00' + convert(varchar(3), dept_i)) deeni artham enti...nneppudu soodaledhu ivi  |
   
Nitho
Desanike Pedda Bewarse Username: Nitho
Post Number: 7587 Registered: 12-2004 Posted From: 161.225.1.12
| Posted on Thursday, June 15, 2006 - 2:12 pm: |    |
select * from itemstorechanges where (case when (len(convert(varchar(3), dept_i)) = 1) then ('00' + convert(varchar(3), dept_i)) when (len(convert(varchar(3), dept_i)) = 2) then ('0' + convert(varchar(3), dept_i)) else convert(varchar(3), dept_i) end + case when (len(convert(varchar(2), class_i)) = 1) then ('0' + convert(varchar(3), class_i)) else convert(varchar(3), class_i) end + case when (len(convert(varchar(4), item_i)) = 1) then ('000' + convert(varchar(4), item_i)) when (len(convert(varchar(4), item_i)) = 2) then ('00' + convert(varchar(4), item_i)) when (len(convert(varchar(4), item_i)) = 3) then ('0' + convert(varchar(4), item_i)) else convert(varchar(4), item_i) end) not in (select substring(convert(varchar(12), item_num), 1, 9) from gpc) eedhi try gudi mama |
   
Gudiwada
Bewarse Username: Gudiwada
Post Number: 2227 Registered: 11-2004 Posted From: 161.225.129.111
| Posted on Thursday, June 15, 2006 - 2:05 pm: |    |
gochi pani seyyatlaa
 |
   
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 22986 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Thursday, June 15, 2006 - 1:32 pm: |    |
select aa.item_no from GPC, (select distinct itsc.dept || itsc.class || itsc.item "item_no" from item_store_changes itsc)aa where aa.item_no = GPC.item_no(+) and not exists (select 'X' from GPC1 where GPC1.item_no = GPC.item_no) maama...idhi try chesi choodu... |
   
Gudiwada
Bewarse Username: Gudiwada
Post Number: 2226 Registered: 11-2004 Posted From: 161.225.129.111
| Posted on Thursday, June 15, 2006 - 1:20 pm: |    |
GPC tabel loo item_num 878011017 vundi item store changes loo dept 878 class 01 item 1017 vuntundhi some items exsiting in itemstore changes are not existing in GPC reports loo buthulu vasthunnayi koncham query rasi pettara exisiting in itemstorechanges and not existing in gpc table
 |