Database

A Wong4-Apr-08 9:02

A Wong

4-Apr-08 9:02

Shouldn't you be inner joining on condition?

Snowman584-Apr-08 9:10

Snowman58

4-Apr-08 9:10

I have tried specifying the joins as "inner" - it made no difference.
(My understanding is that MySQL interperts a join as "inner" unless otherwise specified.)

I have also tried being specific on the join member i.e. join on hangerID.

Also made no difference.

Thanks!

A Wong4-Apr-08 9:54

A Wong

4-Apr-08 9:54

Have you tried selecting from the smallest table first?

Snowman584-Apr-08 10:00

Snowman58

4-Apr-08 10:00

Yes - I have tried all combinations I could think of. The Explain output is identical no matter what order I use.

Frustrating!

Thanks

suppaman5-Apr-08 4:24

suppaman

5-Apr-08 4:24

Hello Mr. Member 4723455,
I always think it's better to put relational condition in "ON" clause of JOIN.
You can try:

select assemdata.AssemNum,innerpack.Descrip,hanger.Descrip
from hanger
join assemdata on assemdata.hangerID = hanger.HangerID
join innerpack on assemdata.InnerPackTypeID = innerpack.InnerPackID
where assemdata.Assemnum >=60000 and assemdata.Assemnum <=60050

Bye, (sorry for my bad English) Sniff | :^)

Snowman586-Apr-08 16:17

Snowman58

6-Apr-08 16:17

Suppaman,

I have tried it both ways i.e. using "join on table1.id=table2.id" & using "where table1.id=table2.id".

The results from an Explain Select are identical. But I agree the on method is easier to read.

Thanks!

Hown to select the telephone number that is most dialled

suppaman10-Apr-08 13:11

suppaman

10-Apr-08 13:11

You can try using views:
first create a view to filter out elements of assemdata with Assemnum >=60000 and Assemnum <=60050 (50 elems) then join this view with the other two table. In this way the query plan should be different and the query execution faster (I think).
Bye ^__^

SQL 2000 Problem

hrrty4-Apr-08 1:48

hrrty

4-Apr-08 1:48

I am trying to run windows application against SQL Server 2000 and get error message dot net 2005 is developement environment

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Both app and SQL server are local

connection string is

""Data Source={m};Initial Catalog=dbname;Integrated Security = SSPI; Trusted_Connection=Yes;"

I have tried enabling TCPIP protocoll on 2005 server but it does not help.

Please help

Thanks
Manish

Re: SQL 2000 Problem

GuyThiebaut4-Apr-08 11:30

GuyThiebaut

4-Apr-08 11:30

hrrty wrote:
I am trying to run windows application against SQL Server 2000

hrrty wrote:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005

The error message says it all, your connection appears to think it should be connecting to SQL Server 2005.

You always pass failure on the way to success.

Daniel_Logan3-Apr-08 23:52

Daniel_Logan

3-Apr-08 23:52

I have a column of telephone numbers that I am trying to get the most dialled number from. Can anyone help?

Re: Hown to select the telephone number that is most dialled

Colin Angus Mackay4-Apr-08 0:25

Colin Angus Mackay

4-Apr-08 0:25

SELECT COUNT(*), TelephoneNumber
From MyTable
GROUP BY TelephoneNumber

You might want to put in an ORDER BY there too. If you are only interested in the highest value then:

SELECT TOP 1 COUNT(*), TelephoneNumber
From MyTable
GROUP BY TelephoneNumber
ORDER BY COUNT(*) DESC

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Mixins in C#3.0

My website | Blog

Difference between Correlated and Simple Subqueries

.NET- India 3-Apr-08 23:50

.NET- India

3-Apr-08 23:50

What is the difference between Difference between Correlated and Simple Subqueries

Re: Difference between Correlated and Simple Subqueries

pmarfleet4-Apr-08 0:03

pmarfleet

4-Apr-08 0:03

.NET- India wrote:
What is the difference between Difference between Correlated and Simple Subqueries

Have you not heard of a search engine[^]? I typed your question into Google and got plenty of results.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Difference between Correlated and Simple Subqueries

