Register  Login  
  February 9, 2012  
Forum    
Forum Minimize
 
ForumForumDiscussionsDiscussionsSQLGridSelected...SQLGridSelected...Problems with DISTINCT in Primary QueryProblems with DISTINCT in Primary Query
Previous Previous
 
Next Next
New Post
 5/30/2010 2:37 PM
 

When I add DISTINCT to the Primary query, along with the Top Count enabled, I get an error:

Error on Primary Select: Incorrect syntax near the keyword 'DISTINCT'.

The SQL output is as follows:

PRIMARY SELECT:
Select
TOP 100 DISTINCT dbo.KB_XMod_ExtractFieldValue(InstanceData,'ContactName') AS Contact, T1.[XmodID], T2.[key], T2.[value] AS Category
From ....

Why is it not inserting TOP 100 after distinct?

Previous Previous
 
Next Next
ForumForumDiscussionsDiscussionsSQLGridSelected...SQLGridSelected...Problems with DISTINCT in Primary QueryProblems with DISTINCT in Primary Query

Print  

  Home | Blog | Forum | Subscriptions | Free Modules | Videos   Page generated in 0.454256 seconds.
  Copyright 2010 by TressleWorks   Terms Of Use | Privacy Statement