Not sure about this answer. I tried querying the table and go a "permsission denied" response. I have standard developer rights on the server but no admin rights.

Named Pipes is a Microsoft network protocol. TCP/IP is the standard used on the internet. Non-MS networks need to have it installed in order to communicate with SQL...

Try reprocessing the dimension in the dimension editor. If it's valid then you should be able to see the data. Some dimension errors do not necessarily prevent a...

I actualy tried this syntax on my own db in a case where there would be ties. I got only one row back. When I changed the "top"...

The reason is probably because my method involved the creation of objects and disk io, his didn't.  I'll file this away for future reference.  Thanks for the reply.

If the reason for the large size of the where clause is the number of values being compared, i.e. you have a large "in" comparision, you might consider moving the...

You might also want to check the date values you are trying to insert.  In DTS a date is valid as long as it consists of a valid year/month/day combination. ...

What driver are you using for the ODBC connection?

Like I said, its a lot easier to do this in SQL Server.  First the code above won't return the proper data.  You don't want a row count you want...

I've tried to do this in DTS.  Unless you really want to learn a lot about VBA its not worth the trouble.  Its much easier to use xp_sendmail.  Create a stored...

Are you sure about this answer?  T-SQL help on the subject of NewId says that it creates a unique identifier.  Since the help also says that the id created is...

If you have access to SQL Administrator, use the package designer.  It contains a text file icon which you can use for this purpose.  If you don't find someone who...

As a SQL/Database developer my response would be to request addtional information.  The "results not as expected" condition may or may not indicate a problem with the code.  The first...

  Thanks, thats the answer I was hoping for.

I'm not sure what "0-0" means.  If your demonator is a variable or a computation involving variables than you can then you can do somthing like this:

delcare @res int (I assume...