<div>
Hi campbel8,<br />
<br />
change the datatype from int to long in the table<br />

</div>


Hi campbel8,

change the datatype from int to long in the table


<div>
the fields acc_id and paraccountid need to be of data type bigint, and not int
</div>


the fields acc_id and paraccountid need to be of data type bigint, and not int

<div>
sorry i meant:<br />
<br />
Hi Mehram,<br />
<br />
change the datatype from int to long in the table<br />
<br />
:o)
</div>


sorry i meant:

Hi Mehram,

change the datatype from int to long in the table

:o)

<div>
Sir the acc_id and paraccountid both are varchar (100)
</div>


Sir the acc_id and paraccountid both are varchar (100)

<div>
Try this query....<br />
<br />
If its a varchar field, you have to convert it to a numeric field<br />
<br />
We can make use of CONVERT funtion or CAST function for this purpose...<br />
<br />
Convert(data type,field name)<br />
Cast (field name as data type)<br />
<br />
select MAI=max(convert(numeric,ac<wbr />c_id))+1, x.Paraccountid from <br />
(select acc_id, paraccountid, title from AC_CHARTOFACC where paraccountid ='1002001001') x <br />
group by x.paraccountid
</div>


Try this query....

If its a varchar field, you have to convert it to a numeric field

We can make use of CONVERT funtion or CAST function for this purpose...

Convert(data type,field name)
Cast (field name as data type)

select MAI=max(convert(numeric,acc_id))+1, x.Paraccountid from
(select acc_id, paraccountid, title from AC_CHARTOFACC where paraccountid ='1002001001') x
group by x.paraccountid

<div>
<div class="content wysiwyg-content">
Sir, I am using below statement and it is showing error following:<br />
<br />
select MAI=max(acc_id)+1, x.Paraccountid from <br />
(select acc_id, paraccountid, title from AC_CHARTOFACC where paraccountid ='1002001001')x <br />
group by x.paraccountid<br />
<br />
<br />
Error:<br />
Server: Msg 248, Level 16, State 1, Line 1<br />
The conversion of the varchar value '1002001001001' overflowed an int column. Maximum integer value exceeded.<br />
<br />
Please help how to resolve this problem.<br />
<br />
Rgds.<br />
Mehram<br />

</div>
</div>


Sir, I am using below statement and it is showing error following:

select MAI=max(acc_id)+1, x.Paraccountid from 
(select acc_id, paraccountid, title from AC_CHARTOFACC where paraccountid ='1002001001')x 
group by x.paraccountid


Error:
Server: Msg 248, Level 16, State 1, Line 1
The conversion of the varchar value '1002001001001' overflowed an int column. Maximum integer value exceeded.

Please help how to resolve this problem.

Rgds.
Mehram


MS SQL max id

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.