Check out the snippet by Dale Joyce at this link:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1641735&SiteID=17

He's got an example using a .doc file with a format file.

Yes, it looks like the Word documents are altered; I've tried it successfully with JPG and PDF files, but not Word.

ishaan99 (4/21/2008)

---

I have a column with data as

00070111

0001111

00000111

00040111

00044111

000001111

I want a query which would get me all data preceding with 0's and ending as 1111. does anyone have a script...

slzbi (4/21/2008)

---

by comparing the original doc-file with the created file from bcp,

ther are only 2signs differnet in the beginning of the hearer.

when i delete them the doc-file will be correct.

may...

I had a similar situation recently. We use a shared datasource for each report project (containing multiple related reports), but sometimes data from another db on the same server is...

slzbi (4/18/2008)

---

Hi Folks,

i use the table Person.address from adventureworks.

i add a column "Datei" with the datatype varbinary(max).

Now i add a file like this:

Update Person.Address

set datei = (Select...

slzbi (4/21/2008)

---

Hi,

i tried the following:

bcp "select datei from Person.Address WHERE

addressid=1 " queryout "c:\TestOut.doc" -T -n -Slocalhost\AdventureWorks

but i got the following error message:

SQLState = 08001, NativeError = -1

Error = [Microsoft][SQL...

Mike Menser (4/18/2008)

---

Hey folks! Hopefully you can shed some light. I think I am going to need to write a trigger, but this is kinda new to me. I have...

According to Books Online, openrowset cannot export -- BUT you can use the command line bcp:

bcp "select datei from Person.Address WHERE addressid=1 " queryout "c:\TestOut.doc" -T -n

I just tried this...

Try the following syntax:

Use Test

go

EXEC sp_addlinkedserver 'ImportData',

'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0',

'C:\ExcelData1.xls',

NULL,

'Excel 8.0'

SELECT *

FROM ImportData...[EmployeeDataTesting$]

-- insert

INSERT INTO ImportData...[EmployeeDataTesting$] (Field1, Field2)

VALUES ('value1','value2')

Have you verified that the ODBC DSNs work? If you've got MS Access (or Excel) I think that's a good way to test the DSN.

Here's a solution with table and UDF DDL and example. Then you can use the function as a computed column if you wish, or just create a view and use...

Oop.. didn't realize it doesn't work on SS2000; I tried it locally on SS2005 SP2.

I'm pretty careful about always testing code before I post to the forums.

What's the difference between the warehouse codes B and M?

I'm not sure what's going on in your case, but you might have trouble with the temp table "#temp".. why not try a table variable:

create procedure dbo.GetTableSpaceUsed

as

begin

SET NOCOUNT ON

declare @Space...