Posts tagged Comma-Delimited Output
Comma-Delimited Output (SQL Server)
May 2nd
Using Query 1: USE Northwind 2: GO 3: 4: DECLARE @CustIDs VARCHAR(8000) 5: SELECT TOP 10 @CustIDs = ISNULL(@CustIDs + ‘,’, ”) + CustomerID FROM Customers 6: SELECT @CustIDs 7: GO Using Cursor 1: DECLARE cCustomerIDs CURSOR FOR 2: SELECT [CustomerID] FROM [dbo].[Customers] ORDER BY [CustomerID] 3: DECLARE @CustomerIDs VARCHAR(8000) 4: DECLARE @CustomerID VARCHAR(10) [...]
