Hi Peter, here I am again, I've mode some progress but I'm still stuck.
I've modified the Google XML Webpart, adding controls to select a query, a custom table, and a transformation. Now, the page succesfully loads as an xml page, and it is finding items in the table, but url portion created by information in the columns is empty.
What I get:
The transformation I'm using for my items is:
The QUERY on the table is asking for:
SELECT ##TOPN## * FROM (Select dbo.custom_MCHS_Physicians.NPI,
FROM dbo.custom_MCHS_Physicians INNER JOIN
dbo.custom_MCHS_SpecToPhys ON dbo.custom_MCHS_Physicians.NPI = dbo.custom_MCHS_SpecToPhys.NPI
As T Where ##WHERE##
I'm not very familiar with queries and I'm copying from other components already used in the site, so I'm not certain what else is missing or what I need to correct so that the columns data load in the transformation.