Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
How to dynamic increment Batch ID in sql server with cursor
Nirmal KumarC
Sep 18 2014 10:28 AM
1.1k
Reply
I want How to weekly wise one time all batches as Batch id dynamic increment using Sql server with cursor example below.
Batches Example:
Batches:
PSF/180
ERS/B366
ARPA/B146
EFA/B989
PSSR/B1096
RECP/B175
CHEMCO/B73
ERS/B367
So this All Batch id Dynamically get this result in below
I want
ARPA/B146
get data to database
After Split the
ARPA/B
separate
146
146 Value Dynamic Increment 147
after this value
ARPA/B147
insert Batchid
to database
this result
another one Example:
PSSR/B1096
this id dynamically create
PSSR/B1097
Thanks
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How to Split String in sqlserver?
How many Unique & Primary Key's in a table