incorrect syntax near LEFT

this is the query im trying to execute in sql server.please let me know what is the error in this

SELECT "PROJECT"."PROJ_NAM", ' ' as dev_name, "PROJECT_FUND"."F_FUND_ID" as fund_id, view_on_watch_list.on_date
FROM LEFT OUTER JOIN view_on_watch_list ON project.proj_id =view_on_watch_list.proj_id , "PROJECT_FUND" LEFT OUTER JOIN "FUND" ON "PROJECT_FUND"."F_FUND_ID" = "FUND"."FUND_ID" AND project.proj_id = project_fund.f_proj_id , "PROJECT" WHERE (("PROJECT"."PROJ_ID" = 1))
select "PROJECT"."PROJ_ID", ' ' AS DEV_TYPE from PROJECTFROM LEFT OUTER JOIN
Enter Table_Name after "FROM" clause...

project.proj_id = project_fund.f_proj_id , "PROJECT" WHERE (("PROJECT"."PROJ_ID" = @.proj_id))
select "PROJECT"."PROJ_ID", ' ' AS DEV_TYPE from PROJECT
I didn't get what you want to do... Post your table structure, data & your requirement.|||actually im a beginner in MSSQL.im not aware of this LEFT OUTER JOIN syntax.
i tried with placing table name after 'LEFT' ,below error was thrown

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Tables or functions 'project' and 'PROJECT' have the same exposed names. Use correlation names to distinguish them.|||Wel Come :)

Before you use query in application code, run & check it using SQL Query Analyzer.

Develop query step by step i.e. don't write entire query at once but create 1st then 2nd phrase etc...

Spend some time to learn, you can refer SELECT syntax in Books OnLine from SQL Query Analyzer.|||Hi

If you are just starting you might find this a gentler learning curve:
http://www.w3schools.com/sql/sql_intro.asp

rajeshpatel is spot on - don't write out loads at once - write a small section, run, if it works write some more else refer to the link and correct.

HTH|||thank u rajesh.im familiar with sql's(DDLS and DMLS).please guide me to the correct query for the above one.|||I'm afraid the SQL is so bad it is not possible to tell what you want you want to do. I strongly recommend you read the link and have another stab at writing it. As you come up against problems get back to us with specifics.

If you build up a bit at a time it might be possible to infer what you are actually attempting to do.

Incorrect syntax near 'COLLATE'

Hi,
I have an ACCESS ADP project that hooks to an SQL database. I have been
working on in may ws and it is ready to go. While testing yesterday, I
found that when I know try to open a table from ACCESS, I get the above erro
r
message. I can still see it OK in EM. Today, when I call one of my Stored
procs from ACCESS code, I get this message also. So I get it when trying to
open all tables, and so far when I call one stored Proc. I have done severa
l
searches on it, and they all talk about using DTS to import tables. This
isn't the case. I am not using COLLATE in my SQL.
Any thoughts?Try refreshing the linked tables.
Derek Davis
ddavis76@.gmail.com
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:8F0BDC8F-4BFF-4AE3-A4ED-DC172B041475@.microsoft.com...
> Hi,
> I have an ACCESS ADP project that hooks to an SQL database. I have been
> working on in may ws and it is ready to go. While testing yesterday, I
> found that when I know try to open a table from ACCESS, I get the above
> error
> message. I can still see it OK in EM. Today, when I call one of my
> Stored
> procs from ACCESS code, I get this message also. So I get it when trying
> to
> open all tables, and so far when I call one stored Proc. I have done
> several
> searches on it, and they all talk about using DTS to import tables. This
> isn't the case. I am not using COLLATE in my SQL.
> Any thoughts?
>|||Hi,
It is an ACCESS Data Project. You don't really link to tables like in an
.mdb. Unless I misunderstood you. I did disconnect from the SQL database
and reconnect.
Steve
"carion1" wrote:

> Try refreshing the linked tables.
> --
>|||More info.
When I try to run the stored proc via QA in debug I get the same message on
the first fetch in the proc. Worked fine the last couple ws and there
have been no changes to the code. I did set replication up for this databas
e
and successfully used in yesterday. So with ACCESS out of the picture, stil
l
having problems. Also updated to SP4 recently.
"SteveInBeloit" wrote:

> Hi,
> I have an ACCESS ADP project that hooks to an SQL database. I have been
> working on in may ws and it is ready to go. While testing yesterday, I
> found that when I know try to open a table from ACCESS, I get the above er
ror
> message. I can still see it OK in EM. Today, when I call one of my Store
d
> procs from ACCESS code, I get this message also. So I get it when trying
to
> open all tables, and so far when I call one stored Proc. I have done seve
ral
> searches on it, and they all talk about using DTS to import tables. This
> isn't the case. I am not using COLLATE in my SQL.
> Any thoughts?
>

Inconsistent Database Performance

Hi,

I am facing a peculiar problem while looking ahead in a live Database
currently under operation in one of my clients Project. An
Application that is updating 3 - tables in the Database is missing to
update a certain number of Fields in one of the Tables. The fact is
not frequent and I have checked through the Server Performance Monitor
that there is no performance slag of the Server during any point of
time.

The Tables are indexed with common Key fields. Can anybody help me in
this regard ?

Thanks & Regards.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Dis...pict193836.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=655931"gangulyarindam" <UseLinkToEmail@.dbForumz.com> wrote in message
news:42010bd1$1_5@.alt.athenanews.com...
> Hi,
> I am facing a peculiar problem while looking ahead in a live Database
> currently under operation in one of my client's Project. An
> Application that is updating 3 - tables in the Database is missing to
> update a certain number of Fields in one of the Tables. The fact is
> not frequent and I have checked through the Server Performance Monitor
> that there is no performance slag of the Server during any point of
> time.
> The Tables are indexed with common Key fields. Can anybody help me in
> this regard ?
> Thanks & Regards.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/General-Dis...pict193836.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=655931

You can use Profiler to see exactly what commands the application is sending
to MSSQL - sometimes an application may not be doing what you think it is,
especially if it builds SQL strings dynamically.

If that doesn't help, you would need to give some more information about
your environment and exactly what is going wrong.

Simon|||gangulyarindam (UseLinkToEmail@.dbForumz.com) writes:
> I am facing a peculiar problem while looking ahead in a live Database
> currently under operation in one of my client's Project. An
> Application that is updating 3 - tables in the Database is missing to
> update a certain number of Fields in one of the Tables. The fact is
> not frequent and I have checked through the Server Performance Monitor
> that there is no performance slag of the Server during any point of
> time.
> The Tables are indexed with common Key fields. Can anybody help me in
> this regard ?

There is far too little information to give much useful advice. But
it certainly sounds like an application problem to me. Maybe there is
some bad error handling. Maybe you have a poor transaction scope, so
that the update is carried out partly.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

In VS2005 where is Buisness Intelligence Project Option

Dear All,

I am using Visual studio .Net 2005. and i want to create report using sql server reporting services
for sql server 2000.
there is Buisness Intelligence Projects option in Visual studio .Net 2003 but this option
is not present in my vs2005 editor.
where is it exactaly resides or is there any way to do that.

Hi,

VS2005 does not have BI projects. These items are now part of SQL2005. You can install BI items from SQL2005 setup.