|
Colin Angus Mackay wrote: Use the normal brackets ()
Sir, where i have to use the normal brackets () ?
|
|
|
|
|
Oh Sorry, i'll change the bracket.
Thanks
|
|
|
|
|
dansoft wrote: Sir, where i have to use the normal brackets () ?
Where do you think?
I highlighted the fact you were using braces {} and that it was wrong. Replace the {} with ()
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Hi,
Does Anyone know how to change the size of LEGEND Box in any chart of RDL File? There are many details in LEGEND area of my chart which makes legend area much congested.
Thanks in Advance
|
|
|
|
|
Hi,
why the select query is not returning the decimal value?
consider the following query:
select 1/2
it is returning 0
it must return 0.5 Please help.
Thanks
|
|
|
|
|
Because it is doing an integer division and truncating everything past the decimal point.
use SELECT 1.0/2.0
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I need to use the colname. for eg: select colname1/colname2 from table
the colname1 has the value 1 & colname2 has the value 2
thanks
|
|
|
|
|
Then cast the column values to float s
SELECT CAST(colname1 AS FLOAT) / CAST(colname2 AS FLOAT) FROM MyTable
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Colin Angus Mackay wrote: SELECT CAST(colname1 AS FLOAT) / CAST(colname2 AS FLOAT) FROM MyTable
Thanks
It is working
|
|
|
|
|
Hi,
I want to delete Duplicate rows from the table
Thanking you.....
Balu
|
|
|
|
|
What is the structure of your table? (i.e. field names and data types)
----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin
|
|
|
|
|
|
Hi
I have an Database in SQLServer in that i have no. of tables with primary key's and forign key's
I want to see the Script of the databse in
SQLServer Enterprice manager
Is it posible to see the whole (1 database)database scripts
Like "CASE Studio 2"
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
hi,
I have a table like
saleno Itemname Qty
1 M.board 10
2 Mouse 20
3 Keyboard 20
4 H.disk 30
5 Monitor 40
after the Update Query i want the result(just add qty with above Qty value in base table)
saleno Itemname Qty
1 M.board 10
2 Mouse 30
3 Keyboard 40
4 H.disk 50
5 Monitor 70
Thank you fro your reply
Balu
|
|
|
|
|
Sorry, I don't understand what you want.
To update a row in a table you can use
UPDATE MyTable SET Qty = 70 WHERE saleno = 5
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Hi Balu,
Here's your reply.
If you have a proper sequence with no missing links use the following:
Select a.saleno,b.saleno, coalesce(a.qty,0)+coalesce(b.qty,0) as Qty
from tbl_Sale a left join tbl_sale b
ON a.saleno=b.saleno+1
Else use the following:-
Select a.saleno,coalesce(a.qty,0)+COALESCE((Select b.Qty from tbl_Sale b where b.saleno=
(Select max(c.saleno) from tbl_sale c where c.saleno
|
|
|
|
|
Oh! I see what he was getting at now. I really do wish people would say what they want rather than have everyone guess what they want through some cryptic IQ test what-is-the-next-number-in-the-sequence style question.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
-- modified at 5:22 Wednesday 19th April, 2006
|
|
|
|
|
|
how to lock an individual table in sql server database ?
krishna
|
|
|
|
|
Is there any way to get the existing Oracle service names(Stored in TNSNAMES.ORA) using C#.
|
|
|
|
|
What is TNSNAMES.ORA? A table, a file or something else?
phi
phimix.com
|
|
|
|
|
TNSNAMES.ORA is An Oracle Network Configuration File.The following is a sample file:
<br />
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora<br />
# Generated by Oracle configuration tools.<br />
<br />
CLCX =<br />
(DESCRIPTION =<br />
(ADDRESS_LIST =<br />
(ADDRESS = (PROTOCOL = TCP)(HOST = 200.22.10.6)(PORT = 1521))<br />
)<br />
(CONNECT_DATA =<br />
(SID = ORCL) (SERVER = DEDICATED)<br />
)<br />
)<br />
|
|
|
|
|
Then you should at least be able to use the System.IO functions like ReadLine(). I don't know if there are any methods specifically for working with Oracle files, but it's quite easy to implement some file reading with System.IO.
phi
phimix.com
|
|
|
|
|
(new replyers please refer previous msg (after signature))
thanks for your help. but we need more information.
in our project we have one table say t1.in that columns are c1, c2 ,c3,c4 .outwhich c4 is a column such that it is another table say nestedtabl1.in that also nc1,nc2,nc3 likewise columns.where nc3 is varrying array.so we are trying to access data of these tables through ado.net but but it is giving error.we are using oledb provider
does it useful to access nested table of oracle.is it important to use "oracle provider" only?
and also we are using disconnected approach then how to read the data of tables ,and bring it into dataset.
please help us as early as possible.
kam_ps
---------------------------------
new replyers please refer following----------
In a database management project ,we have used Oracle at back-end and VB.Net at front-end.
In Oracle ,we used object-oriented features and created nested tables.Now we want to accesss those nested tables using ADO.Net .We are in search of answers of following questions:
1.Does Dataset class of ADO.Net support nested tables ?
2.If yes,can XML be used to specify schema of nested dataset ?
3.If not,how to manipulate nested tables of Oracle in ADO.Net?
As a temporary solution , we are retrieving main table and child table in two different tables;but this mechanism of database handling is affecting preformance of project badly.So we are in need of some other efficient solution.We will be thankful for your response if you will be able to help us to get out of the problem .Please reply as early as possible.
kam_ps
-- modified at 16:21 Tuesday 18th April, 2006
|
|
|
|
|
there is nothing like nested table in ado.net. But, the solution is there where the relational features of dataset comes in picture.
fetch both the tables separately and add a foreign key relation between them. Then using methods like getchildrows, etc, you can get ur prob solved.
Best Regards,
Darpan Gogia
|
|
|
|