Our Training Programs

All contents are copyright of their authors.

Sql Increment Issue

Sql Increment Issue

Thulasiram pakala

7yAsked May 8, 2019, 2:18 AM814

hi i want to increment sr no like

INI/DE/2019-20/kah10990/1

INI/DE/2019-20/kah10990/2

in this i pass INI/DE/2019-20/kah10990/ this values code side

i am using this query its work

Select isnull(max(substring(uid,24,len(uid)-23)),0)+1 as Uid from tblinstinward where emlyear='2019-20' and instid='kah1099'

but sometimes this institute id len will be changed (kah10990) like (kah10990012) like

INI/DE/2019-20/kah1099011/1 like this so in this type of insert time this query is not working

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Gajendra Jangid7y ago
use following query
Select RIGHT(uid, CHARINDEX('/',REVERSE(uid))-1)+1 as Uid from tblinstinward where emlyear='2019-20' and instid='kah1099'
Thulasiram pakala7y ago
each institute i want display 1 onword increment no only

like 1 st institute iNI/2019-20/INS001/1
iNI/2019-20/INS001/2

2 nd institute also INI/2019-20/INS002/1
2 nd institute also INI/2019-20/INS002/2 like this type of increment
Piyush Pansuriya7y ago
Hi,
You can use count() for the last increment number.
If there is five row inserted it will return 5 . you need to add +1 in count().