Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Code:
SELECT TOP 1000 [UserName]
,[PropertyName]
,[Value]
FROM [1stTouch_Live].[Profile].[UserProperties]
where UserName='SHG\jim.Graham'
Result:
UserName | PropertyName | Value |
SHG\jim.graham | Agency | GEN |
SHG\jim.graham | Maximum Scheduled Tasks | 1 |
SHG\jim.graham | Operative name | Jim Graham |
SHG\jim.graham | Dispatch Mode | Responsive |
SHG\jim.graham | Server Instance | OptiTime |
SHG\jim.graham | _ResourceID | 208 |
SHG\jim.graham | StockHolderID | 1 |
SHG\jim.graham | Store | 1 |
SHG\jim.graham | Supervisor name | Chris Hope |
SHG\jim.graham | Supervisor number | |
SHG\jim.graham | VanID | D256 |
SHG\jim.graham | View Key Fields On Disabled Tasks | true |
SHG\jim.graham | Volume | K |
SHG\jim.graham | WorkDayBoundaryTime | 05:00:00 |
How can I change this to be
Username | Agency | Maximum Scheduled Tasks | Operative name | ||||||
---|---|---|---|---|---|---|---|---|---|
SHG\jim.graham | GEN | 1 | Jim Graham |
Thanks,
Darren
Fantastic. Thank you very much!!