Prev: SQL Globalization / Localization
Next: Display of DATE format in Management Studio
From: Erland Sommarskog on 7 Oct 2009 18:06
Cathy (cathywigzell(a)yahoo.co.uk) writes:
> In SQL Server 2005, I have a varbinary(4000) column which contains a
> 60 element float array. Using SQL (or similar) how can I extract the
> contents of the varbinary and print out the data as 60 floats? Each
> float has a precision of 9 decimal places.

First you need a Numbers table:
http://www.sommarskog.se/arrays-in-sql-2005.html#tblnum

Then look at the fixed-length method in the same article:
http://www.sommarskog.se/arrays-in-sql-2005.html#fixed-length

And finally:
http://www.sommarskog.se/arrays-in-sql-2005.html#tablelists

This should get you going.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

First  |  Prev  | 
Pages: 1 2
Prev: SQL Globalization / Localization
Next: Display of DATE format in Management Studio