sorry...once your table #temp exists, i\BULK INSERT inserts into all columns....you can't identify the columns.

it should be this:

[font="Courier New"]BULK INSERT #temp1  FROM 'c:elson.txt'

            WITH

            (

               DATAFILETYPE = 'char',

               FIELDTERMINATOR =...

this example may be much more than you need.

This is very fast.

in my case, I had thousands of .txt files, all the same format.

they were distributed in 4 folders.

Each file...

Maybe you mean something like this?

this updates a table, and uses a SELECT to pull in relevant data from a select statement?

[font="Courier New"]

UPDATE SomeTable

SET SomeTable.BudgetAmount = X.BudgetAmount

FROM

(

SELECT ID,SUM(AMT)...

the issue is permissions, i'm pretty sure.

it doesn't matter which user you are logging into SQL server, whether domain admin,sa, or anyone else.

it's when you try to access services or...

I tried this and added acouple of different things, like timeouts and Content-Length to the headers...it made no difference...depending on the url it either failed witha 404, or the same...

I've had this snippet for a while, which i thought gets the number of processors on the server. this is the physical number of processors, and not whether they are...

awesome example michaela;

Still dealing with too much SQL 2000 here, and i wanted a nice working example to explore the new DDL trigger abilities.

I was able to read it,...

I had created a search proc I called "uglysearch", that found every varchar/char column, in every table, and searched for a specific string. similar to what you are doing, but...

i think this is just a result of spaces in the path/filename, right?

changing this part should work i think:

SET @folder = 'C:\Inetpub\wwwroot\Pergamum\Doc\International Banking\Caribbean'

SET @path =SUBSTRING(@folder ,...

sounds like you want the results of sp_who in a view for example?

simply sp_helptext sp_XXX, and read the code....maybe you can simply lift the code, or maybe you can convert...

you could also attach the spreadsheet as a linked server, and then select from it as well;

here's an example, which adds the linked server "MySpreadSheet", just change the path and...

it sounds like you are doing everything right...

here's a basic example of a select into:

select top 5 * into #Table1 from sysobjects

Select * from [#Table1]

that works fine on my...

doc_sewell (7/10/2008)

---

The problem is that our application needs to evaluate strings before they are submitted for processing. and these strings may contain variables, e.g.,

" select *from t where id...

I'm pretty sure that error 2147217873 is a foreign key violation;

ie

Error Code : -2147217873

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ForeignKeyName'. The conflict occurred in database 'DatabaseName',...

As you already suspected, In SQL2000, there's not much you can do.

If all your databases have the database recovery model set to "FULL" instead of "SIMPLE", you could use a...