SQL Server Help

[Elaaz]

SELECT ItemName, (SELECT ISNULL(SUM(ItemQuantity),0) FROM Table_2 WHERE Item_ID = 1) AS TotalItem FROM Table_1 WHERE Item_ID = 1

me query eka hadaganna mata udau karanawada. Table_2 wala result ekak namthnam mata one value eka 0 value ekak widihata return ekak karanna. eth meka hariyata wada karanne nane. danna kenek ennawa nam udau karanna. anith ayagen bump ekak wath balaporoththu wenawa. mama use karanne SQL Server Express 2008.

 

[twisted]

select itemname,isnull(sum(isnull(itemquanitty,0)),0) totalItem
from table_1,table_2
where table_1.item_id = table_2.item_id
and table_1.item_id = 1
group by itemname

 

[kandya]

bump

 

[Elaaz]

select itemname,isnull(sum(isnull(itemquanitty,0)),0) totalItem
from table_1,table_2
where table_1.item_id = table_2.item_id
and table_1.item_id = 1
group by itemname

thanks machan. mama try karala balannam

 

[chirart1]

SQL dannawa poddak................prashne pahadili madi.....

 

[Elaaz]

select itemname,isnull(sum(isnull(itemquanitty,0)),0) totalItem
from table_1,table_2
where table_1.item_id = table_2.item_id
and table_1.item_id = 1
group by itemname

yaluwa prasne ahema mai. result ekak enne na.

 

[Elaaz]

SQL dannawa poddak................prashne pahadili madi.....

Table dekak thiyenawa. Table_1 walin column kepayak ekka Table_2 wala column kepayakin data ganna one. Table_2 wala column ekaka mama select karana value nathnam mata value eka 0 kiyala return karanna one.

 

[Elaaz]

Bump!

 

[ltty head]

Plese export your two tables and post it here.. thn we may try up..

 

[ltty head]

Table_1 walin column kepayak ekka Table_2 wala column kepayakin data ganna one.

USE JOIN

 

[ltty head]

Table_2 wala column ekaka mama select karana value nathnam mata value eka 0 kiyala return karanna one.

Dan kohomada display wenne ??? null kiyalada ?

 

[ltty head]

try with these functions.. instead of ISNULL()..

NVL(), IFNULL(), and COALESCE()

 

[ltty head]

give some sample data.. i can give a try for you... not an expert of MSSQL.. but MYSQL AND PGSQL

 

[twisted]

yaluwa prasne ahema mai. result ekak enne na.

post your tables here, what I posted above should work if you got your data on the tables and the fields name were typed correctly
what's the error you get? post the error message as well.

and try this


select itemname,isnull(sum(isnull(itemquanitty,0)),0) totalItem
from table_1 left join table_2
on table_1.item_id = table_2.item_id
where table_1.item_id = 1
group by itemname

 

[temp_]

select ItemName, (select isnull(sum(ItemQuantity),0) from Table2 where itemId=1) as TotalItem
FROM Table_1 one, Table_2 two
WHERE one.Item_ID = two.Item_ID and one.Item_ID=1

 

[viroguy]

English Kiyanda..

Can you pls post your question in English? mata singala only tikak tikak thamai thannawa

I assume that you want to return 0 instead null...try with IIF condition.
like.. IIF(isnull(itemquanitty,0))...

 

[Elaaz]

post your tables here, what I posted above should work if you got your data on the tables and the fields name were typed correctly
what's the error you get? post the error message as well.

and try this


select itemname,isnull(sum(isnull(itemquanitty,0)),0) totalItem
from table_1 left join table_2
on table_1.item_id = table_2.item_id
where table_1.item_id = 1
group by itemname

yaluwa oya anthimata dunna code eka hari. eka wada karanawa. godak sthuthi. mama meka wisadaganna godak wela mahansi una. dan prasne wisaduna.

 

[Elaaz]

try with these functions.. instead of ISNULL()..

NVL(), IFNULL(), and COALESCE()

godak sthuthi yaluwa. mage gataluwa wisaduna.

 

[Elaaz]

select ItemName, (select isnull(sum(ItemQuantity),0) from Table2 where itemId=1) as TotalItem
FROM Table_1 one, Table_2 two
WHERE one.Item_ID = two.Item_ID and one.Item_ID=1

Thanks

Can you pls post your question in English? mata singala only tikak tikak thamai thannawa

I assume that you want to return 0 instead null...try with IIF condition.
like.. IIF(isnull(itemquanitty,0))...

Thank you very much friend. finally solved my problem!!!

 

[twisted]

yaluwa oya anthimata dunna code eka hari. eka wada karanawa. godak sthuthi. mama meka wisadaganna godak wela mahansi una. dan prasne wisaduna.

that means you ain't got shit on your second table
no trouble btw. glad to have helped.