To Shaun,

I don't believe I missed the whole point.

I may have mistyped.

the general idea is that in a constrained environment, there are ways at updating the extra bits of data,...

These are Important Ideas even more so today, as Enterprise Data is growing. My concern with the solution is that you are inserting rows to the table, and I don't...

I believe that 2 also is the most correct, and I believe that the Logical "AND" of month and day is the problem. If the Day portion is greater than...

I think there has been a dangerous tendency to make things human readable, and I would argue that storage and retrieval should be optimized for the computer that is doing...

Specifically,

Are you running the SQL service as a domain user, or as system? You may be running as SA when you use Query Analyzer, and something else under the SQL...

Microsoft SQL 2000 Enterprise Manager will convert this syntax into join syntax

 "contains join operators *= or =* "

it will also convert all possible where clauses with Table1.columnX = table2.columnY into joins as well.

(not...

Why would anyone ask for young? key word for inexpensive? In many cases it is illegal to post job offers that discriminate, perhaps others can comment on the rules for...

It is very nice to have a concise overview of text functions and handling. Well done!

There is a serious concideration with regards to triggers, however, since Text columns cannot be...

See if you can create a UDL that has the password then use the UDL for your DTS Connection. See the following Article on How to...

http://www.databasejournal.com/features/mssql/article.php/3100661

Cheers,

John R. Hanson

Hi Jim P.,

If you just follow the DTS Import Wizard in SQL 2000, use the text provider for the source (NOT EXCEL for CSV!!), point to your CSV file, then...

the Original Query worked fine, but that wasn't an option.

I would change the Select to use the datalength so that you get the whole thing as follows:

BEGIN TRAN

DECLARE @ptrval varbinary(16)

Declare...

Hi Ray,

Our Group was loathe to install DTS on the clients, because the jobs will run in the context of the client. We like to keep things on the Server,...

Well Sam

I would also avoid the Dynamic SQL and instead use a User defined Function which does the parsing and the loading into a table in one step. First the...

More on the DTS subthread,

you can export the (ANY) DTS job as a visual basic file, then create an active x dll by referencing the Microsoft DTS Package Object Library and...