<div>
did you try<br />
WHERE &nbsp; &nbsp; (Users.Account_Disabled = 0)<br />
?
</div>


did you try
WHERE     (Users.Account_Disabled = 0)
?

<div>
<div class="content wysiwyg-content">
Hi<br />
I have a strored procedure which part of it is as below..<br />
It keeps syaing incorrect syntax...<br />
ANyone tell me what is wrong?<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;insert into &nbsp;Details &nbsp;(FIeld naems etcc)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SELECT &nbsp; &nbsp; FIeld Names etc<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM Another_Details left outer join users on aother_details.officer_id = users.attendant_id <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Where ID = @KeyID and Registration_No &gt;''<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE &nbsp; &nbsp; (Users.Account_Disabled = '0')<br />
<br />
Obviously field names is jst a summary of the fileds in the table..<br />
its the WHERE &nbsp; &nbsp; (Users.Account_Disabled = '0') bit which has caused the problem...<br />
Cheers<br />
Mat
</div>
</div>


Hi
I have a strored procedure which part of it is as below..
It keeps syaing incorrect syntax...
ANyone tell me what is wrong?

	insert into  Details  (FIeld naems etcc)
	                SELECT     FIeld Names etc
			FROM Another_Details left outer join users on aother_details.officer_id = users.attendant_id 
                                        Where ID = @KeyID and Registration_No >''
			WHERE     (Users.Account_Disabled = '0')

Obviously field names is jst a summary of the fileds in the table..
its the WHERE     (Users.Account_Disabled = '0') bit which has caused the problem...
Cheers
Mat

Anyone tell me what is wrong with this?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.