select top 2000
		master.dbo.fn_FieldDec(DataElement048, master.dbo.fn_EncPwd()) as DE48,
		lr.ExchangeId, lr.LogRulingTimeStamp,lr.MessageTypeIndicator as MT,
		master.dbo.fn_FieldDec(DataElement002, master.dbo.fn_EncPwd()) as DE02,
		OutputDescription,
		master.dbo.fn_FieldDec(DataElement035, master.dbo.fn_EncPwd()) as Track2,
		master.dbo.fn_FieldDec(DataElement045, master.dbo.fn_EncPwd()) as Track1,
		DataElement003 as DE03,
		DataElement004 as DE04, DataElement005 as DE05, DataElement006 as DE06,
	    DataElement007 as DE07, DataElement009 as DE09, DataElement010 as DE10,
		DataElement011 as DE11, DataElement012 as DE12, DataElement013 as DE13,
		DataElement014 as DE14, DataElement015 as DE15, DataElement016 as DE16,
		DataElement017 as DE17, DataElement018 as DE18, DataElement019 as DE19,
		DataElement020 as DE20, DataElement022 as DE22, DataElement023 as DE23,
		DataElement025 as DE25, DataElement026 as DE26, DataElement028 as DE28,
		DataElement029 as DE29, DataElement032 as DE32, DataElement033 as DE33,
		DataElement035 as DE35,
		DataElement037 as DE37, DataElement038 as DE38, DataElement039 as DE39,
		DataElement041 as DE41, DataElement042 as DE42, DataElement043 as DE43,
		DataElement044 as DE44,
		DataElement044 as DE44,
		DataElement047 as DE47,
		DataElement048 as DE48_2,
		master.dbo.fn_FieldDec(DataElement048, master.dbo.fn_EncPwd()) as DE48,
		DataElement049 as DE49,
		DataElement050 as DE50, DataElement051 as DE51, DataElement052 as DE52,
		DataElement054 as DE54, DataElement055 as DE55, DataElement056 as DE56,
		DataElement057 as DE57, DataElement058 as DE58, DataElement059 as DE59,
		DataElement060, DataElement061, DataElement062, DataElement063, DataElement070, DataElement090, DataElement091, DataElement095, DataElement096, DataElement100, DataElement101, DataElement102, DataElement103, DataElement104, DataElement105, DataElement110, DataElement111, DataElement112, DataElement113, DataElement114, DataElement120, DataElement121, DataElement122,
		master.dbo.fn_FieldDec(DataElement123, master.dbo.fn_EncPwd()) as DE123,
		DataElement124, DataElement125, DataElement126, DataElement127, RestrictionId, CaseInitiator, LastLawId, Error, ErrorLawId, LogRulingID, AssociatedRulingId
		--mem.MemberID
from	dbo.LOG_RULING lr with (nolock)
--inner join dbo.RT_EVENT_FINANCIAL ref with (nolock) on lr.ExchangeId = ref.ExchangeId
--inner join dbo.MEMBER mem with (nolock) on mem.MemberEID = ref.MemberEID
where
LogRulingTimeStamp > '2009-09-10'
order by LogRulingTimeStamp desc