Hi,

I have som difficulties getting the @createDate from the node when getting member information with SQL, when I try to use jesper.sql in XSLT. Either I get the whole node or nothing at all. Here is the SQL I have used:

SELECT 
  CAST(x.xml AS XML).query('/node/data[@alias="isActive"]') AS isActive, 
  CAST(x.xml AS XML).query('/node[@createDate]') AS generatedDate,
  CAST(x.xml AS XML).query('/node/data[@alias="compEmail"]') AS compEmail, 
  CAST(x.xml AS XML).query('/node/data[@alias="compApprove"]') AS compApprove
FROM cmsContentXml AS x 
INNER JOIN cmsMember AS m ON x.nodeId = m.nodeId

What can I do to make it work. The only thing I need from the <node> is ex <node ... createDate="2010-07-17T13:34:36" ...>...</node>

Hope someone can help me out here :)

Kind regards,

Niels