Thanks for the quick and helpful answers guys!
I just found another fast way to do this too:
SELECT STUFF(( SELECT ',' + X + ',' + Y
FROM Points
FOR
XML PATH('')
), 1, 1, '') AS XYList
Credit goes to this guy:
Related Contents:
- Functions vs Stored Procedures
- Get week day name from a given month, day and year individually in SQL Server
- CONCAT’ing NULL fields
- Saving changes after table edit in SQL Server Management Studio
- How to update Identity Column in SQL Server?
- Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
- How to export all data from table to an insertable sql format?
- Multi-statement Table Valued Function vs Inline Table Valued Function
- Copy data into another table
- How to check existence of user-define table type in SQL Server 2008?
- Best way to do nested case statement logic in SQL Server
- DISTINCT for only one column
- TSQL Pivot without aggregate function
- SQL Server: Get table primary key using sql query [duplicate]
- SQL Server indexes – ascending or descending, what difference does it make?
- Case in Select Statement
- What is SYSNAME data type in SQL Server?
- SQL Server 2008: How to query all databases sizes?
- Add a column to existing table and uniquely number them on MS SQL Server
- How do I find duplicates across multiple columns?
- varbinary to string on SQL Server
- How to group by month from Date field using sql
- Partition Function COUNT() OVER possible using DISTINCT
- How to determine the number of days in a month in SQL Server?
- How to dump a Microsoft SQL Server database to a SQL script?
- Difference between language sql and language plpgsql in PostgreSQL functions
- Should every SQL Server foreign key have a matching index? [closed]
- What does a transaction around a single statement do?
- What do you do in SQL Server to CREATE OR ALTER?
- SQL Server silently truncates varchar’s in stored procedures
- Get Multiple Values in SQL Server Cursor
- How do I find the data directory for a SQL Server instance?
- CASE WHEN statement for ORDER BY clause
- SQL Server – How to lock a table until a stored procedure finishes
- What is the purpose for using OPTION(MAXDOP 1) in SQL Server?
- SQL – How do I get only the numbers after the decimal?
- Unique key vs. unique index on SQL Server 2008
- Know relationships between all the tables of database in SQL Server
- Singular or plural database table names? [duplicate]
- SQL query question: SELECT … NOT IN
- SQL performance on LEFT OUTER JOIN vs NOT EXISTS
- How to set multiple values inside an if else statement?
- Joining a list of values with table rows in SQL
- NOT LIKE and LIKE not returning opposite result
- SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
- store arabic in SQL database
- Incorrect syntax near ”
- Add unique constraint in SQL Server 2008 GUI?
- How to insert an empty line to SQL table? [duplicate]
- is not a recognized built-in function name