I am doing an enormous set of joins throughout about 20 tables to strive get this Mcafee product to show a viable information comparability set. Nonetheless, a number of tables have distinctive values in the identical column that must be mixed into the identical ID. I am unable to for the lifetime of me determine easy methods to mix the values.
Can somebody assist push me in the correct route please.
That is an instance of what I see for schedules:
AutoId | TaskScheduleId | SettingName | SettingValue | TheTimestamp
999 | 14 | GMTTime | 0 | 0x000000000008BC17
1000 | 14 | RandomizationEnabled | 1 | 0x000000000008BC18
1001 | 14 | RandomizationWndMins | 120 | 0x000000000008BC19
1002 | 14 | RepeatDays | 2 | 0x000000000008BC1B
1004 | 14 | RepeatOption | 0 | 0x000000000008BC1C
1005 | 14 | RunIfMissed | 1 | 0x000000000008BC1D
1007 | 14 | RunIfMissedDelayMins | 15 | 0x000000000008BC1E
1008 | 14 | StartDateTime | 20000508060000 | 0x000000000008BC1F
That is what I am making an attempt to get to a complete record of 1000’s of those:
TaskScheduleId | SettingName1 | SettingValue1 | SettingName2 | SettingValue2 | SettingName3 | SettingValue3
14 GMTTime 0 RandomizationEnabled 1 StartDateTime 20000508060000