ODBC Connections can be defined to use Integrated Windows Authentication. To simplify adminstration, individual users can then be added to Active Directory group(s) and those groups can be assigned SQL...

SELECT LEFT('21b',len('21b')-1)

You can flip the anchor and recursive portion. The anchor becomes any folder that contains a report. In the below example the CategoryLevel is inverted (level that contains a report...

select party_code,sum(inst_amt) as Total_instamt,

sum(case when paid_date < '27/11/2012' then paid_amt else 0 end) as Total_Paidamt

from @table1

group by party_code

WITH ReportCategoryList AS (

SELECT *, 1 AS CategoryLevel

FROM tblTestCategories

WHERE ReportCategoryID IS NULL

AND ID IN (SELECT ReportCategoryID from tblTestCategories)

UNION ALL

SELECT TC.*, RCL.CategoryLevel + 1

FROM tblTestCategories AS TC INNER...

= FORMAT(DATESERIAL(LEFT(MID("GA0120100466",7),2),LEFT(MID("GA0120100466",3),2),LEFT(MID("GA0120100466",5),2)),"MM/dd/yy")

- Susan