sql server

dreamwrox · #1 (**permalink**) 12-01-11, 03:56

i want to display the following output where integer value is column data.

{[Advertiser].[AdvertiserKey].&[4000],
[Advertiser].[AdvertiserKey].&[4001],
[Advertiser].[AdvertiserKey].&[4002],
[Advertiser].[AdvertiserKey].&[4003],
[Advertiser].[AdvertiserKey].&[3661],
[Advertiser].[AdvertiserKey].&[3662]
}

PracticalProgram · #2 (**permalink**) 12-01-11, 04:47

Are you asking for permission?

dreamwrox · #3 (**permalink**) 12-01-11, 04:52

No I am asking the function or SP to get this output

r937 · #4 (**permalink**) 12-01-11, 08:16

Quote:

Originally Posted by dreamwrox

No I am asking the function or SP to get this output

where is the output supposed to come from?

Wim · #5 (**permalink**) 12-02-11, 12:03

Is this what you are looking for?

Code:

DROP TABLE #DaTable
CREATE TABLE #DaTable(
	aNumber	INT	NOT NULL
)

INSERT INTO #DaTAble(aNumber) VALUES
(4000),(4001), (4002), (4003), (3661), (3662) 

DECLARE @T VARCHAR(MAX) ;
SET @T = '' ;

SELECT @T = @T + '[Advertiser].[AdvertiserKey].&[' + CAST(aNumber AS VARCHAR) + '],' + CHAR(09) + CHAR(10)
FROM #DaTable

-- Remove last comma and CR/LF'
SET @T = LEFT(@T, len(@T) - 3)
-- Put the result between '{' and '}'
SET @T = '{'  + @T + '}'

PRINT @T

Internet Services

Web Development

Digital Marketing

Consumer Tech