Profileid
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 10 articles for 0.000 sec
Re: XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: Peter W. DeBetta
Date: Sep 20, 2006 21:39

... AS [Traveler/PersonID], (SELECT Profile.ProfileID, (SELECT EmailAddress.EmailAddressID FROM EmailAddress ... subqueries. SELECT Traveler.PersonID, Profile.ProfileID, EmailAddress.EmailAddressID FROM EmailAddress AS ...000FFE41B09F</EmailAddressID> </EmailAddress> </Profile> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-41B09F000FFE...
Show full article (8.41Kb) · Show article thread
Re: XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: tempdba
Date: Sep 18, 2006 07:39

... incorporating subqueries. SELECT Traveler.PersonID, Profile.ProfileID, EmailAddress.EmailAddressID FROM EmailAddress AS ...-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</...-000FFE41B09F</EmailAddressID> </EmailAddress> </Profile> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-41B09F000FFE</...
Show full article (5.16Kb) · Show article thread
Re: XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: Peter W. DeBetta
Date: Sep 15, 2006 15:07

... incorporating subqueries. SELECT Traveler.PersonID, Profile.ProfileID, EmailAddress.EmailAddressID FROM EmailAddress AS EmailAddress...-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</...-BFF0-000FFE41B09F</EmailAddressID> </EmailAddress> </Profile> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-41B09F000FFE</...
Show full article (4.54Kb) · Show article thread
Re: XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: tempdba
Date: Sep 7, 2006 14:20

... "Traveler/Profile/StatusName", CASE WHEN Profile.ProfileID IS NOT NULL THEN 0 END AS...JOIN Profile_EmailAddress AS OrganizationProfileEmergencyContactProfile_EmailAddress ON OrganizationProfileEmergencyContactProfile.ProfileID = OrganizationProfileEmergencyContactProfile_EmailAddress.ProfileID LEFT OUTER JOIN EmailAddress AS ...
Show full article (39.52Kb) · Show article thread
Re: XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: tempdba
Date: Sep 7, 2006 05:46

...like (untested): SELECT Person.PersonID AS "Traveler/PersonID", Profile.ProfileID AS "Traveler/Profile/ProfileID", ( ... Person_Profile.PersonID NNER JOIN Profile ON Person_Profile.ProfileID = Profile.ProfileID LEFT OUTER JOIN Profile_EmailAddress ON Profile.ProfileID = Profile_EmailAddress.ProfileID WHERE Person.PersonID = '82F81341-C736-DB11-BFF0-000FFE41B09F' FOR...
Show full article (1.08Kb) · Show article thread
Re: XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: Kent Tegels
Date: Sep 6, 2006 17:01

...SELECT Person.PersonID AS "Traveler/PersonID", Profile.ProfileID AS "Traveler/Profile/ProfileID", ( select EmailAddress.EmailAddressID AS "Traveler/Profile/EmailAddess/EmailAddressID" LEFT OUTER ...JOIN Profile ON Person_Profile.ProfileID = Profile.ProfileID LEFT OUTER JOIN Profile_EmailAddress...ON Profile.ProfileID = Profile_EmailAddress.ProfileID WHERE Person.PersonID = '82F81341-C736-DB11...
Show full article (0.81Kb) · Show article thread
XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: tempdba
Date: Sep 6, 2006 14:40

...>82F81341-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</ProfileID> <...>82F81341-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</ProfileID> <...-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</ProfileID>...
Show full article (2.73Kb)
XML Path returns multiple children instead of one record     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: tempdba
Date: Sep 6, 2006 14:39

...>82F81341-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</ProfileID> <...>82F81341-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</ProfileID> <...-C736-DB11-BFF0-000FFE41B09F</PersonID> <Profile> <ProfileID>AEDBE5B7-8737-DB11-BFF0-000FFE41B09F</ProfileID>...
Show full article (2.73Kb)
Re: Problem serializing xml with FOR XML EXPLICIT     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: rhaazy
Date: Jul 24, 2006 12:23

...// Set the text of the command xmlCmd.CommandText = @"select 1 as Tag, 0 as parent, MAC as [ProfileID!1!MAC!Element], " + "MessageTYpeID as [ProfileID!1!MessageTypeID!Element], ID as [ProfileID!1!ID] from tblClientMessage " + "for xml explicit"; // Execute the command to retrieve the xml from sql in the...
Show full article (1.42Kb) · Show article thread
Problem serializing xml with FOR XML EXPLICIT     

Group: microsoft.public.sqlserver.xml · Group Profile · Search for Profileid in microsoft.public.sqlserver.xml
Author: rhaazy
Date: Jul 24, 2006 08:12

...[ProfileID!12!MessageTypeID!Element], ID as [ProfileID!12!ID] from tblClientMessage " + "for xml...11:11</MAC><MessageTypeID>3</MessageTypeID></ProfileID></XML_F52E2B61-18A1-11d1-B105-00805F49916B>...<XML_F52E2B61-18A1-11d1-B105-00805F49916B> <ProfileID ID="1"> <MAC>00:00:...:00</MAC> <MessageTypeID>2</MessageTypeID> </ProfileID </XML_F52E2B61-18A1-11d1-B105-00805F49916B>...
Show full article (2.69Kb)