Re: looooooooong record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Then I'd use varbinary(max).

"Empi" <mpeleg@xxxxxxxxxxxxxxx> wrote in message news:uWNs#O1#JHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
No need to search.
middle tier app.

Thanks!


"Peter DeBetta" <debettap hotmail> wrote in message news:BA87E2FC-0B24-4FDC-AC3B-AEB8ECD5731C@xxxxxxxxxxxxxxxx
Without knowing more, varbinary(max) and a function to extract the individual value would work, or better yet, a user-defined type with a built in method to do this.

Do you need to do anything else like search for one of the 2-byte ints within the column?
Who will consume the data (other T-SQL or only a middle-tier app)?


--Peter

"Empi" <mpeleg@xxxxxxxxxxxxxxx> wrote in message news:uu$Bx4x#JHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
Hi.

I need to store a record with 16 fields, each with up to 360,000 values of a 2 bytes integer.
Storing each value in a field is quite a crazy idea(value1,value2,...,value360000),
so, I wonder. I thought of storing each sample in a huge string with comma as delimiter and parse it each time I need it.
Is there a better way?
Can I store a filled object such as arraylist in a table as is and fetch it?

Thanks.

Empi




.