sql query

  1. P

    How do I optimise the query

    Hello folks, I have prepared one query, but I feel this can be even more optimised! But I'm not sure what can be done Query SELECT TOP 10 * FROM ( SELECT co.orderid, co.orderStatusId, co.paymenttransactionstatusid, ( SELECT...
  2. S

    SQL to build point arrays

    Hi I have a link and a node SQL Server table as below. I need to build a number of lines using the node and link tables. Non-vertex nodes denote end points of the line. In C# I possibly need build a dictionary of coordinates for each line. Any suggestions what would be the best way to...
Top Bottom