sql server - Identifying the unique values that form part of a SQL sum query -

-

I have 2 questions that I would like to work together:

1) A question of geometry The number is within a certain distance of another and the result is only where the count is more than 6 digits;

2) A query returns unique IDs for all points within that distance (without any counting and without at least records)

I generate a single query All (and only) records are expressed in the first query, which will be t2 from the new_ref table. (Ideally the output will be in the form of columns in one line, but at the moment I can get the records listed against several rows in the same column, so this is my first objective and I leave the pivot bit later).

Obviously, the system is identifying the record to count them, so I think it is possible to ask which records are they? |

The second question rejects the result. Should I structure it as a sub-query and if so, how do I do it?

The question is 1: 

  DECLARE @radius float = 50 SELECT t1.new_ref, t1.hatrisref, SUM (case when t1.geolocation.STDistance (t2.Geolocation) And lt; = @ radius then 1 other zeros) Group size 'Table 1 to T1, Table 1 T2, WHERE [t1]. [[new2ref]! = [T2]. [New_f] Group by [T1]. [New_fiber], [t1]. [Hatric] HOWING SUM (In case T1. Zolocation. STDSTANCE (T2 geolocation) and LT; = @ RDS 1 rest 0) Order order by [T1]. [New_f], [T1]. [Hatric]   
 query is 2:  
  select float = 50 as radius @ radius, t1.hatrisref, t1.new_ref, t2. From new_ref to Table 1 T1, WHERE [t1] as Table 1 T2. [New_ref]! = [T2]. [New_ref] and t1.geolocation.STDistance (t2.Geolocation) & lt; = @radius GROUP BY [t1]. [New_ref], [T1]. [Hetricef], T2. EnVE_f ORDER by [T1]. [Haatrisf], [T1]. [New_f], T2  
    
 
 
 Yes, a sub The query will work:  
  SELECT ... from table 1 to T1, T2 as WHERE t1.new_ref! = T2.new_ref and t1.geolocation.STDistance (t2.Geolocation) & lt; = @radius and 5 & lt; (Select number (*) Table 1 to T3 WHERE t1.new_ref! = T3.new_ref and t1.geolocation.STDistance (t3.Geolocation) & lt; = @radius)

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more