Is it possible to do this and generate a ResultSet? Or is it recommended to just use the existing proc with JSF/Seam/EJB3? thx.
SET NOCOUNT ON | declare @networkID varchar(50) | declare @seedHireLevel int | DECLARE @rptPARAM varchar(20) | | set @networkID = 'corp\btkach'[EMAIL PROTECTED] | set @networkID = right(@networkID,(LEN(@networkID )-5) ) | | SELECT | UserId | ,ISNULL(LEN(EmployeeID),0) AS [len_EmpId] | ,EmployeeID | ,FirstName + ' ' + LastName as FullName | ,Title | ,NetworkID | ,BillingLogin | ,(SELECT [A2VNAF] | FROM [coxDSS].[dbo].[ORG_CBURIDPF] | WHERE | [A2USER] = BillingLogin) as SecurityGroup | ,(SELECT | ABS([AUNUM2]) AS AdjAmount | FROM | [coxDSS].[dbo].[ORG_AUTUSRPF] | WHERE | [AUUSER] = (SELECT [A2VNAF] | FROM [coxDSS].[dbo].[ORG_CBURIDPF] | WHERE | [A2USER] = BillingLogin) | AND | [AUOPTN] = 'AA' | AND | [AUENTR] = 'Y' | AND | ABS([AUNUM1]) > 0) AS adjAmount | | ,(SELECT | [AUFUNC] AS AdjFunc | FROM | [coxDSS].[dbo].[ORG_AUTUSRPF] | WHERE | [AUUSER] = (SELECT [A2VNAF] | FROM [coxDSS].[dbo].[ORG_CBURIDPF] | WHERE | [A2USER] = BillingLogin) | AND | [AUOPTN] = 'AA' | AND | [AUENTR] = 'Y' | AND | ABS([AUNUM1]) > 0) AS AdjFunc | from coxIM.dbo.u_tbUser tbU | WHERE | HierarchyPath LIKE '%' + @networkID + '\' | ORDER BY | LastName View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4091209#4091209 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4091209 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
