sql server - How to create hierarchical table in SQL? -

-

if there 3 managers , employees shown in photo, how design hierarchical in sql.

enter image description here

i add managerid field not required.

if field not set person 1 of highest managers else works employee person specific id.


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

c# - ItextSharp font color issue in ver 5.5.4+ -

-
Image
i have code creates red "stamp" using red font color: string stampdate = datetime.now.tostring("mm/dd/yyyy"); string fontpath = server.mappath("/assets/fonts"); string origfile = server.mappath("/test.pdf"); const int opacitypercent = 80; const float pdfpaidfontsize = 28; const float pdfcopyx = 170; const float pdfpaidx = 385; const float pdfy = 20; const float pdfdatexoffset = 7; const float pdfdateyoffset = 12; const float pdfdatefontsize = 10; const string paidstamptxt = "paid"; const string copystamptxt = "copy"; const string arialfilename = "arialbd.ttf"; pdfstamper stamper = null; pdfreader reader = null; pdfreader.unethicalreading = true; memorystream streampdf; try { reader = new pdfreader(origfile); streampdf = new memorystream(); stamper = new pdfstamper(reader, streampdf); (int = 1; <= r...
Read more

ios - retrievePeripherals deprecated in IOS7 how to substitude it with retrievePeripheralsWithIdentifiers -

-
i using "[self.manager retrieveperipherals:[nsarray arraywithobject:(id)aperipheral.uuid]];” works fine deprecated in ios7. found have use “ retrieveperipheralswithidentifiers ” instead. can not figure out right syntax new function. can please translate "[self.manager retrieveperipherals:[nsarray arraywithobject:(id)aperipheral.uuid]];” to new function “retrieveperipheralswithidentifiers”. // invoked when central discovers heart rate peripheral while scanning. - (void) centralmanager:(cbcentralmanager *)central diddiscoverperipheral:(cbperipheral *)aperipheral advertisementdata:(nsdictionary *)advertisementdata rssi:(nsnumber *)rssi { nsmutablearray *peripherals = [self mutablearrayvalueforkey:@"heartratemonitors"]; if(![self.heartratemonitors containsobject:aperipheral]) [peripherals addobject:aperipheral]; // retrieve known devices [self.manager retrieveperipherals:[nsarray arraywithobject:(id)aperipheral.uuid]]; } ...
Read more