Concatenate Binary Columns of Diffrent Rows

Last Post 07 Jan 2008 04:20 AM by c9jad. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
c9jad
New Member
New Member

--
06 Jan 2008 01:54 PM
I need to concatenate binary columns of different rows based on the table key.

I have this right now.

DBCC DROPCLEANBUFFERS
DECLARE @segment_data varbinary(max)
SELECT @segment_data = [BCC-SEGMENT-DATA]
FROM BPSCLOS_PART2_TEST

SELECT @segment_data as segment_data


This does not take into account the key to my table.
c9jad
New Member
New Member

--
07 Jan 2008 04:20 AM
I needed to separate them for another process, but now need to put them back together. They do not need to be in any particular order except for the fact that only the rows for a certain key should be combined.
You are not authorized to post a reply.

Acceptable Use Policy