Populate fields where CSV Sting has data matching given Column name
-
- Given multiple ROWs comprised of varying combinations of Comma delineated values and an ID.
- Given a TABLE whose COLUMNS names are a comprehensive compilation of the (SPERATED/PARCSED) delineated values existing between all ROWs.
- Populate the given TABLE by looping through the COLUMN names and PARCING a given ROW for a delineated value that MATCHES a given COLUMN name.
- The resulting table would display the same number of ROWS with a BINARY identifier in a given column where the parsed row value matched the column name.
-
Can you provide DDL (ie CREATE TABLE commands) for the source and target tables, please?
Can you also provide INSERT statements which will populate your source table with the sample data provided?
Someone here will take it from there, I'm sure.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
-
This is what I am using to create the PIVOT table which has every possible User or Group that exists in the CSV columns. I also added a Column for SecCode and Description which would be used to put the SecCode containing the CSV data (The current Keys for the given rows). This statement is only used to create the table with columns. (It has one row with "1" as a value for all the fields).
USE EpicorViews
DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX)
select @cols = STUFF((SELECT ',' + QUOTENAME(UGCode)
from EpicorViews.dbo.SecUGCode
group by UGCode
order by UGCode
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,1,'')
set @query = N'SELECT ' + @cols + N' INTO EpicorViews.DBO.SecColumns from
(
select UGCode
from EpicorViews.dbo.SecUGCode
) x
pivot
(
count(UGCode)
for UGCode in (' + @cols + N')
) p '
exec sp_executesql @query; -
OK, but no one outside of your company can run that. The reason for my specific request was so that anyone can paste the CREATE TABLE / INSERT commands into their own SSMS instance and execute it.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
-
Here is an example of a post which does what I am asking, for info:
https://www.sqlservercentral.com/forums/topic/sum-2-column-by-group
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
-
This was removed by the editor as SPAM
-
Thanks...One more try.
I added the create tables. I am using views for SecurityUsers but I do have a table for SecColumns
Thanks...One more try.
I added the create tables. I am using views for SecurityUsers but I do have a table for SecColumns
Given Table "SecurityUsers" containing SecCode, Description, Users (Users column is a String with every User/Group separated by a Comma)
Given Empty Table "SecColumns" where every User/Group that exists in the Users Column in "SecurityUsers" Table is now an INT Columns . In addition SecCode and Description are Columns as NVARCAR.
Insert Into "SecColumns" the SecCode and Description from every row in SecurityUsers
Loop through the CSV Users Column in SecurityUsers. Take the User/Group as the name exists between the Commas and loop through the Column names in SecColumns adding a 1 in the column where the User exists in SecurityUsers
CREATE TABLE SecurityUsers (
SecCode nvarchar(70) NOT NULL,
Description nvarchar(100) NOT NULL,
Users nvarchar(max) NULL
);
INSERT INTO SerurityUsers (SecCode, Description, Users)
VALUES (SEC441,A/P 1099 Processing,SDF\,ACG\,AP2\,CRA\,ACCT-APSUPV\,MIS\,SBL\,abronk\,bboamah\,btgyurik\,ConversionAdmin\,ConversionUser\,ixmontalvo\,dedison\,gherrick\,mmgaritta\,tcallahan\,tburke\,namatruda\,mrcalderon\,btgyurik\,aemartinez\,ConversionAdmin\,ConversionUser\,gherrick\,mmgaritta\,tbmcsweeney\,tmcnabola\,wpduby\,wbrown\,skamick\,btgyurik\,bboamah\,bcpaterson\,aemartinez\,abronk\,ConversionAdmin\,cjduksa\,cnielsen\,ConversionUser\,dcolson\,gherrick\,mmgaritta\,kggreen\,jwbarrett\,gherrick\,mdriggs\,jword\,jxmartir\,kberger\,jsepelak\,jniedziela\,btgyurik\,cdmurphy\,aemartinez\,ConversionUser\,dblair\,ConversionAdmin\,tpstrobel\,mmgaritta\,rcrasilli\,mmgaritta\,gherrick\,dpeters\,ConversionAdmin\,ConversionUser\,btgyurik\,bcpaterson\,tcallahan\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,ConversionAdmin\,ConversionUser\,btgyurik\,aletniowski\,gherrick\,efernald\,manowak\,mmgaritta\,nmoriello\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta),
(SEC44180,FIFO Stock Movement DE,*),
(SEC44181,Part FIFO Transaction History Tracker DE,*),
(SEC442,Requisition Entry,MCA\,MSG\,SEC\,CFO\,MMG\,SDF\,MM\,LGL\,SCA\,SMG\,LESR\,QA\,INN\,ACG\,CTE\,DMP\,SFM\,QMG\,ISS\,CSA\,EXEC\,SFI\,DPM\,PAC\,CSG\,GCVP\,SHMG\,ACCM\,SCG\,SAE\,CAM\,MSVP\,AP2\,CSS\,PUR-BUYERS\,MMP\,RcvSpvsr\,DGMP\,HDA\,PSA\,ASG\,CSR\,COO\,CRA\,SQE\,VPQ\,HRM\,ISC\,LME\,ACCT-AR\,REQ\,CACG\,MSA\,DOQ\,DME\,PEM\,DEM\,MIE\,NPD\,SF-SUPV\,RAD\,VPO\,ACCT-APCLERK\,ISM\,MGMP\,ACCT-APSUPV\,PUR-MGR\,MIS\,ESG\,DIS\,IEG\,SSG\,QMA\,RIM\,TDM\,SBL\,AP3\,mxlamanna\,MME\,ME-ENG\,asedberry\,bsauer\,btgyurik\,ConversionAdmin\,ConversionUser\,gherrick\,jvradziwon\,mmgaritta\,mnaumec\,mrcalderon\,namatruda\,nmoriello\,tburke\,tcallahan\,mmgaritta\,gherrick\,efernald\,dedison\,ixmontalvo\,ConversionUser\,ConversionAdmin\,btgyurik\,bboamah\,aletniowski\,abronk\,aemartinez\,abronk\,bboamah\,btgyurik\,ConversionAdmin\,ConversionUser\,ixmontalvo\,dedison\,gherrick\,mmgaritta\,tcallahan\,tburke\,namatruda\,mrcalderon\,mrcalderon\,namatruda\,mmgaritta\,gherrick\,ConversionUser\,ConversionAdmin\,btgyurik\,btgyurik\,aemartinez\,ConversionAdmin\,ConversionUser\,gherrick\,mmgaritta\,mmgaritta\,gherrick\,ConversionUser\,ConversionAdmin\,axlokteva\,btgyurik\,namatruda\,mrcalderon\,tbmcsweeney\,tmcnabola\,wpduby\,wbrown\,skamick\,btgyurik\,bboamah\,bcpaterson\,aemartinez\,abronk\,ConversionAdmin\,cjduksa\,cnielsen\,ConversionUser\,dcolson\,gherrick\,mmgaritta\,kggreen\,jwbarrett\,lhandberry\,mailroom\,ixmontalvo\,gherrick\,btgyurik\,rlsegal\,namatruda\,mmgaritta\,gherrick\,mdriggs\,jword\,jxmartir\,kberger\,jsepelak\,jniedziela\,btgyurik\,cdmurphy\,aemartinez\,ConversionUser\,dblair\,ConversionAdmin\,tpstrobel\,mmgaritta\,rcrasilli\,mlnewton\,mmgaritta\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,mmgaritta\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,bboamah\,abronk\,aemartinez\,wbrown\,wpduby\,tbmcsweeney\,tmcnabola\,skamick\,btgyurik\,ConversionUser\,dcolson\,ConversionAdmin\,cnielsen\,cjduksa\,gherrick\,mmgaritta\,jwbarrett\,jekubish\,mmgaritta\,gherrick\,cnielsen\,ConversionAdmin\,dcolson\,ConversionUser\,btgyurik\,tbmcsweeney\,rmassingue\,mnaumec\,rcrasilli\,rapereira\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,jxmartir\,jekubish\,jniedziela\,jvradziwon\,mmgaritta\,gherrick\,dpeters\,ConversionAdmin\,ConversionUser\,btgyurik\,bcpaterson\,tcallahan\,tjlooney\,pcbeekley\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,mmgaritta\,mharty\,khgriffin\,kpcarlson\,jhernandez\,EEaston\,gherrick\,btgyurik\,cjohnson\,ConversionAdmin\,ConversionUser\,recall01\,recall03\,recall02\,mpersaud\,tarcadipani\,recall04\,recall06\,recall08\,recallreprint\,recall08\,recall06\,ConversionUser\,ConversionAdmin\,btgyurik\,gherrick\,kpcarlson\,khgriffin\,mmgaritta\,jbergeron\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,rapereira\,mmgaritta\,mmgaritta\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mmgaritta\,sbarnhart\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,gherrick\,mmgaritta\,btgyurik\,betannone\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,jmbaldini\,jtreglia\,gherrick\,mmgaritta\,mmgaritta\,tjlooney\,gherrick\,mchristman\,btgyurik\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mmgaritta\,gherrick\,btgyurik\,ConversionAdmin\,ConversionUser\,mmgaritta\,sbartis\,gherrick\,dmsilvers\,btgyurik\,bjohnson\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,dcamera\,btgyurik\,gherrick\,mbarton\,jreddington\,skappel\,zcyr\,mmgaritta\,mruffino\,pomichinski\,mmgaritta\,gherrick\,ejtalasco\,dmcdaniel\,ikolev\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,alcole\,gherrick\,jniedziela\,mmgaritta\,mmgaritta\,mwiddowson\,yelzein\,tjsullivan\,jheider\,jekubish\,mdixon\,gherrick\,dgrier\,btgyurik\,cfresher\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,mmgaritta\,rrose\,gherrick\,jrballard\,bbermani\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,dspencer\,mmgaritta\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,mmgaritta\,jekubish\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,ddsenchuk\,dmcdaniel\,mmgaritta\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,ddemoss\,midrees\,mmgaritta\,tclemens\,mmgaritta\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,psspitale\,rchurchill\,mmgaritta\,tarcadipani\,skmiec\,rnadolnysipes\,rjjandreau\,recall06\,gherrick\,ebard\,mharty\,jxfederkiew\,jwbarrett\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,abanos\,mmgaritta\,recall02\,recall03\,recall01\,mpersaud\,pcbeekley\,recallreprint\,rhbelcourt\,recall08\,recall04\,recall06\,rlsegal\,rmmiles\,skos\,ssbrady\,tarcadipani\,tarcadapani\,tjlooney\,gherrick\,EEaston\,dropes\,ehysenllari\,jsgueglia\,jtreglia\,jekubish\,jhernandez\,jmillion\,jmbaldini\,karoyce\,khgriffin\,kxmroczka\,lhandberry\,kpcarlson\,mharty\,ConversionAdmin\,cjohnson\,cnielsen\,ConversionUser\,btgyurik\,ajlopes\,asedberry\,bsauer\,mmgaritta\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,mmgaritta\,jrozzi\,gherrick\,axdaigle\,btgyurik\,ConversionUser\,ConversionAdmin\,btgyurik\,gherrick\,dxveilleux\,mmgaritta\,ajlopes\,btgyurik\,ConversionAdmin\,ConversionUser\,khgriffin\,mharty\,gherrick\,tarcadapani\,tarcadipani\,recall08\,recall04\,recall06\,recall02\,recall03\,recall01\,rbmartinez\,mpersaud\,mmgaritta\,mnaumec\,mmgaritta\,rchurchill\,pwelch\,nauszura\,rnadolnysipes\,sbartis\,recall06\,skmiec\,skos\,wpduby\,gherrick\,dropes\,ebard\,dlockery\,ehysenllari\,ezahradnik\,karoyce\,khgriffin\,kpcarlson\,jvradziwon\,jwbarrett\,cjduksa\,bvincent\,btgyurik\,bboamah\,abronk\,abanos\,ConversionAdmin\,ConversionUser\,ConversionUser\,ConversionAdmin\,btgyurik\,kpcarlson\,dlockery\,gherrick\,rmmiles\,mmgaritta\,mmgaritta\,gherrick\,btgyurik\,ConversionAdmin\,ConversionUser\,ConversionUser\,ConversionAdmin\,cjparlato\,btgyurik\,abajguz\,bbermani\,gherrick\,jamassey\,ksika\,mchristman\,jrballard\,jsgueglia\,mmgaritta\,rrose\,tvanflatern\,tbmcsweeney\,mmgaritta\,jsgueglia\,mchristman\,gherrick\,abajguz\,btgyurik\,cjparlato\,ConversionAdmin\,ConversionUser\,ConversionUser\,ConversionAdmin\,btgyurik\,gherrick\,khgriffin\,mmgaritta\,rweil\,mmgaritta\,MGARITTA\,gherrick\,btgyurik\,ConversionAdmin\,ConversionUser\,ConversionUser\,ConversionAdmin\,btgyurik\,abajguz\,gherrick\,mchristman\,mailroom\,jekubish\,mmgaritta\,psspitale\,msredl\,sjmiller\,tpstrobel\,mmgaritta\,jsepelak\,mdriggs\,kberger\,jword\,gherrick\,btgyurik\,cdmurphy\,ConversionAdmin\,ConversionUser\,dblair\,btgyurik\,asedberry\,bsauer\,ConversionUser\,ConversionAdmin\,gherrick\,dcscott\,kxmroczka\,jmillion\,ssimonow\,recall06\,mmgaritta\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,dajadovich\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,aletniowski\,gherrick\,efernald\,manowak\,mmgaritta\,nmoriello\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,cjohnson\,ConversionUser\,dcgreen\,btgyurik\,bbermani\,bboamah\,abronk\,gherrick\,EEaston\,khgriffin\,jhernandez\,jmbaldini\,jtreglia\,jrballard\,mmgaritta\,mpersaud\,recall02\,recall03\,recall01\,recall08\,recallreprint\,rhbelcourt\,recall06\,recall04\,rrose\,ssbrady\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,btgyurik\,asedberry\,bsauer\,ConversionUser\,cjohnson\,ConversionAdmin\,jhernandez\,grmcall\,gherrick\,EEaston\,mmgaritta\,mmgaritta\,recall06\,dezajac\,gherrick\,ConversionUser\,ConversionAdmin\,bsauer\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,mmgaritta\,mnaumec\,ssbrady\,gherrick\,jvradziwon\,kpcarlson\,ConversionAdmin\,ConversionUser\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,kpcarlson\,gherrick\,mmgaritta\,mmgaritta\,msmorgan\,nauszura\,pxgoudarzy\,rchurchill\,skmiec\,recall06\,rnadolnysipes\,rxanderson\,gherrick\,javedisian\,ebard\,dmaclary\,kpcarlson\,mhinckley\,jwbarrett\,ConversionAdmin\,ConversionUser\,dalberding\,btgyurik\,bvincent\,cjduksa\,aamouta\,abanos\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mmgaritta\,gherrick\,krlangevin\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,rhbelcourt\,tvanflatern\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin),
(SEC443,Requisition Tracker,MCA\,MSG\,SEC\,CFO\,MMG\,SDF\,MM\,LGL\,SCA\,SMG\,LESR\,QA\,INN\,ACG\,TRKRS\,DMP\,SFM\,QMG\,ISS\,CSA\,SFI\,DPM\,PAC\,CSG\,GCVP\,SHMG\,ACCM\,SAE\,CAM\,RAD\,CSS\,PUR-BUYERS\,MMP\,DGMP\,HDA\,DOQ\,ASG\,CSR\,COO\,CRA\,SQE\,VPQ\,HRM\,ISC\,LME\,ACCT-AR\,REQ\,RIM\,CACG\,MSA\,DME\,PEM\,DEM\,MIE\,MAINT-UNION\,PMS\,NPD\,SF-SUPV\,VPO\,dboratko\,ISM\,MGMP\,ACCT-APSUPV\,PUR-MGR\,MIS\,ESG\,DIS\,IEG\,SSG\,ACCT-APCLERK\,SBL\,mxlamanna\,FCG\,MME\,ME-ENG\,asedberry\,bsauer\,btgyurik\,ConversionAdmin\,ConversionUser\,gherrick\,jvradziwon\,mmgaritta\,mnaumec\,mrcalderon\,namatruda\,nmoriello\,tburke\,tcallahan\,mmgaritta\,gherrick\,efernald\,dedison\,ixmontalvo\,ConversionUser\,ConversionAdmin\,btgyurik\,bboamah\,aletniowski\,abronk\,aemartinez\,btgyurik\,aemartinez\,ConversionAdmin\,ConversionUser\,gherrick\,mmgaritta\,mmgaritta\,gherrick\,ConversionUser\,ConversionAdmin\,axlokteva\,btgyurik\,namatruda\,mrcalderon\,tbmcsweeney\,tmcnabola\,wpduby\,wbrown\,skamick\,btgyurik\,bboamah\,bcpaterson\,aemartinez\,abronk\,ConversionAdmin\,cjduksa\,cnielsen\,ConversionUser\,dcolson\,gherrick\,mmgaritta\,kggreen\,jwbarrett\,lhandberry\,mailroom\,ixmontalvo\,gherrick\,btgyurik\,rlsegal\,namatruda\,mmgaritta\,gherrick\,mdriggs\,jword\,jxmartir\,kberger\,jsepelak\,jniedziela\,btgyurik\,cdmurphy\,aemartinez\,ConversionUser\,dblair\,ConversionAdmin\,tpstrobel\,mmgaritta\,rcrasilli\,mlnewton\,mmgaritta\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,wpduby\,tbmcsweeney\,tmcnabola\,skamick\,btgyurik\,ConversionUser\,dcolson\,ConversionAdmin\,cnielsen\,cjduksa\,gherrick\,mmgaritta\,jwbarrett\,jekubish\,mmgaritta\,gherrick\,cnielsen\,ConversionAdmin\,dcolson\,ConversionUser\,btgyurik\,tbmcsweeney\,rmassingue\,mnaumec\,rcrasilli\,rapereira\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,jxmartir\,jekubish\,jniedziela\,jvradziwon\,mmgaritta\,gherrick\,dpeters\,ConversionAdmin\,ConversionUser\,btgyurik\,bcpaterson\,tcallahan\,tjlooney\,pcbeekley\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,mmgaritta\,mharty\,khgriffin\,kpcarlson\,jhernandez\,EEaston\,gherrick\,btgyurik\,cjohnson\,ConversionAdmin\,ConversionUser\,recall01\,recall03\,recall02\,mpersaud\,tarcadipani\,recall04\,recall06\,recall08\,recallreprint\,recall08\,recall06\,ConversionUser\,ConversionAdmin\,btgyurik\,gherrick\,kpcarlson\,khgriffin\,mmgaritta\,jbergeron\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,rapereira\,mmgaritta\,mmgaritta\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mmgaritta\,sbarnhart\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,gherrick\,mmgaritta\,btgyurik\,betannone\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,jmbaldini\,jtreglia\,gherrick\,mmgaritta\,mmgaritta\,tjlooney\,gherrick\,mchristman\,btgyurik\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionUser\,dcolson\,ConversionAdmin\,cjohnson\,caplumadore\,btgyurik\,gherrick\,EEaston\,MGARITTA\,jhernandez\,mmgaritta\,mpersaud\,rbmartinez\,rchurchill\,ConversionUser\,ConversionAdmin\,cjohnson\,btgyurik\,caplumadore\,gherrick\,EEaston\,jhernandez\,mmgaritta\,mpersaud\,rchurchill\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mmgaritta\,gherrick\,btgyurik\,ConversionAdmin\,ConversionUser\,mmgaritta\,sbartis\,gherrick\,dmsilvers\,btgyurik\,bjohnson\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,dcamera\,btgyurik\,gherrick\,mbarton\,jreddington\,skappel\,zcyr\,mmgaritta\,mruffino\,pomichinski\,mmgaritta\,gherrick\,ejtalasco\,dmcdaniel\,ikolev\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,alcole\,gherrick\,jniedziela\,mmgaritta\,mmgaritta\,mwiddowson\,yelzein\,tjsullivan\,jheider\,jekubish\,mdixon\,gherrick\,dgrier\,btgyurik\,cfresher\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,mmgaritta\,rrose\,gherrick\,jrballard\,bbermani\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,dspencer\,mmgaritta\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,mmgaritta\,jekubish\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,ddsenchuk\,dmcdaniel\,mmgaritta\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,ddemoss\,midrees\,mmgaritta\,tclemens\,mmgaritta\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,rchurchill\,mmgaritta\,tarcadipani\,skmiec\,rnadolnysipes\,rjjandreau\,recall06\,gherrick\,ebard\,mharty\,jxfederkiew\,jwbarrett\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,abanos\,mmgaritta\,recall02\,recall03\,recall01\,mpersaud\,pcbeekley\,recallreprint\,rhbelcourt\,recall08\,recall04\,recall06\,rlsegal\,rmmiles\,skos\,ssbrady\,tarcadipani\,tarcadapani\,tjlooney\,gherrick\,EEaston\,dropes\,ehysenllari\,jsgueglia\,jtreglia\,jekubish\,jhernandez\,jmillion\,jmbaldini\,karoyce\,khgriffin\,kxmroczka\,lhandberry\,kpcarlson\,mharty\,ConversionAdmin\,cjohnson\,cnielsen\,ConversionUser\,btgyurik\,ajlopes\,asedberry\,bsauer\,mmgaritta\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,mmgaritta\,jrozzi\,gherrick\,axdaigle\,btgyurik\,ConversionUser\,ConversionAdmin\,btgyurik\,gherrick\,dxveilleux\,mmgaritta\,btgyurik\,ConversionUser\,ConversionAdmin\,jvradziwon\,jwbarrett\,gherrick\,recall06\,rchurchill\,msredl\,mnaumec\,mmgaritta\,mnaumec\,mmgaritta\,rchurchill\,pwelch\,nauszura\,rnadolnysipes\,sbartis\,recall06\,skmiec\,skos\,wpduby\,gherrick\,dropes\,ebard\,dlockery\,ehysenllari\,ezahradnik\,karoyce\,khgriffin\,kpcarlson\,jvradziwon\,jwbarrett\,cjduksa\,bvincent\,btgyurik\,bboamah\,abronk\,abanos\,ConversionAdmin\,ConversionUser\,ConversionUser\,ConversionAdmin\,btgyurik\,kpcarlson\,dlockery\,gherrick\,rmmiles\,mmgaritta\,ConversionUser\,ConversionAdmin\,cjparlato\,btgyurik\,abajguz\,bbermani\,gherrick\,jamassey\,ksika\,mchristman\,jrballard\,jsgueglia\,mmgaritta\,rrose\,tvanflatern\,tbmcsweeney\,mmgaritta\,jsgueglia\,mchristman\,gherrick\,abajguz\,btgyurik\,cjparlato\,ConversionAdmin\,ConversionUser\,ConversionUser\,ConversionAdmin\,btgyurik\,gherrick\,khgriffin\,mmgaritta\,rweil\,ConversionUser\,ConversionAdmin\,btgyurik\,abajguz\,gherrick\,mchristman\,mailroom\,jekubish\,mmgaritta\,psspitale\,msredl\,sjmiller\,tpstrobel\,mmgaritta\,jsepelak\,mdriggs\,kberger\,jword\,gherrick\,btgyurik\,cdmurphy\,ConversionAdmin\,ConversionUser\,dblair\,btgyurik\,asedberry\,bsauer\,ConversionUser\,ConversionAdmin\,gherrick\,dcscott\,kxmroczka\,jmillion\,ssimonow\,recall06\,mmgaritta\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,dajadovich\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,aletniowski\,gherrick\,efernald\,manowak\,mmgaritta\,nmoriello\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,cjohnson\,ConversionUser\,dcgreen\,btgyurik\,bbermani\,bboamah\,abronk\,gherrick\,EEaston\,khgriffin\,jhernandez\,jmbaldini\,jtreglia\,jrballard\,mmgaritta\,mpersaud\,recall02\,recall03\,recall01\,recall08\,recallreprint\,rhbelcourt\,recall06\,recall04\,rrose\,ssbrady\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,mmgaritta\,recall06\,dezajac\,gherrick\,ConversionUser\,ConversionAdmin\,bsauer\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,mmgaritta\,mnaumec\,ssbrady\,gherrick\,jvradziwon\,kpcarlson\,ConversionAdmin\,ConversionUser\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,kpcarlson\,gherrick\,mmgaritta\,mmgaritta\,msmorgan\,nauszura\,pxgoudarzy\,rchurchill\,skmiec\,recall06\,rnadolnysipes\,rxanderson\,gherrick\,javedisian\,ebard\,dmaclary\,kpcarlson\,mhinckley\,jwbarrett\,ConversionAdmin\,ConversionUser\,dalberding\,btgyurik\,bvincent\,cjduksa\,aamouta\,abanos\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,ConversionAdmin\,cjparlato\,cnielsen\,cjohnson\,ConversionUser\,dalberding\,cscott\,dcamera\,dblair\,dcgreen\,dcolson\,btgyurik\,bvincent\,cbreuler\,caplumadore\,cdmurphy\,cfresher\,cjduksa\,betannone\,bsauer\,bcpaterson\,aletniowski\,asedberry\,alcole\,bboamah\,axlokteva\,bbermani\,axdaigle\,abronk\,ajlopes\,aemartinez\,aamouta\,abajguz\,abanos\,gherrick\,ikolev\,jamassey\,javedisian\,gxkuczynko\,inventory\,ixmontalvo\,dspencer\,dxveilleux\,dropes\,dpeters\,dmaclary\,dmcdaniel\,ebard\,EEaston\,dgrier\,dedison\,dlockery\,dcscott\,ddemoss\,ddsenchuk\,dezajac\,ejtalasco\,ezahradnik\,ehysenllari\,efernald\,lxguadalupe\,manowak\,mbarton\,mchristman\,mdixon\,mdriggs\,midrees\,mharty\,mhinckley\,mlnewton\,karoyce\,kberger\,khgriffin\,jword\,jxfederkiew\,jxmartir\,lhandberry\,krlangevin\,ksika\,kxmroczka\,kggreen\,kpcarlson\,jniedziela\,jmillion\,jmbaldini\,jekubish\,jbergeron\,jheider\,jgsantos\,jhernandez\,jtreglia\,jtavares\,jsgueglia\,jsepelak\,jrozzi\,jreddington\,jrballard\,jvradziwon\,jwbarrett\,mmgaritta\,mnaumec\,rcrasilli\,recall01\,recall03\,recall02\,ragnello\,pxgoudarzy\,pwelch\,psspitale\,pomichinski\,rapereira\,rbmartinez\,rchurchill\,mpersaud\,msmorgan\,msredl\,mruffino\,mrcalderon\,mwiddowson\,pcbeekley\,nmoriello\,nauszura\,rmmiles\,rnadolnysipes\,rrose\,rlsegal\,rmassingue\,rjjandreau\,rehollender\,skappel\,sjmiller\,sinventory\,skamick\,sbarnhart\,rxanderson\,rweil\,recall04\,rhbelcourt\,recallreprint\,recallpack\,recall08\,recall06\,ssbrady\,skos\,skmiec\,ssimonow\,tarcadapani\,tclemens\,tmcnabola\,tarcadipani\,tburke\,tcallahan\,yelzein\,wbrown\,wpduby\,tvanflatern\,tpstrobel\,tjlooney\,tjsullivan\,zcyr\,mmgaritta\,gherrick\,krlangevin\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,rhbelcourt\,tvanflatern\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin),
(SEC443-001,Memo Maintenance,*),
(SEC444,Requisition Actions,MIS\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT),
(SEC445,MRP and MPS,MCA\,PUR-BUYERS\,ProcessMRP\,MCA2\,FSA\,MMP\,COO\,DMP\,DME\,PM-SG\,PM-RC\,MIS\,SBL\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mmgaritta\,sbarnhart\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,gherrick\,flash\,btgyurik\,ConversionAdmin\,ConversionUser\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,rchurchill\,mmgaritta\,tarcadipani\,skmiec\,rnadolnysipes\,rjjandreau\,recall06\,gherrick\,ebard\,mharty\,jxfederkiew\,jwbarrett\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,abanos\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mnaumec\,mmgaritta\,rchurchill\,pwelch\,nauszura\,rnadolnysipes\,sbartis\,recall06\,skmiec\,skos\,wpduby\,gherrick\,dropes\,ebard\,dlockery\,ehysenllari\,ezahradnik\,karoyce\,khgriffin\,kpcarlson\,jvradziwon\,jwbarrett\,cjduksa\,bvincent\,btgyurik\,bboamah\,abronk\,abanos\,ConversionAdmin\,ConversionUser\,mmgaritta\,jxfederkiew\,gherrick\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta),
(SEC446,File Maintenance,PUR-BUYERS\,PM-SG\,MIS\,SBL\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,mnaumec\,mmgaritta\,rchurchill\,pwelch\,nauszura\,rnadolnysipes\,sbartis\,recall06\,skmiec\,skos\,wpduby\,gherrick\,dropes\,ebard\,dlockery\,ehysenllari\,ezahradnik\,karoyce\,khgriffin\,kpcarlson\,jvradziwon\,jwbarrett\,cjduksa\,bvincent\,btgyurik\,bboamah\,abronk\,abanos\,ConversionAdmin\,ConversionUser\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta),
(SEC447,General Operations,MCA2\,FSA\,MMP\,COO\,DMP\,DME\,PM-SG\,PUR-MGR\,MIS\,SBL\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,gherrick\,btgyurik\,ConversionUser\,ConversionAdmin\,mmgaritta\,sbarnhart\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,mmgaritta\,gherrick\,flash\,btgyurik\,ConversionAdmin\,ConversionUser\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,rchurchill\,mmgaritta\,tarcadipani\,skmiec\,rnadolnysipes\,rjjandreau\,recall06\,gherrick\,ebard\,mharty\,jxfederkiew\,jwbarrett\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,abanos\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,ConversionUser\,ConversionAdmin\,btgyurik\,kpcarlson\,dlockery\,gherrick\,rmmiles\,mmgaritta\,mmgaritta\,jxfederkiew\,gherrick\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta),
(SEC447-001,MPS-Order Detail,MMP\,COO\,DMP\,MIS\,SBL\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta),
(SEC448,Reports,MCA\,PUR-BUYERS\,MMP\,COO\,DMP\,PM-RC\,PUR-MGR\,MIS\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,rchurchill\,mmgaritta\,tarcadipani\,skmiec\,rnadolnysipes\,rjjandreau\,recall06\,gherrick\,ebard\,mharty\,jxfederkiew\,jwbarrett\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,abanos\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,mnaumec\,mmgaritta\,rchurchill\,pwelch\,nauszura\,rnadolnysipes\,sbartis\,recall06\,skmiec\,skos\,wpduby\,gherrick\,dropes\,ebard\,dlockery\,ehysenllari\,ezahradnik\,karoyce\,khgriffin\,kpcarlson\,jvradziwon\,jwbarrett\,cjduksa\,bvincent\,btgyurik\,bboamah\,abronk\,abanos\,ConversionAdmin\,ConversionUser\,ConversionUser\,ConversionAdmin\,btgyurik\,kpcarlson\,dlockery\,gherrick\,rmmiles\,mmgaritta),
(SEC449,Forecast Entry,MCA2\,MMP\,COO\,DMP\,PUR-MGR\,MIS\,SBL\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,rchurchill\,mmgaritta\,tarcadipani\,skmiec\,rnadolnysipes\,rjjandreau\,recall06\,gherrick\,ebard\,mharty\,jxfederkiew\,jwbarrett\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,abanos\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,ConversionUser\,ConversionAdmin\,btgyurik\,kpcarlson\,dlockery\,gherrick\,rmmiles\,mmgaritta\,mmgaritta\,jxfederkiew\,gherrick\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta),
(SEC450,MPS Entry,MCA2\,MMP\,COO\,DMP\,PUR-MGR\,MIS\,SBL\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta\,skamick\,tmcnabola\,wpduby\,mmgaritta\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,gherrick\,ConversionAdmin\,ConversionUser\,btgyurik\,cjduksa\,abajguz\,gherrick\,gxkuczynko\,mchristman\,mmgaritta\,msmorgan\,tmcnabola\,wpduby\,skamick\,skamick\,wpduby\,tmcnabola\,msmorgan\,mmgaritta\,gherrick\,cjduksa\,btgyurik\,ConversionUser\,ConversionAdmin\,rchurchill\,mmgaritta\,tarcadipani\,skmiec\,rnadolnysipes\,rjjandreau\,recall06\,gherrick\,ebard\,mharty\,jxfederkiew\,jwbarrett\,ConversionAdmin\,cjduksa\,ConversionUser\,btgyurik\,abanos\,ConversionAdmin\,ColtEDI\,ConversionUser\,btgyurik\,BBerry\,gherrick\,Encompass\,epicadmin\,EpicorECC\,EpicorSRV\,ERPSVC\,DocStar\,MGARITTA\,MANAGER\,mjdepiano\,skulczyk\,tbmcsweeney\,REST\,sc\,SCAdmin\,rtcousens\,recalladmin\,mmgaritta\,MWillis\,PRINT\,ConversionUser\,ConversionAdmin\,btgyurik\,kpcarlson\,dlockery\,gherrick\,rmmiles\,mmgaritta\,mmgaritta\,jxfederkiew\,gherrick\,btgyurik\,btgyurik\,ConversionUser\,ConversionAdmin\,gherrick\,mmgaritta)
CREATE TABLE [dbo].[SecColumns](
[SecCode] [NVARCHAR] (70) NOT NULL,
[Description] [NVARCHAR] (100) NOT NULL,
[aamouta] [int] NULL,
[abajguz] [int] NULL,
[abanos] [int] NULL,
[abronk] [int] NULL,
[ACCM] [int] NULL,
[ACCT-APCLERK] [int] NULL,
[ACCT-APSUPV] [int] NULL,
[ACCT-AR] [int] NULL,
[ACG] [int] NULL,
[aemartinez] [int] NULL,
[ajlopes] [int] NULL,
[AKE] [int] NULL,
[alcole] [int] NULL,
[aletniowski] [int] NULL,
[AP2] [int] NULL,
[AP3] [int] NULL,
[APS] [int] NULL,
[asedberry] [int] NULL,
[ASG] [int] NULL,
[axdaigle] [int] NULL,
[axlokteva] [int] NULL,
[BAQ] [int] NULL,
[bbermani] [int] NULL,
[BBerry] [int] NULL,
[bboamah] [int] NULL,
[bcpaterson] [int] NULL,
[betannone] [int] NULL,
[BHA] [int] NULL,
[bjohnson] [int] NULL,
[bsauer] [int] NULL,
[btgyurik] [int] NULL,
[bvincent] [int] NULL,
[CACG] [int] NULL,
[CAM] [int] NULL,
[caplumadore] [int] NULL,
[cbreuler] [int] NULL,
[CCD] [int] NULL,
[ccepicor] [int] NULL,
[CCS] [int] NULL,
[cdmurphy] [int] NULL,
[CFO] [int] NULL,
[cfresher] [int] NULL,
[cjduksa] [int] NULL,
[cjohnson] [int] NULL,
[cjparlato] [int] NULL,
[CMA] [int] NULL,
[CMH] [int] NULL,
[CMHN] [int] NULL,
[cnielsen] [int] NULL,
[ColtEDI] [int] NULL,
[ConversionAdmin] [int] NULL,
[ConversionUser] [int] NULL,
[COO] [int] NULL,
[CRA] [int] NULL,
[CRM] [int] NULL,
[CSA] [int] NULL,
[cscott] [int] NULL,
[CSE] [int] NULL,
[CSG] [int] NULL,
[CSP] [int] NULL,
[CSR] [int] NULL,
[CSS] [int] NULL,
[CTE] [int] NULL,
[dajadovich] [int] NULL,
[dalberding] [int] NULL,
[Data Collection] [int] NULL,
[dblair] [int] NULL,
[dcamera] [int] NULL,
[dcgreen] [int] NULL,
[dcolson] [int] NULL,
[dcscott] [int] NULL,
[ddemoss] [int] NULL,
[ddsenchuk] [int] NULL,
[dedison] [int] NULL,
[DEM] [int] NULL,
[dezajac] [int] NULL,
[DGMP] [int] NULL,
[dgrier] [int] NULL,
[DIS] [int] NULL,
[dlockery] [int] NULL,
[dmaclary] [int] NULL,
[dmcdaniel] [int] NULL,
[DME] [int] NULL,
[DMP] [int] NULL,
[dmsilvers] [int] NULL,
[DocStar] [int] NULL,
[DOQ] [int] NULL,
[dpeters] [int] NULL,
[DPM] [int] NULL,
[dropes] [int] NULL,
[dspencer] [int] NULL,
[dxveilleux] [int] NULL,
[ebard] [int] NULL,
[EEaston] [int] NULL,
[efernald] [int] NULL,
[EfxAdmin] [int] NULL,
[EfxDeveloper] [int] NULL,
[EfxPowerDeveloper] [int] NULL,
[ehysenllari] [int] NULL,
[ejtalasco] [int] NULL,
[Encompass] [int] NULL,
[epicadmin] [int] NULL,
[EpicorECC] [int] NULL,
[EpicorHG] [int] NULL,
[EpicorMobileWarehouse] [int] NULL,
[EpicorSRV] [int] NULL,
[ERPSVC] [int] NULL,
[ESG] [int] NULL,
[EXEC] [int] NULL,
[ezahradnik] [int] NULL,
[FC] [int] NULL,
[FCC] [int] NULL,
[FCG] [int] NULL,
[fedex] [int] NULL,
[FFR] [int] NULL,
[FINEOM] [int] NULL,
[flash] [int] NULL,
[FSA] [int] NULL,
[FullAuto-Sales] [int] NULL,
[FUS] [int] NULL,
[FWB] [int] NULL,
[GCVP] [int] NULL,
[gherrick] [int] NULL,
[grmcall] [int] NULL,
[gxkuczynko] [int] NULL,
[HandHeld] [int] NULL,
[HDA] [int] NULL,
[HHPO] [int] NULL,
[HHS] [int] NULL,
[hhu01] [int] NULL,
[hhu02] [int] NULL,
[hhu03] [int] NULL,
[hhu04] [int] NULL,
[hhu05] [int] NULL,
[hhu06] [int] NULL,
[hhu07] [int] NULL,
[hhu08] [int] NULL,
[hhu09] [int] NULL,
[HRC1] [int] NULL,
[HRM] [int] NULL,
[IEG] [int] NULL,
[IJM] [int] NULL,
[ikolev] [int] NULL,
[INN] [int] NULL,
[inspdmr] [int] NULL,
[inventory] [int] NULL,
[ISC] [int] NULL,
[ISM] [int] NULL,
[ISS] [int] NULL,
[ITSNT] [int] NULL,
[ixmontalvo] [int] NULL,
[jamassey] [int] NULL,
[javedisian] [int] NULL,
[jbergeron] [int] NULL,
[JEGLD] [int] NULL,
[jekubish] [int] NULL,
[jgsantos] [int] NULL,
[jheider] [int] NULL,
[jhernandez] [int] NULL,
[jhpalmer] [int] NULL,
[jjbifolck] [int] NULL,
[jmbaldini] [int] NULL,
[jmillion] [int] NULL,
[jniedziela] [int] NULL,
[jrballard] [int] NULL,
[jreddington] [int] NULL,
[jrozzi] [int] NULL,
[JRP] [int] NULL,
[jsepelak] [int] NULL,
[jsgueglia] [int] NULL,
[jtavares] [int] NULL,
[jtreglia] [int] NULL,
[jvradziwon] [int] NULL,
[jwbarrett] [int] NULL,
[jword] [int] NULL,
[jxfederkiew] [int] NULL,
[jxmartir] [int] NULL,
[karoyce] [int] NULL,
[kberger] [int] NULL,
[KGE] [int] NULL,
[kggreen] [int] NULL,
[khgriffin] [int] NULL,
[kpcarlson] [int] NULL,
[krlangevin] [int] NULL,
[ksika] [int] NULL,
[kxmroczka] [int] NULL,
[LESR] [int] NULL,
[LGL] [int] NULL,
[lhandberry] [int] NULL,
[LicensePlate] [int] NULL,
[LME] [int] NULL,
[lxguadalupe] [int] NULL,
[MA] [int] NULL,
[mailroom] [int] NULL,
[MAINT-UNION] [int] NULL,
[MANAGER] [int] NULL,
[manowak] [int] NULL,
[mbarton] [int] NULL,
[MCA] [int] NULL,
[MCA2] [int] NULL,
[MCG] [int] NULL,
[mchristman] [int] NULL,
[mdixon] [int] NULL,
[mdriggs] [int] NULL,
[ME-ENG] [int] NULL,
[MES User] [int] NULL,
[MGARITTA] [int] NULL,
[MGMP] [int] NULL,
[mharty] [int] NULL,
[mhinckley] [int] NULL,
[midrees] [int] NULL,
[MIE] [int] NULL,
[milcrib] [int] NULL,
[MIS] [int] NULL,
[mjdepiano] [int] NULL,
[mlnewton] [int] NULL,
[MM] [int] NULL,
[MME] [int] NULL,
[MMG] [int] NULL,
[mmgaritta] [int] NULL,
[MMP] [int] NULL,
[MMPOE] [int] NULL,
[mnaumec] [int] NULL,
[MOE] [int] NULL,
[mpersaud] [int] NULL,
[mrcalderon] [int] NULL,
[MRG] [int] NULL,
[mruffino] [int] NULL,
[MSA] [int] NULL,
[MSG] [int] NULL,
[msmorgan] [int] NULL,
[MSP] [int] NULL,
[msredl] [int] NULL,
[MSVP] [int] NULL,
[mwiddowson] [int] NULL,
[MWillis] [int] NULL,
[mxgreen] [int] NULL,
[namatruda] [int] NULL,
[nauszura] [int] NULL,
[nmoriello] [int] NULL,
[NPD] [int] NULL,
[OTSWSP] [int] NULL,
[P140] [int] NULL,
[PAC] [int] NULL,
[pcbeekley] [int] NULL,
[pcif] [int] NULL,
[PEA] [int] NULL,
[PEM] [int] NULL,
[PI] [int] NULL,
[PIA] [int] NULL,
[PIG] [int] NULL,
[PMA] [int] NULL,
[PMS] [int] NULL,
[pomichinski] [int] NULL,
[postatus] [int] NULL,
[PRINT] [int] NULL,
[Processes] [int] NULL,
[ProcessMRP] [int] NULL,
[PSA] [int] NULL,
[PSC] [int] NULL,
[PSCA] [int] NULL,
[PSRD] [int] NULL,
[psspitale] [int] NULL,
[PUR-BUYERS] [int] NULL,
[PUR-MGR] [int] NULL,
[pwelch] [int] NULL,
[pxgoudarzy] [int] NULL,
[QA] [int] NULL,
[QMA] [int] NULL,
[QMG] [int] NULL,
[QTYA] [int] NULL,
[RAD] [int] NULL,
[ragnello] [int] NULL,
[rapereira] [int] NULL,
[rbmartinez] [int] NULL,
[RCB] [int] NULL,
[RCG] [int] NULL,
[rchurchill] [int] NULL,
[rcrasilli] [int] NULL,
[RcvSpvsr] [int] NULL,
[REA] [int] NULL,
[recall] [int] NULL,
[recall01] [int] NULL,
[recall02] [int] NULL,
[recall03] [int] NULL,
[recall04] [int] NULL,
[recall06] [int] NULL,
[recall08] [int] NULL,
[recalladmin] [int] NULL,
[recallpack] [int] NULL,
[recallreprint] [int] NULL,
[rehollender] [int] NULL,
[REQ] [int] NULL,
[REST] [int] NULL,
[rhbelcourt] [int] NULL,
[RI2] [int] NULL,
[RII] [int] NULL,
[riiepicor] [int] NULL,
[RIIT] [int] NULL,
[RIM] [int] NULL,
[rjjandreau] [int] NULL,
[rlsegal] [int] NULL,
[rmassingue] [int] NULL,
[rmmiles] [int] NULL,
[rnadolnysipes] [int] NULL,
[rrose] [int] NULL,
[rtcousens] [int] NULL,
[rweil] [int] NULL,
[rxanderson] [int] NULL,
[SAE] [int] NULL,
[sbarnhart] [int] NULL,
[sbartis] [int] NULL,
[SBL] [int] NULL,
[sc] [int] NULL,
[SCA] [int] NULL,
[SCAdmin] [int] NULL,
[SCG] [int] NULL,
[SCR] [int] NULL,
[SDF] [int] NULL,
[SDG] [int] NULL,
[sdholmes] [int] NULL,
[SEC] [int] NULL,
[SFI] [int] NULL,
[SFM] [int] NULL,
[SF-SUPV] [int] NULL,
[ShipDtl-Lables] [int] NULL,
[SHMG] [int] NULL,
[SIG] [int] NULL,
[sinventory] [int] NULL,
[sjmiller] [int] NULL,
[skamick] [int] NULL,
[skappel] [int] NULL,
[skmiec] [int] NULL,
[skos] [int] NULL,
[skulczyk] [int] NULL,
[SMG] [int] NULL,
[Spares] [int] NULL,
[SPCA] [int] NULL,
[SQE] [int] NULL,
[SRA] [int] NULL,
[SRC] [int] NULL,
[ssbrady] [int] NULL,
[SSG] [int] NULL,
[ssimonow] [int] NULL,
[SupplierApprove] [int] NULL,
[SupplierAutoApprove] [int] NULL,
[tarcadapani] [int] NULL,
[tarcadipani] [int] NULL,
[tbmcsweeney] [int] NULL,
[tburke] [int] NULL,
[tcallahan] [int] NULL,
[TCG] [int] NULL,
[tclemens] [int] NULL,
[TDM] [int] NULL,
[testuser] [int] NULL,
[tjlooney] [int] NULL,
[tjsullivan] [int] NULL,
[tmcnabola] [int] NULL,
[tpstrobel] [int] NULL,
[TRKRS] [int] NULL,
[TSA] [int] NULL,
[tvanflatern] [int] NULL,
[UnShip] [int] NULL,
[USG] [int] NULL,
[VPO] [int] NULL,
[VPQ] [int] NULL,
[wbrown] [int] NULL,
[wpduby] [int] NULL,
[yelzein] [int] NULL,
[zcyr] [int] NULL
) ON [PRIMARY] -
I thought that someone else would pick this one up as a nice challenge, but you've been unlucky! Here is some code which should help you progress. I've used a cut-down version of your sample data to keep things manageable.
First create the tables and put some sample data into #SecurityUsers:
DROP TABLE IF EXISTS #SecurityUsers;
CREATE TABLE #SecurityUsers
(
SecCode NVARCHAR(70) NOT NULL
,Description NVARCHAR(100) NOT NULL
,Users NVARCHAR(MAX) NULL
);
INSERT #SecurityUsers
(
SecCode
,Description
,Users
)
VALUES
('SEC441', 'A/P 1099 Processing', 'aamouta,abanos')
,('SEC44180', 'FIFO Stock Movement DE', 'abajguz')
,('SEC44181', 'Part FIFO Transaction History Tracker DE', 'aamouta,abajguz,abanos,abronk');
DROP TABLE IF EXISTS #SecColumns;
CREATE TABLE #SecColumns
(
SecCode NVARCHAR(70) NOT NULL
,Description NVARCHAR(100) NOT NULL
,aamouta INT
,abajguz INT
,abanos INT
,abronk INT
);Now build and execute the dynamic SQL needed to select the data in the form you require:
DECLARE @SQL1 NVARCHAR(MAX);
DECLARE @SQL2 NVARCHAR(MAX);
DECLARE @SQL3 NVARCHAR(MAX);
DECLARE @SQL NVARCHAR(MAX);
SET @SQL1
= 'WITH split
AS (SELECT su.SecCode
,su.Description
,ss.value
FROM #SecurityUsers su
CROSS APPLY STRING_SPLIT(su.Users, '','') ss)
SELECT split.SecCode
,split.Description
,';
SELECT @SQL2
= STRING_AGG (CONCAT (c.name, ' = MAX(IIF(split.value = ', '''', c.name, '''', ', 1,0))'), ',') WITHIN GROUP(ORDER BY c.column_id)
FROM tempdb.sys.columns c
WHERE c.object_id =
(
SELECT OBJECT_ID ('tempdb.dbo.#seccolumns', 'U')
)
AND c.column_id > 2;
SET @SQL3 = 'FROM split
GROUP BY split.SecCode
,split.Description;';
SET @SQL = CONCAT (@SQL1, @SQL2, @SQL3);
EXEC sys.sp_executesql @SQL;To produce the following result:
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
-
I appreciate this! I'm in a Epicor conference in Las Vegas this week. I'll try this out next week and update with my results. Matt
-
... and here's my attempt at fulfilling your requirements:
/* Load the test data */
DROP TABLE IF EXISTS #SecurityUsers;
CREATE TABLE #SecurityUsers (
SecCode NVARCHAR(70) NOT NULL
,DESCRIPTION NVARCHAR(100) NOT NULL
,Users NVARCHAR(MAX) NULL
);
INSERT INTO #SecurityUsers (
SecCode
,DESCRIPTION
,Users
)
VALUES
('SEC441','A/P 1099 Processing','SDF,ACG,AP2,CRA,ACCT-APSUPV,MIS,SBL,abronk,bboamah,btgyurik,ConversionAdmin,ConversionUser,ixmontalvo,dedison,gherrick,mmgaritta,tcallahan,tburke,namatruda,mrcalderon,btgyurik,aemartinez,ConversionAdmin,ConversionUser,gherrick,mmgaritta,tbmcsweeney,tmcnabola,wpduby,wbrown,skamick,btgyurik,bboamah,bcpaterson,aemartinez,abronk,ConversionAdmin,cjduksa,cnielsen,ConversionUser,dcolson,gherrick,mmgaritta,kggreen,jwbarrett,gherrick,mdriggs,jword,jxmartir,kberger,jsepelak,jniedziela,btgyurik,cdmurphy,aemartinez,ConversionUser,dblair,ConversionAdmin,tpstrobel,mmgaritta,rcrasilli,mmgaritta,gherrick,dpeters,ConversionAdmin,ConversionUser,btgyurik,bcpaterson,tcallahan,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,ConversionAdmin,ConversionUser,btgyurik,aletniowski,gherrick,efernald,manowak,mmgaritta,nmoriello,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta'),
('SEC44180','FIFO Stock Movement DE','*'),
('SEC44181','Part FIFO TRANSACTION History Tracker DE','*'),
('SEC442','Requisition Entry','MCA,MSG,SEC,CFO,MMG,SDF,MM,LGL,SCA,SMG,LESR,QA,INN,ACG,CTE,DMP,SFM,QMG,ISS,CSA,EXEC,SFI,DPM,PAC,CSG,GCVP,SHMG,ACCM,SCG,SAE,CAM,MSVP,AP2,CSS,PUR-BUYERS,MMP,RcvSpvsr,DGMP,HDA,PSA,ASG,CSR,COO,CRA,SQE,VPQ,HRM,ISC,LME,ACCT-AR,REQ,CACG,MSA,DOQ,DME,PEM,DEM,MIE,NPD,SF-SUPV,RAD,VPO,ACCT-APCLERK,ISM,MGMP,ACCT-APSUPV,PUR-MGR,MIS,ESG,DIS,IEG,SSG,QMA,RIM,TDM,SBL,AP3,mxlamanna,MME,ME-ENG,asedberry,bsauer,btgyurik,ConversionAdmin,ConversionUser,gherrick,jvradziwon,mmgaritta,mnaumec,mrcalderon,namatruda,nmoriello,tburke,tcallahan,mmgaritta,gherrick,efernald,dedison,ixmontalvo,ConversionUser,ConversionAdmin,btgyurik,bboamah,aletniowski,abronk,aemartinez,abronk,bboamah,btgyurik,ConversionAdmin,ConversionUser,ixmontalvo,dedison,gherrick,mmgaritta,tcallahan,tburke,namatruda,mrcalderon,mrcalderon,namatruda,mmgaritta,gherrick,ConversionUser,ConversionAdmin,btgyurik,btgyurik,aemartinez,ConversionAdmin,ConversionUser,gherrick,mmgaritta,mmgaritta,gherrick,ConversionUser,ConversionAdmin,axlokteva,btgyurik,namatruda,mrcalderon,tbmcsweeney,tmcnabola,wpduby,wbrown,skamick,btgyurik,bboamah,bcpaterson,aemartinez,abronk,ConversionAdmin,cjduksa,cnielsen,ConversionUser,dcolson,gherrick,mmgaritta,kggreen,jwbarrett,lhandberry,mailroom,ixmontalvo,gherrick,btgyurik,rlsegal,namatruda,mmgaritta,gherrick,mdriggs,jword,jxmartir,kberger,jsepelak,jniedziela,btgyurik,cdmurphy,aemartinez,ConversionUser,dblair,ConversionAdmin,tpstrobel,mmgaritta,rcrasilli,mlnewton,mmgaritta,gherrick,ConversionAdmin,ConversionUser,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,mmgaritta,gherrick,ConversionAdmin,ConversionUser,btgyurik,bboamah,abronk,aemartinez,wbrown,wpduby,tbmcsweeney,tmcnabola,skamick,btgyurik,ConversionUser,dcolson,ConversionAdmin,cnielsen,cjduksa,gherrick,mmgaritta,jwbarrett,jekubish,mmgaritta,gherrick,cnielsen,ConversionAdmin,dcolson,ConversionUser,btgyurik,tbmcsweeney,rmassingue,mnaumec,rcrasilli,rapereira,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,jxmartir,jekubish,jniedziela,jvradziwon,mmgaritta,gherrick,dpeters,ConversionAdmin,ConversionUser,btgyurik,bcpaterson,tcallahan,tjlooney,pcbeekley,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,mmgaritta,mharty,khgriffin,kpcarlson,jhernandez,EEaston,gherrick,btgyurik,cjohnson,ConversionAdmin,ConversionUser,recall01,recall03,recall02,mpersaud,tarcadipani,recall04,recall06,recall08,recallreprint,recall08,recall06,ConversionUser,ConversionAdmin,btgyurik,gherrick,kpcarlson,khgriffin,mmgaritta,jbergeron,gherrick,btgyurik,ConversionUser,ConversionAdmin,rapereira,mmgaritta,mmgaritta,ConversionAdmin,ConversionUser,btgyurik,gherrick,gherrick,btgyurik,ConversionUser,ConversionAdmin,mmgaritta,sbarnhart,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,gherrick,mmgaritta,btgyurik,betannone,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,jmbaldini,jtreglia,gherrick,mmgaritta,mmgaritta,tjlooney,gherrick,mchristman,btgyurik,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,mmgaritta,gherrick,btgyurik,ConversionAdmin,ConversionUser,mmgaritta,sbartis,gherrick,dmsilvers,btgyurik,bjohnson,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,dcamera,btgyurik,gherrick,mbarton,jreddington,skappel,zcyr,mmgaritta,mruffino,pomichinski,mmgaritta,gherrick,ejtalasco,dmcdaniel,ikolev,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,alcole,gherrick,jniedziela,mmgaritta,mmgaritta,mwiddowson,yelzein,tjsullivan,jheider,jekubish,mdixon,gherrick,dgrier,btgyurik,cfresher,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,mmgaritta,rrose,gherrick,jrballard,bbermani,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,dspencer,mmgaritta,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,mmgaritta,jekubish,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,ddsenchuk,dmcdaniel,mmgaritta,btgyurik,ConversionUser,ConversionAdmin,gherrick,ddemoss,midrees,mmgaritta,tclemens,mmgaritta,gherrick,ConversionAdmin,ConversionUser,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,psspitale,rchurchill,mmgaritta,tarcadipani,skmiec,rnadolnysipes,rjjandreau,recall06,gherrick,ebard,mharty,jxfederkiew,jwbarrett,ConversionAdmin,cjduksa,ConversionUser,btgyurik,abanos,mmgaritta,recall02,recall03,recall01,mpersaud,pcbeekley,recallreprint,rhbelcourt,recall08,recall04,recall06,rlsegal,rmmiles,skos,ssbrady,tarcadipani,tarcadapani,tjlooney,gherrick,EEaston,dropes,ehysenllari,jsgueglia,jtreglia,jekubish,jhernandez,jmillion,jmbaldini,karoyce,khgriffin,kxmroczka,lhandberry,kpcarlson,mharty,ConversionAdmin,cjohnson,cnielsen,ConversionUser,btgyurik,ajlopes,asedberry,bsauer,mmgaritta,gherrick,ConversionAdmin,ConversionUser,btgyurik,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,mmgaritta,jrozzi,gherrick,axdaigle,btgyurik,ConversionUser,ConversionAdmin,btgyurik,gherrick,dxveilleux,mmgaritta,ajlopes,btgyurik,ConversionAdmin,ConversionUser,khgriffin,mharty,gherrick,tarcadapani,tarcadipani,recall08,recall04,recall06,recall02,recall03,recall01,rbmartinez,mpersaud,mmgaritta,mnaumec,mmgaritta,rchurchill,pwelch,nauszura,rnadolnysipes,sbartis,recall06,skmiec,skos,wpduby,gherrick,dropes,ebard,dlockery,ehysenllari,ezahradnik,karoyce,khgriffin,kpcarlson,jvradziwon,jwbarrett,cjduksa,bvincent,btgyurik,bboamah,abronk,abanos,ConversionAdmin,ConversionUser,ConversionUser,ConversionAdmin,btgyurik,kpcarlson,dlockery,gherrick,rmmiles,mmgaritta,mmgaritta,gherrick,btgyurik,ConversionAdmin,ConversionUser,ConversionUser,ConversionAdmin,cjparlato,btgyurik,abajguz,bbermani,gherrick,jamassey,ksika,mchristman,jrballard,jsgueglia,mmgaritta,rrose,tvanflatern,tbmcsweeney,mmgaritta,jsgueglia,mchristman,gherrick,abajguz,btgyurik,cjparlato,ConversionAdmin,ConversionUser,ConversionUser,ConversionAdmin,btgyurik,gherrick,khgriffin,mmgaritta,rweil,mmgaritta,MGARITTA,gherrick,btgyurik,ConversionAdmin,ConversionUser,ConversionUser,ConversionAdmin,btgyurik,abajguz,gherrick,mchristman,mailroom,jekubish,mmgaritta,psspitale,msredl,sjmiller,tpstrobel,mmgaritta,jsepelak,mdriggs,kberger,jword,gherrick,btgyurik,cdmurphy,ConversionAdmin,ConversionUser,dblair,btgyurik,asedberry,bsauer,ConversionUser,ConversionAdmin,gherrick,dcscott,kxmroczka,jmillion,ssimonow,recall06,mmgaritta,mmgaritta,gherrick,btgyurik,ConversionUser,dajadovich,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,aletniowski,gherrick,efernald,manowak,mmgaritta,nmoriello,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,cjohnson,ConversionUser,dcgreen,btgyurik,bbermani,bboamah,abronk,gherrick,EEaston,khgriffin,jhernandez,jmbaldini,jtreglia,jrballard,mmgaritta,mpersaud,recall02,recall03,recall01,recall08,recallreprint,rhbelcourt,recall06,recall04,rrose,ssbrady,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,btgyurik,asedberry,bsauer,ConversionUser,cjohnson,ConversionAdmin,jhernandez,grmcall,gherrick,EEaston,mmgaritta,mmgaritta,recall06,dezajac,gherrick,ConversionUser,ConversionAdmin,bsauer,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,mmgaritta,mnaumec,ssbrady,gherrick,jvradziwon,kpcarlson,ConversionAdmin,ConversionUser,btgyurik,btgyurik,ConversionUser,ConversionAdmin,kpcarlson,gherrick,mmgaritta,mmgaritta,msmorgan,nauszura,pxgoudarzy,rchurchill,skmiec,recall06,rnadolnysipes,rxanderson,gherrick,javedisian,ebard,dmaclary,kpcarlson,mhinckley,jwbarrett,ConversionAdmin,ConversionUser,dalberding,btgyurik,bvincent,cjduksa,aamouta,abanos,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,mmgaritta,gherrick,krlangevin,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,rhbelcourt,tvanflatern,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin'),
('SEC443','Requisition Tracker','MCA,MSG,SEC,CFO,MMG,SDF,MM,LGL,SCA,SMG,LESR,QA,INN,ACG,TRKRS,DMP,SFM,QMG,ISS,CSA,SFI,DPM,PAC,CSG,GCVP,SHMG,ACCM,SAE,CAM,RAD,CSS,PUR-BUYERS,MMP,DGMP,HDA,DOQ,ASG,CSR,COO,CRA,SQE,VPQ,HRM,ISC,LME,ACCT-AR,REQ,RIM,CACG,MSA,DME,PEM,DEM,MIE,MAINT-UNION,PMS,NPD,SF-SUPV,VPO,dboratko,ISM,MGMP,ACCT-APSUPV,PUR-MGR,MIS,ESG,DIS,IEG,SSG,ACCT-APCLERK,SBL,mxlamanna,FCG,MME,ME-ENG,asedberry,bsauer,btgyurik,ConversionAdmin,ConversionUser,gherrick,jvradziwon,mmgaritta,mnaumec,mrcalderon,namatruda,nmoriello,tburke,tcallahan,mmgaritta,gherrick,efernald,dedison,ixmontalvo,ConversionUser,ConversionAdmin,btgyurik,bboamah,aletniowski,abronk,aemartinez,btgyurik,aemartinez,ConversionAdmin,ConversionUser,gherrick,mmgaritta,mmgaritta,gherrick,ConversionUser,ConversionAdmin,axlokteva,btgyurik,namatruda,mrcalderon,tbmcsweeney,tmcnabola,wpduby,wbrown,skamick,btgyurik,bboamah,bcpaterson,aemartinez,abronk,ConversionAdmin,cjduksa,cnielsen,ConversionUser,dcolson,gherrick,mmgaritta,kggreen,jwbarrett,lhandberry,mailroom,ixmontalvo,gherrick,btgyurik,rlsegal,namatruda,mmgaritta,gherrick,mdriggs,jword,jxmartir,kberger,jsepelak,jniedziela,btgyurik,cdmurphy,aemartinez,ConversionUser,dblair,ConversionAdmin,tpstrobel,mmgaritta,rcrasilli,mlnewton,mmgaritta,gherrick,ConversionAdmin,ConversionUser,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,wpduby,tbmcsweeney,tmcnabola,skamick,btgyurik,ConversionUser,dcolson,ConversionAdmin,cnielsen,cjduksa,gherrick,mmgaritta,jwbarrett,jekubish,mmgaritta,gherrick,cnielsen,ConversionAdmin,dcolson,ConversionUser,btgyurik,tbmcsweeney,rmassingue,mnaumec,rcrasilli,rapereira,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,jxmartir,jekubish,jniedziela,jvradziwon,mmgaritta,gherrick,dpeters,ConversionAdmin,ConversionUser,btgyurik,bcpaterson,tcallahan,tjlooney,pcbeekley,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,mmgaritta,mharty,khgriffin,kpcarlson,jhernandez,EEaston,gherrick,btgyurik,cjohnson,ConversionAdmin,ConversionUser,recall01,recall03,recall02,mpersaud,tarcadipani,recall04,recall06,recall08,recallreprint,recall08,recall06,ConversionUser,ConversionAdmin,btgyurik,gherrick,kpcarlson,khgriffin,mmgaritta,jbergeron,gherrick,btgyurik,ConversionUser,ConversionAdmin,rapereira,mmgaritta,mmgaritta,ConversionAdmin,ConversionUser,btgyurik,gherrick,gherrick,btgyurik,ConversionUser,ConversionAdmin,mmgaritta,sbarnhart,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,gherrick,mmgaritta,btgyurik,betannone,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,jmbaldini,jtreglia,gherrick,mmgaritta,mmgaritta,tjlooney,gherrick,mchristman,btgyurik,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionUser,dcolson,ConversionAdmin,cjohnson,caplumadore,btgyurik,gherrick,EEaston,MGARITTA,jhernandez,mmgaritta,mpersaud,rbmartinez,rchurchill,ConversionUser,ConversionAdmin,cjohnson,btgyurik,caplumadore,gherrick,EEaston,jhernandez,mmgaritta,mpersaud,rchurchill,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,mmgaritta,gherrick,btgyurik,ConversionAdmin,ConversionUser,mmgaritta,sbartis,gherrick,dmsilvers,btgyurik,bjohnson,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,dcamera,btgyurik,gherrick,mbarton,jreddington,skappel,zcyr,mmgaritta,mruffino,pomichinski,mmgaritta,gherrick,ejtalasco,dmcdaniel,ikolev,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,alcole,gherrick,jniedziela,mmgaritta,mmgaritta,mwiddowson,yelzein,tjsullivan,jheider,jekubish,mdixon,gherrick,dgrier,btgyurik,cfresher,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,mmgaritta,rrose,gherrick,jrballard,bbermani,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,dspencer,mmgaritta,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,mmgaritta,jekubish,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,ddsenchuk,dmcdaniel,mmgaritta,btgyurik,ConversionUser,ConversionAdmin,gherrick,ddemoss,midrees,mmgaritta,tclemens,mmgaritta,gherrick,ConversionAdmin,ConversionUser,btgyurik,rchurchill,mmgaritta,tarcadipani,skmiec,rnadolnysipes,rjjandreau,recall06,gherrick,ebard,mharty,jxfederkiew,jwbarrett,ConversionAdmin,cjduksa,ConversionUser,btgyurik,abanos,mmgaritta,recall02,recall03,recall01,mpersaud,pcbeekley,recallreprint,rhbelcourt,recall08,recall04,recall06,rlsegal,rmmiles,skos,ssbrady,tarcadipani,tarcadapani,tjlooney,gherrick,EEaston,dropes,ehysenllari,jsgueglia,jtreglia,jekubish,jhernandez,jmillion,jmbaldini,karoyce,khgriffin,kxmroczka,lhandberry,kpcarlson,mharty,ConversionAdmin,cjohnson,cnielsen,ConversionUser,btgyurik,ajlopes,asedberry,bsauer,mmgaritta,gherrick,ConversionAdmin,ConversionUser,btgyurik,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,mmgaritta,jrozzi,gherrick,axdaigle,btgyurik,ConversionUser,ConversionAdmin,btgyurik,gherrick,dxveilleux,mmgaritta,btgyurik,ConversionUser,ConversionAdmin,jvradziwon,jwbarrett,gherrick,recall06,rchurchill,msredl,mnaumec,mmgaritta,mnaumec,mmgaritta,rchurchill,pwelch,nauszura,rnadolnysipes,sbartis,recall06,skmiec,skos,wpduby,gherrick,dropes,ebard,dlockery,ehysenllari,ezahradnik,karoyce,khgriffin,kpcarlson,jvradziwon,jwbarrett,cjduksa,bvincent,btgyurik,bboamah,abronk,abanos,ConversionAdmin,ConversionUser,ConversionUser,ConversionAdmin,btgyurik,kpcarlson,dlockery,gherrick,rmmiles,mmgaritta,ConversionUser,ConversionAdmin,cjparlato,btgyurik,abajguz,bbermani,gherrick,jamassey,ksika,mchristman,jrballard,jsgueglia,mmgaritta,rrose,tvanflatern,tbmcsweeney,mmgaritta,jsgueglia,mchristman,gherrick,abajguz,btgyurik,cjparlato,ConversionAdmin,ConversionUser,ConversionUser,ConversionAdmin,btgyurik,gherrick,khgriffin,mmgaritta,rweil,ConversionUser,ConversionAdmin,btgyurik,abajguz,gherrick,mchristman,mailroom,jekubish,mmgaritta,psspitale,msredl,sjmiller,tpstrobel,mmgaritta,jsepelak,mdriggs,kberger,jword,gherrick,btgyurik,cdmurphy,ConversionAdmin,ConversionUser,dblair,btgyurik,asedberry,bsauer,ConversionUser,ConversionAdmin,gherrick,dcscott,kxmroczka,jmillion,ssimonow,recall06,mmgaritta,mmgaritta,gherrick,btgyurik,ConversionUser,dajadovich,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,aletniowski,gherrick,efernald,manowak,mmgaritta,nmoriello,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,cjohnson,ConversionUser,dcgreen,btgyurik,bbermani,bboamah,abronk,gherrick,EEaston,khgriffin,jhernandez,jmbaldini,jtreglia,jrballard,mmgaritta,mpersaud,recall02,recall03,recall01,recall08,recallreprint,rhbelcourt,recall06,recall04,rrose,ssbrady,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,mmgaritta,recall06,dezajac,gherrick,ConversionUser,ConversionAdmin,bsauer,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,mmgaritta,mnaumec,ssbrady,gherrick,jvradziwon,kpcarlson,ConversionAdmin,ConversionUser,btgyurik,btgyurik,ConversionUser,ConversionAdmin,kpcarlson,gherrick,mmgaritta,mmgaritta,msmorgan,nauszura,pxgoudarzy,rchurchill,skmiec,recall06,rnadolnysipes,rxanderson,gherrick,javedisian,ebard,dmaclary,kpcarlson,mhinckley,jwbarrett,ConversionAdmin,ConversionUser,dalberding,btgyurik,bvincent,cjduksa,aamouta,abanos,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,ConversionAdmin,cjparlato,cnielsen,cjohnson,ConversionUser,dalberding,cscott,dcamera,dblair,dcgreen,dcolson,btgyurik,bvincent,cbreuler,caplumadore,cdmurphy,cfresher,cjduksa,betannone,bsauer,bcpaterson,aletniowski,asedberry,alcole,bboamah,axlokteva,bbermani,axdaigle,abronk,ajlopes,aemartinez,aamouta,abajguz,abanos,gherrick,ikolev,jamassey,javedisian,gxkuczynko,inventory,ixmontalvo,dspencer,dxveilleux,dropes,dpeters,dmaclary,dmcdaniel,ebard,EEaston,dgrier,dedison,dlockery,dcscott,ddemoss,ddsenchuk,dezajac,ejtalasco,ezahradnik,ehysenllari,efernald,lxguadalupe,manowak,mbarton,mchristman,mdixon,mdriggs,midrees,mharty,mhinckley,mlnewton,karoyce,kberger,khgriffin,jword,jxfederkiew,jxmartir,lhandberry,krlangevin,ksika,kxmroczka,kggreen,kpcarlson,jniedziela,jmillion,jmbaldini,jekubish,jbergeron,jheider,jgsantos,jhernandez,jtreglia,jtavares,jsgueglia,jsepelak,jrozzi,jreddington,jrballard,jvradziwon,jwbarrett,mmgaritta,mnaumec,rcrasilli,recall01,recall03,recall02,ragnello,pxgoudarzy,pwelch,psspitale,pomichinski,rapereira,rbmartinez,rchurchill,mpersaud,msmorgan,msredl,mruffino,mrcalderon,mwiddowson,pcbeekley,nmoriello,nauszura,rmmiles,rnadolnysipes,rrose,rlsegal,rmassingue,rjjandreau,rehollender,skappel,sjmiller,sinventory,skamick,sbarnhart,rxanderson,rweil,recall04,rhbelcourt,recallreprint,recallpack,recall08,recall06,ssbrady,skos,skmiec,ssimonow,tarcadapani,tclemens,tmcnabola,tarcadipani,tburke,tcallahan,yelzein,wbrown,wpduby,tvanflatern,tpstrobel,tjlooney,tjsullivan,zcyr,mmgaritta,gherrick,krlangevin,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ConversionUser,btgyurik,gherrick,mmgaritta,rhbelcourt,tvanflatern,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin'),
('SEC443-001','Memo Maintenance','*'),
('SEC444','Requisition Actions','MIS,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT'),
('SEC445','MRP AND MPS','MCA,PUR-BUYERS,ProcessMRP,MCA2,FSA,MMP,COO,DMP,DME,PM-SG,PM-RC,MIS,SBL,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,mmgaritta,sbarnhart,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,mmgaritta,gherrick,flash,btgyurik,ConversionAdmin,ConversionUser,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,rchurchill,mmgaritta,tarcadipani,skmiec,rnadolnysipes,rjjandreau,recall06,gherrick,ebard,mharty,jxfederkiew,jwbarrett,ConversionAdmin,cjduksa,ConversionUser,btgyurik,abanos,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,mnaumec,mmgaritta,rchurchill,pwelch,nauszura,rnadolnysipes,sbartis,recall06,skmiec,skos,wpduby,gherrick,dropes,ebard,dlockery,ehysenllari,ezahradnik,karoyce,khgriffin,kpcarlson,jvradziwon,jwbarrett,cjduksa,bvincent,btgyurik,bboamah,abronk,abanos,ConversionAdmin,ConversionUser,mmgaritta,jxfederkiew,gherrick,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta'),
('SEC446','FILE Maintenance','PUR-BUYERS,PM-SG,MIS,SBL,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,mnaumec,mmgaritta,rchurchill,pwelch,nauszura,rnadolnysipes,sbartis,recall06,skmiec,skos,wpduby,gherrick,dropes,ebard,dlockery,ehysenllari,ezahradnik,karoyce,khgriffin,kpcarlson,jvradziwon,jwbarrett,cjduksa,bvincent,btgyurik,bboamah,abronk,abanos,ConversionAdmin,ConversionUser,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta'),
('SEC447','General Operations','MCA2,FSA,MMP,COO,DMP,DME,PM-SG,PUR-MGR,MIS,SBL,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,gherrick,btgyurik,ConversionUser,ConversionAdmin,mmgaritta,sbarnhart,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,mmgaritta,gherrick,flash,btgyurik,ConversionAdmin,ConversionUser,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,rchurchill,mmgaritta,tarcadipani,skmiec,rnadolnysipes,rjjandreau,recall06,gherrick,ebard,mharty,jxfederkiew,jwbarrett,ConversionAdmin,cjduksa,ConversionUser,btgyurik,abanos,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,ConversionUser,ConversionAdmin,btgyurik,kpcarlson,dlockery,gherrick,rmmiles,mmgaritta,mmgaritta,jxfederkiew,gherrick,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta'),
('SEC447-001','MPS-ORDER Detail','MMP,COO,DMP,MIS,SBL,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta'),
('SEC448','Reports','MCA,PUR-BUYERS,MMP,COO,DMP,PM-RC,PUR-MGR,MIS,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,rchurchill,mmgaritta,tarcadipani,skmiec,rnadolnysipes,rjjandreau,recall06,gherrick,ebard,mharty,jxfederkiew,jwbarrett,ConversionAdmin,cjduksa,ConversionUser,btgyurik,abanos,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,mnaumec,mmgaritta,rchurchill,pwelch,nauszura,rnadolnysipes,sbartis,recall06,skmiec,skos,wpduby,gherrick,dropes,ebard,dlockery,ehysenllari,ezahradnik,karoyce,khgriffin,kpcarlson,jvradziwon,jwbarrett,cjduksa,bvincent,btgyurik,bboamah,abronk,abanos,ConversionAdmin,ConversionUser,ConversionUser,ConversionAdmin,btgyurik,kpcarlson,dlockery,gherrick,rmmiles,mmgaritta'),
('SEC449','Forecast Entry','MCA2,MMP,COO,DMP,PUR-MGR,MIS,SBL,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,rchurchill,mmgaritta,tarcadipani,skmiec,rnadolnysipes,rjjandreau,recall06,gherrick,ebard,mharty,jxfederkiew,jwbarrett,ConversionAdmin,cjduksa,ConversionUser,btgyurik,abanos,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,ConversionUser,ConversionAdmin,btgyurik,kpcarlson,dlockery,gherrick,rmmiles,mmgaritta,mmgaritta,jxfederkiew,gherrick,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta'),
('SEC450','MPS Entry','MCA2,MMP,COO,DMP,PUR-MGR,MIS,SBL,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta,skamick,tmcnabola,wpduby,mmgaritta,ConversionAdmin,cjduksa,ConversionUser,btgyurik,gherrick,ConversionAdmin,ConversionUser,btgyurik,cjduksa,abajguz,gherrick,gxkuczynko,mchristman,mmgaritta,msmorgan,tmcnabola,wpduby,skamick,skamick,wpduby,tmcnabola,msmorgan,mmgaritta,gherrick,cjduksa,btgyurik,ConversionUser,ConversionAdmin,rchurchill,mmgaritta,tarcadipani,skmiec,rnadolnysipes,rjjandreau,recall06,gherrick,ebard,mharty,jxfederkiew,jwbarrett,ConversionAdmin,cjduksa,ConversionUser,btgyurik,abanos,ConversionAdmin,ColtEDI,ConversionUser,btgyurik,BBerry,gherrick,Encompass,epicadmin,EpicorECC,EpicorSRV,ERPSVC,DocStar,MGARITTA,MANAGER,mjdepiano,skulczyk,tbmcsweeney,REST,sc,SCAdmin,rtcousens,recalladmin,mmgaritta,MWillis,PRINT,ConversionUser,ConversionAdmin,btgyurik,kpcarlson,dlockery,gherrick,rmmiles,mmgaritta,mmgaritta,jxfederkiew,gherrick,btgyurik,btgyurik,ConversionUser,ConversionAdmin,gherrick,mmgaritta')
/* Convert the security users into a "normal" style table */
DROP TABLE IF EXISTS #SecUsers;
CREATE TABLE #SecUsers (
SecCode NVARCHAR(70) NOT NULL
,DESCRIPTION NVARCHAR(100) NOT NULL
,UserId NVARCHAR(25)
);
INSERT INTO #SecUsers (SecCode, DESCRIPTION, UserId)
SELECT
s.SecCode,
s.DESCRIPTION,
u.Userid
FROM #SecurityUsers s
CROSS APPLY (
SELECT CAST(TRIM(value) AS NVARCHAR(25)) AS UserId
FROM STRING_SPLIT(s.Users,',')
) u
/* Extract information about the distinct users stored in the source table */
DECLARE @OverallSecUsers TABLE (
UserId NVARCHAR(25) PRIMARY KEY
);
INSERT INTO @OverallSecUsers (UserId)
SELECT DISTINCT
UserId
FROM #SecUsers;
/* Create the SQL statement to pivot the information */DECLARE @CRLF CHAR(2) = CHAR(13)+CHAR(11)
DECLARE @SQL VARCHAR(MAX)
SELECT @SQL =
'SELECT ' + @CRLF +
' SecCode' + @CRLF +
' ,DESCRIPTION' + @CRLF +
' ,' + STRING_AGG(
CONCAT(
CAST('CASE WHEN ' AS VARCHAR(MAX)),
QUOTENAME(UserId),
' = 0 THEN '''' ELSE ''TRUE'' END AS ',
QUOTENAME(UserId),
@CRLF,
' '
),
',') WITHIN GROUP(ORDER BY u.UserId) + @CRLF +
'FROM (' + @CRLF +
' SELECT SecCode, DESCRIPTION, UserId' + @CRLF +
' FROM #SecUsers' + @CRLF +
' ) AS ST' + @CRLF +
'PIVOT (' + @CRLF +
' COUNT(UserId)' + @CRLF +
' FOR UserId IN (' + STRING_AGG(QUOTENAME(u.UserId),N',') WITHIN GROUP(ORDER BY u.UserId) + ')' + @CRLF +
' ) AS PT' + @CRLF +
'ORDER BY PT.SecCode'
FROM @OverallSecUsers u
/* Execute the SQL statement (PIVOT query) and return the resultset */
EXEC(@SQL) -
Nice!!
Other then updating the query to use my tables/views I only had to make two other adjustments. Some of the Column names used "-". This was throwing an error (Incorrect syntax near '=' ) when it executed the last statement EXEC sys.sp_executesql @SQL. What I did was comment out (EXEC sys.sp_executesql @SQL) and added (SELECT @SQL) in its place . Then I copied the output from that select and executed the generated code. The error I received was a little more meaningful. IntelliSense picked up on one of the first select statement columns ACCT-APCLERK = MAX(IIF(split.value = 'ACCT-APCLERK', 1,0)). It was showing an Error by the first "=". What I ended up doing was adding brackets around the Column name [ACCT-APCLERK ]. I also received an error that STRING_AGG was exceeding is character limit so I cast the column names as NVARCHAR(MAX) .The corrections I made to the code were in the @SQL2 as shown.
SELECT @SQL2
= STRING_AGG (CONCAT (CAST ('['+c.name+']' AS NVARCHAR(MAX)), ' = MAX(IIF(split.value = ', '''', CAST(c.name AS NVARCHAR(MAX)), '''', ', 1,0))'), ',') WITHIN GROUP(ORDER BY c.column_id)
FROM EpicorViews.sys.columns c
WHERE c.object_id =
(
SELECT OBJECT_ID ('[EpicorViews].[dbo].[SecColumns]', 'U')
)
AND c.column_id > 2; -
You did exactly the right thing in adding the []. Your other fix also looks good, well done on resolving the issues!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply