| Author |
Message |
    
Vidhata
Pilla Bewarse
Username: Vidhata
Post Number: 60
Registered: 09-2005
Posted From: 63.87.170.126
| | Posted on Tuesday, July 18, 2006 - 9:16 am: |    |
>>>so maybe u need to build @vendornumber in that format>>>
adi ela build cheyya lo teliyadam ledu mama |
Amar
Kurra Bewarse
Username: Amar
Post Number: 849
Registered: 03-2004
Posted From: 67.173.167.76
| | Posted on Monday, July 17, 2006 - 8:29 pm: | |
sql case sensitive kadu
in vadite u have to use () with the parameter enclosed in ''
for example
select * from tblTest where employeeId in ('123','456','789')
so maybe u need to build @vendornumber in that format |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8879
Registered: 06-2004
Posted From: 65.208.22.26
| | Posted on Monday, July 17, 2006 - 6:02 pm: | |
yaa nenu oracle lo chepthunna mama
but naa point entante tweak it in different ways
or write a simple procedure and see ela vasthundi ani
coz naa daggara sql2000 ledu maama |
Vidhata
Pilla Bewarse
Username: Vidhata
Post Number: 59
Registered: 09-2005
Posted From: 63.87.170.126
| | Posted on Monday, July 17, 2006 - 5:59 pm: | |
sql server lo "+" vadali kada concat cheyyadaniki, adi vadina tantondi
enduko ardam kavadam ledu...
any way thanks mama..intiki potunnanu.. |
Vidhata
Pilla Bewarse
Username: Vidhata
Post Number: 58
Registered: 09-2005
Posted From: 63.87.170.126
| | Posted on Monday, July 17, 2006 - 5:58 pm: | |
Babu mama nuvvu Oracle lo cheptunnava...
nenu adugutondi T-sql Microsoft Sql server 2000 ki |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8878
Registered: 06-2004
Posted From: 65.208.22.26
| | Posted on Monday, July 17, 2006 - 5:56 pm: | |
mari adhe kadha mama problem
having vno in ( & ani ivvu
quotes double time ivvu
it depends upon the editor u use
ex toad vaadu vere treat chesthadu some strings ni |
Vidhata
Pilla Bewarse
Username: Vidhata
Post Number: 56
Registered: 09-2005
Posted From: 63.87.170.126
| | Posted on Monday, July 17, 2006 - 5:50 pm: | |
Value vastondi mama ..brackets (..) missing kani
kani brackets ela ivvalo teliyadam ledu
...having vendornumber in'('+ @VendorNumber +')'
ila try chesanu kani work avadam ledu |
Thodakottu
Bewarse ke Bewarse!
Username: Thodakottu
Post Number: 13971
Registered: 03-2004
Posted From: 68.80.43.87
| | Posted on Monday, July 17, 2006 - 5:47 pm: | |
mama nuvvu janala knowledge testing aaaa 
shshshshhhh.......Hearing is Going On, No Roaring in Between.. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8877
Registered: 06-2004
Posted From: 65.208.22.26
| | Posted on Monday, July 17, 2006 - 5:47 pm: | |
mama vendor number ela vasthundi
r u sure it is coming in (....)
brackets miss avuthunayya else naakemi prob kanapadala |
Vytwo
Vooriki Bewarse
Username: Vytwo
Post Number: 4760
Registered: 01-2005
Posted From: 162.119.64.111
| | Posted on Monday, July 17, 2006 - 5:47 pm: | |
manamu chaala weak leee //
strong nitho ni adigi cheppu mama.
Live life like sinna |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 2395
Registered: 11-2004
Posted From: 66.41.162.128
| | Posted on Monday, July 17, 2006 - 5:46 pm: | |
w3schools.com loo choodu mama
manamu chaala weak leee  |
Vidhata
Pilla Bewarse
Username: Vidhata
Post Number: 55
Registered: 09-2005
Posted From: 63.87.170.126
| | Posted on Monday, July 17, 2006 - 5:45 pm: | |
>>vendornumber loo v capital aaaa>>>
mama idi sql sever 2000, asalu case senistive kadu..
ade query ni IN tesesi is equal to pedite pani chestondi
select Vendornumber,Currency,sum(invoiceamount) as TotalAmount from approvedinvoices
group by vendornumber,Currency
having vendornumber = @VendorNumber
order by vendornumber, Currency Desc
ila mariste pani chestundi...
string concatenation issue ikkada ani naa feeling} |
Vidhata
Pilla Bewarse
Username: Vidhata
Post Number: 54
Registered: 09-2005
Posted From: 63.87.170.126
| | Posted on Monday, July 17, 2006 - 5:42 pm: | |
ledu mama adi kadu prob..sql server case sensitive kadu mama.. |
Thodakottu
Bewarse ke Bewarse!
Username: Thodakottu
Post Number: 13967
Registered: 03-2004
Posted From: 68.80.43.87
| | Posted on Monday, July 17, 2006 - 5:42 pm: | |
vendornumber loo v capital aaaa
>>>order by vendornumber, Currency Desc
shshshshhhh.......Hearing is Going On, No Roaring in Between.. |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 2394
Registered: 11-2004
Posted From: 66.41.162.128
| | Posted on Monday, July 17, 2006 - 5:41 pm: | |
uppercase lower case lathoo jagartta..
tables loo field ela vuntee adhee rayi |
Vidhata
Pilla Bewarse
Username: Vidhata
Post Number: 53
Registered: 09-2005
Posted From: 63.87.170.126
| | Posted on Monday, July 17, 2006 - 5:38 pm: | |
babulu ee tokkalo sql server 2000 query lo em tappu chesano cheppandi pls..
select Vendornumber,Currency,sum(invoiceamount) as TotalAmount from approvedinvoices
group by vendornumber,Currency
having vendornumber in @VendorNumber
order by vendornumber, Currency Desc
incorrect syntax near @VendorNumber ani vasondi...
@vendornumber is the input for the StoredProc..
sample value (123,124,125) |
