sql query
-
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...- Palak Shah
- Thread
- Replies: 2
- Forum: SQL Server
-
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...- sunsilk10
- Thread
- Replies: 2
- Forum: SQL Server