InstantForum.NET v4.1.4StrataFrame Forumhttp://forum.strataframe.net/forum@strataframe.netThu, 21 Aug 2008 15:58:21 GMT20http://forum.strataframe.net/Topic6282-11-1.aspxI am sure that it is fine. The view is deployed through SMO and at times the columns can be rearranged under certain circumstances. You should be fine.Fri, 26 Jan 2007 07:45:29 GMTTrent L. Taylorhttp://forum.strataframe.net/Topic6282-11-1.aspxI just tried to create a view in the DDT based on a Union query. The view looks something like this:<br><br>Select Distinct<br> us_pk<br> ,pm_id<br> ,pm_key<br> ,up_action<br>From SFSUserPermissionInfo<br><br>Union<br><br>Select Distinct<br> us_pk<br> ,pm_id<br> ,pm_key<br> ,up_action<br>From SFSUserRolePermissionInfo<br><br>When I save it, it reports the following as the columns:<br><br> Column Table<br> ----------------- --------------------------------------<br> pm_pk SFSPermissions<br> pm_pk SFSPermissions<br> pm_key SFSPermissions<br> pm_Key SFSPermissions<br> up_Action SFSUsersXPermissions<br> rp_Action SFSUsersXRoles<br> Distinct| us_pk SFSUserPermissionInfo| || Union<br> Distinct| us_pk SFSUserPermissionInfo| || Union<br><br>I deployed it and built a BO off of it and all seems to work, but the columns/tables are weird. I'm assuming that there are no significant ramifications of this, but I'd like to be sure all is OK.Thu, 25 Jan 2007 19:44:48 GMTGreg McGuffey