Click here to Skip to main content
15,919,567 members

Comments by jitendraintarvo (Top 3 by date)

jitendraintarvo 5-Jan-17 3:18am View    
let me explain you again I have a table named customerdetails here I have to provide a unique id to every individual customer and one more unique id I have to provide to customer on basis of departmentname. Every user registered with registration no and also with departmentid like I have more than 20 department I am giving you the example like dept1, dept2, dept3, dept4.
jitendraintarvo 4-Jan-17 1:52am View    
thanks for giving me reply but without departmntname how will i get unique id for every deprtment. there are more than 20 diff-diff department. on basis of departmentname deptid should be generated. plz help with that.
thank
jitendraintarvo 4-Jan-17 1:49am View    
thanks for giving me best idea but these example gives only one id in return but I want two Id in return first for id column and second for deptid column. plz help me with that.