-
I have a dynamic query with a hierarchical object model where we want to order records by the parent sort if it is a parent record, otherwise use a child sort. The query I have is this: Code: SELECT eme.[EMEntityID] , eme.[EMEntityCode] , eme.[EMEntityName] , eme.[Active] , ens.[EMEntityParentID] , eme...
-
Hi there, There appears to be an issue in ES2007.1.1210. I'm using ES to retrieve some data from SQL Server 2005, and one of the columns is computed using the cumulation of two UDFs. The SQL is as follows. Code: 1 SELECT 2 DISTINCT u.[UserId] AS 'UserId' , 3 ud.[Name] AS 'Name' , 4 dbo.DistanceBetweenPostcodes...