August 31, 2010 at 1:55 pm
I am trying to use a CTE to STUnion together several geography LineStrings. I'm not having much luck. I'm pretty sure that I can do this in a "WHILE...LOOP", but just wanted to see if a CTE would do it. Has anyone tried this before?
August 31, 2010 at 2:35 pm
Keith,
Your description of the problem is too vague to be able to answer.
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put some test data into those tables that shows your problem will go a long way in getting people to look at your issue and help you out. Please include code for what you have already tried. Don't forget to include what your expected results should be, based on the sample data provided. As a bonus to you, you will get tested code back. For more details on how to get all of this into your post, please look at the first link in my signature.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply