One other suggestion, I'd use SSIS over DTS especially since you're trying to move data to 2005.

I'm largely piling on at this point, but what the heck...

Yes, seperate the databases by customer and seperate them by module as well. If possible isolate by instance or use...

I was thinking the same thing, but I did some searching Integer8 and it's actually a 64 bit value. I'm not convinced you can put it into a BigInt, but...

You are posting your questions to the 2005 TSQL forum. Any answers are likely to contain syntax that won't work in 2000. That's...

The first two messages are lower level messages that are not a part of the TSQL statement, but are occurring at a lower level within the system. The CATCH statement...

I'm sorry, I've got nothing that shows how to convert from the 64bit Integer8 data type into anything in SQL Server within TSQL.

You may have a perfect opportunity to...

Good one. I hadn't thought it through that far.

Unless...

Sorry that wasn't helpful.

You've got a lot of very odd restrictions on how you can do this work. Why is the behavior so peculiar?

However, if you must have 30...

If I understand the problem correctly, what about:

CREATE PROCEDURE x

(@ParamList XML)

AS

DECLARE @iDoc int

EXEC dbo.sp_xml_preparedocument @iDoc OUTPUT, @ParmList

INSERT INTO dbo.MyTable

(Id, Value)

SELECT

(Id, Value)

FROM OPENXML(@iDoc, '/MyParameterList',1)

WITH(Id int '@Id',

Value varchar(50) '@Value')

EXEC dbo.sp_xml_removedocument @iDoc

GO

That will...

Please don't cross-post the same question.

http://www.sqlservercentral.com/Forums/Topic408403-338-1.aspx

And I agree with the initial response.

Maybe I'm confused by the question, but are you looking for a SELECT statement? Something like:

SELECT o.OrderId

,o.Custermer

,d.ProductId

...

Most systems do some form of option #2. The main reason being, reporting. Your basic report engine just isn't going to be able to figure out the bit mask the...

You should look at the number of scans and reads each one is doing. Time is nice & all, but for most queries, reducing scans or reads leads to reductions...

It is possible, but as Colin has noted, it's definitely not the right approach. If you were to try it, the trick would be to only use a single parameter,...