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