<div>
works like a charm. thanks!
</div>


<div>
<div class="content wysiwyg-content">
hello: i'm trying to get the right syntax for...<br />
<br />
DECLARE @sessionId int<br />
<br />
SELECT @sessionId = 1 + CONVERT(float,ISNULL(MAX(S<wbr />ESSIONID) FROM CONTROL.dbo.tblProgressHx,<wbr />0))<br />
<br />
PRINT @sessionID<br />
<br />
<br />
thanks!
</div>
</div>


hello: i'm trying to get the right syntax for...

DECLARE @sessionId int

SELECT @sessionId = 1 + CONVERT(float,ISNULL(MAX(SESSIONID) FROM CONTROL.dbo.tblProgressHx,0))

PRINT @sessionID


thanks!

isnull use in sql condition

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.