.NET- India 4-Apr-08 0:15

.NET- India

4-Apr-08 0:15

Please Friend dont give this type of answers. If you dont want to give me the annswer please dont give me but if you want to give me thnx

Re: Difference between Correlated and Simple Subqueries

Krazy Programmer4-Apr-08 0:22

Re: Difference between Correlated and Simple Subqueries

4-Apr-08 0:22

is this your question What is difference between Co-related sub query and nested sub query?
then might be the answer http://www.geekinterview.com/question_details/17300[^]

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

pmarfleet4-Apr-08 0:35

pmarfleet

4-Apr-08 0:35

.NET- India wrote:
Please Friend dont give this type of answers.

What do you mean? I gave you an answer to your question.

If you don't know how to use a search engine to find answers to questions, I suggest you read this article[^]. Being able to use a search engine is pretty much a prerequisite for being a developer, so I suggest you learn fast.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Incorrect syntax near stored procedure

Krazy Programmer3-Apr-08 23:36

3-Apr-08 23:36

hi I am using sql 2000 as database and windows form done in c# as the interface

I am having some 8 stored procedures in the project all are working fine except 1
Error which i got is ("Incorrect Syntax near SP_drivers")
i have checked it in DB by inserting values its working fine
but through interface its giving error
Thanks in Advance

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Pete O'Hanlon3-Apr-08 23:53

Pete O'Hanlon

3-Apr-08 23:53

Without seeing your C# code, it's hard to say what the problem could actually be.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Krazy Programmer4-Apr-08 0:03

4-Apr-08 0:03

its a bog code from here just i am passing parameters

connection = new SqlConnection(sql);
command = new SqlCommand("SP_Driver_WMile_Desc", connection);
connection.Open();
if (availability == true)
command.Parameters.AddWithValue("@Mode", "U");
else
command.Parameters.AddWithValue("@Mode", "I");
command.Parameters.AddWithValue("@Rate_ID", selected_node_parent);
command.Parameters.AddWithValue("@Vehicle_ID", selected_node);
command.Parameters.AddWithValue("@Drv_rate_ID", selected_driverrate);
if (rbtnWaitingDriverprice.Checked == true)
command.Parameters.AddWithValue("@Driver_Round_Type", true);
else
command.Parameters.AddWithValue("@Driver_Round_Type", false);
if (cboxWaitingDriver.SelectedItem.ToString() == "Up")
command.Parameters.AddWithValue("@Driver_Rounding", true);
else
command.Parameters.AddWithValue("@Driver_Rounding", false);

if (txtWatingDriverNearest.Text == "")
txtWatingDriverNearest.Text = "0";

command.Parameters.AddWithValue("@Driver_Nearest", txtDrivertonearest.Text);

for (i = 1; i <= 10; i++)
{
if (Waiting_Driver_Gridview[0, i - 1].Value == "")
command.Parameters.AddWithValue("@Driver_Mile_Box_" + i.ToString(), 0.00);
else
command.Parameters.AddWithValue("@Driver_Mile_Box_" + i.ToString(), Convert.ToDouble(Waiting_Driver_Gridview[0, i - 1].Value));
}

for (i = 1; i <= 10; i++)
{
if (Waiting_Driver_Gridview[1, i - 1].Value == "")
command.Parameters.AddWithValue("@Driver_Charge_Box_" + i.ToString(), 0.00);
else
command.Parameters.AddWithValue("@Driver_Charge_Box_" + i.ToString(), Waiting_Driver_Gridview[1, i - 1].Value);
}
command.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Data Added Successfully ", "Data Adition", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Pete O'Hanlon4-Apr-08 1:31

Pete O'Hanlon

4-Apr-08 1:31

You don't have anything in your code to tell it that you are using a stored procedure. You need to set the command type to CommandType.StoredProcedure. By default, it will try to execute this as a straight forward piece of SQL.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Krazy Programmer4-Apr-08 2:06

4-Apr-08 2:06

Thank You very much ...actually got exhausted today because of heavy work

thank you once again

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.