You could always store the document(s) in a file and store the file path/name in the database. Kind of a universal solution for all RDBMS's...

Well... that's a mighty nice gesture. Thanks...

I do have a couple of things to share...

http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/

If you were to dump the data into a Temp Table with an IDENTITY column, you're life would get a lot easier on this problem.

We do the double check thing for every piece of SQL that hits the database in the form of Peer Reviews. It's prevented a good number of "accidents" before...

Heh... Denial is a good word for this... 😀 I've seen lot's of folks try to make test data this way... Cross Join would suit better for that.

Here's one of my favorites to go along with that...

declare @A decimal(3,0), @B decimal(18,0),@F FLOAT

SET @A = 3

SET @B = 3

SET @F = 3

SELECT 1/@A*3.0, 1/@B*3.0,1/@F*3.0

SELECT 1/@A*3, 1/@B*3,1/@F*3

Heh... I've got 100 PM's that I really want to keep... and Steve hasn't developed a way for me to download them, yet and I've been too busy to think...

Oh yeah... I forgot the "other part"... Dirtree...

Lots of people know that Dirtree can take 2 parameters... one for Directory and 1 for how many levels deep to go... Very...

Found 'em...

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\Temp\OpenRowSetTest2.xls;HDR=yes',

'SELECT * FROM [Sheet1$a4:c]')

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\Temp\OpenRowSetTest2.xls;HDR=Yes',

'SELECT LastName,FirstName FROM [Sheet1$a4:c]')

... and I've attached the example spreadsheet I used in the...

C'mon... don't be shy... everyone else posted their solution... it's your turn... 🙂

Get something that's capable of opening the file in the "binary" mode... I'm betting that the end of line character is neither a carriage return (0d in hex) nor a...

So... are you required to use the ZipCode/State view? If not, call the tables directly, instead. Also, Views of Views generally suck the life out of code... avoid...

jcrawf02 (6/17/2008)

---

My manager has been fighting with our corporate folks to try and get us a dedicated environment where we can build our own tables and test suites, this may...

OpenRowSet does this very nicely... and with a little help from our friend "Dirtree", you can make it "auto-magic". Lemme see if I can find my sample script for...

Good point... but look again...

insert into t

select *...