473,327 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Msg 170, Level 15, State 1

This error has been reported in a number of previous occasions. However in my case non of the suggested solutions appears to work

--==================================================
CREATE VIEW dbo.vAllLesions
AS SELECT
dbo.Patients.idP, dbo.Patients.Surname, dbo.Patients.GName, dbo.Patients.Sex,
dbo.Patients.DoB, dbo.Lesions.idL, dbo.Lesions.OriginalIdBase,
dbo.Lesions.OriginalIdL,
dbo.Lesions.Notes,
dbo.Lesions.idBatch,
dbo.UserLesionFlags.value As FlagValue
FROM********
dbo.Lesions INNER JOIN
****************dbo.Patients ON dbo.Lesions.idP = dbo.Patients.idP LEFT OUTER JOIN
****************dbo.UserLesionFlags ON dbo.Lesions.idL = dbo.UserLesionFlags.idL
WHERE**** (dbo.Patients.Exported = 0) AND (dbo.Patients.DeletedDay IS NULL) AND (dbo.Lesions.DeletedDay IS NULL)
GO
--
================================================
Server: Msg 170, Level 15, State 1, Procedure vAllLesions, Line 10
Line 10: Incorrect syntax near '*'.
Acoording to the error report there is a proplem with inner join but just what is the problem.
Regards
Joe
Jul 9 '07 #1
1 3816
This error has been reported in a number of previous occasions. However in my case non of the suggested solutions appears to work
Joe
Sorry for the trouble. Turned out to be hidden characters that I removed using (guess what) Edit.
Regards
joe
Jul 9 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: nicki | last post by:
hi we have a link server....and the user credentials are not being trasfered to link server.....any thoughts?? we get the following error message Server message 18542 level 16 state 1 --...
4
by: Mike MacSween | last post by:
It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4 subforms. (I like tabbed forms by the way - do we all?) Basically the subforms are different ways of looking at the...
4
by: SHPsalm139 | last post by:
If I'm in, say, a 3rd level sub and want to exit, not only the sub but the entire procedure, without a GoTo, can this be done without using switches?
5
by: Pross | last post by:
I've got an ASP.NET application and I need some information on every page like the user's name as well as a collection listing which sections of the application the user has access to. I could...
3
by: Branco Medeiros | last post by:
Dear (and mighty) all: I backed up a database (SQL server 7.0) and tried to restore it on another system (SQL Server 2000). This is not the first time I'm doing this and never had a problem...
9
by: MR | last post by:
I get the following Exception "The data at the root level is invalid. Line 1, position 642" whenever I try to deserialize an incoming SOAP message. The incoming message is formed well and its...
4
by: chandu | last post by:
Hello, declaring class level variables is good approach or not in c#. in C++ we used prefer diclaring class level variables more than local variables. i had a discussion with somebody that...
1
by: Ruth413 | last post by:
Hello - I am getting the these errors in my sql 2005 generated script. I am stuck with first error. Please help.... Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('. Msg 319,...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.