|
the query you sent not return the data as i explained in the result
thank you
|
|
|
|
|
Well, I did say it assumed all the names in table 2 were in table 1!
To be honest, its a rubbish design in the first place, and whoever designed it should be sacked. However, I expect in reality I am doing your homework for you, so here you are:
select t1.name, t1.course, t2.course
from table_1 t1
left outer join table_2 t2 on t2.name = t1.name
union
select t2.name, t1.course, t2.course
from table_2 t2
left outer join table_1 t1 on t1.name = t2.name
where t1.name is null
Bob
Ashfield Consultants Ltd
|
|
|
|
|
SELECT *
FROM table1
FULL OUTER JOIN table2
ON table1.name = table2.name
"We can't solve problems by using the same kind of thinking we used when we created them"
|
|
|
|
|
the solution is not correct
|
|
|
|
|
SELECT b.n, a.c, b.c AS c1
FROM a RIGHT OUTER JOIN
b ON a.n = b.n
UNION ALL
SELECT a.n, a.c, b.c AS Expr1
FROM a LEFT OUTER JOIN
b ON a.n = b.n
Venky
|
|
|
|
|
Hello
I want to fetch record in a pair of 100. First time I want Records from 1 to 100 then 101 to 200 and so on.
Is there any way to solve this problem.
Thanks
Syed Shahid Hussain
|
|
|
|
|
|
When i installed i got this error.so what should i do
The error i found:
sql server failed to start sqlserver books online:"how to view sql server 2005 setup Logfiles and starting sql server manually
|
|
|
|
|
To get back your sql 2005 help / documentation, you need to re-install the sql server client tools
Venky
|
|
|
|
|
When display MA lines, does it need to save the MA values into the database after the first calculation of these values?
I'm not sure whether the performance is a problem. If not, the software will be more agile by not saving the intermediate data.
system
|
|
|
|
|
Do you think anyone knows what you are talking about? What is MA?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
MA = Moving Average
For example, I have 5 numbers as below
1 2 3 4 5
now MA2 means the average of every 2 numbers, it all like this
original: 1 2 3 4 5 6
ma2: - 1.5 2.5 3.5 4.5 5.5
MA2(n) = (ORG(n)+ORG(n-1))/2;
system
|
|
|
|
|
do you need to retreive the interim values from the database EVER. This is your answer.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
can i use excel "almost" like a database?
i thinks on using a sheet like table and workbook like database,validations fine (don´t need key: i don´t get many errors from there)
My problem is the sql statements, can i query it(excel data)?
i don´t know how, i think also sql statement in c# don´t work in this case.
must i use xml?
(no code needed)
thanks
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
You can use VB6 which lets you use SQL statements. I don't think you can use XMl unless it's 2003 or above. No C#.
Blog link to be reinstated at a later date.
|
|
|
|
|
Hello,
You can use excel sheet as an Database, and you can also query it like regular Access or Sql Database.you can use oledb connection to excel file from your vb.net or c# application.
Use the connection string below,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XLFile.XLS; Extended Properties="Excel 8.0; HDR=No;"
|
|
|
|
|
Hi,
When i installed sql server its giving error:
sql server service failed to start
|
|
|
|
|
What Error do you get ?
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
When i installed sql server its giving error:
sql server service failed to start:sql server books online:"how to view sql 2005 setup logfiles and sql server manually
I have sql server configuration manager.How can i use this to create database and table.Please help me.
|
|
|
|
|
Hi,
I installed sql server 2008 .It installed but it has configuration not enterprise.I need to work in asp.net.so pls give me website where i can load.
Thanks
|
|
|
|
|
mkalantri wrote: it has configuration not enterprise
What does that mean? The version is not SQL Server 2005 Enterprise Edition or what?
Enterprise edition is downloadable only as a trial version. If you want to actually use it, you must buy it.
modified on Tuesday, September 9, 2008 4:56 PM
|
|
|
|
|
Hi,
i downloaded it's giving error.it's trail based.I have MySQL but i am unable to connect MYSQL with asp.net.If you have idea pls let me know how to do it.
Thanks
|
|
|
|
|
I'm sorry, but cannot help you with MySQL.
Your original post was about SQL Server 2005 (or 2008, didn't quite figure out) which is a completely different product than MySQL.
|
|
|
|
|
I have MYSQL.I need to know how to connect to asp.net.
Or
I know how to connect sql server.
so please hell me
thanks
|
|
|
|
|
Try this link clickety[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|