0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

DECLARE @testTable TABLE
(
    [ItemIdx] int,
    [ChunkIdx] int,
    [BinaryData] varbinary(8000)
)
INSERT INTO @testTable ([ItemIdx], [ChunkIdx], [BinaryData]) 
VALUES (1, 1, 0x00110001), (1, 3, 00110001), (1, 2, 00110001);

INSERT INTO @testTable ([ItemIdx], [ChunkIdx], [BinaryData])
VALUES (2, 1, 00110001), (2, 3, 00110001), (2, 2, 00110001);



/*SELECT * FROM @testTable;*/
SELECT CONVERT(VARCHAR(MAX), 0x4E616d65, 2) AS ttttttttt;
SELECT CONVERT(VARCHAR(1000), BinaryData,2) AS  [text()] FROM @testTable t2

/*SELECT DISTINCT ItemIdx, CONVERT(BINARY(MAX),
       (
         SELECT CONVERT(VARCHAR(MAX), BinaryData,2) AS [text()]
         FROM @testTable t2
         WHERE t1.ItemIdx = t2.ItemIdx
         ORDER BY ChunkIdx
         FOR XML Path('')
       ),2) AS Data
FROM @testTable t1;
*/

fork query

edited jul 23 19

created mar 2 16 anonymous