it might be interesting to find data in the table that does not match it's supposed details:

does this return anything?

SELECT * FROM TokenManager

FULL OUTER JOIN

(SELECT CustomerID SUM(NumTokens) AS NumTokens...

well, first,

I've always tried to get rid of any tables that were trying to hold summary data with a view. it does away with needless updating.

i think based...

from a development standpoint, multiple instances are great for testing; I've had SQL7 as a default instance, SQL2000 and 2005 as named instances, all on the same machine. helpful if...

that is caused by the row terminator:

[slash]n is CrLf, which is found a lot.

try [slash]r which is just Carriage Return, which is common from UNIX type data sources.

i think it's parenthesis around the @sql....exec(@sql)

this works on my machine:

DECLARE @sql VARCHAR(8000)

DECLARE @path VARCHAR(255)

SET @path='c:[slash]nelson1.txt'

SET @sql='BULK INSERT nelson_test1 FROM ''' + @path + ''' '

...

also something else to consider;

wouldn't the where statement where len(a.NDC) > 0 force a table scan on the Reorders table in order to calculat ethe length of the field?...

[font="Courier New"]--all the columns must exist in the table...bulk insert doesn't let you choose.

--if the data was structured like this:

--1.0" 5.1" 5.1" 1.4" .2

--1.0" 5.1" 5.1" 1.4" .2

DROP TABLE nelson_test1

--i'd...

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...