Is it worth it?

we have a similar set up and found it necessary to test the scenarios on a smaller subset. where indexes are place may partially have to do with the qrys...

Just my limited world view but if anything i think companies are going to scared into NOT buying anything unless they are forced to. Money is still an issue for many and at...

It might be helpful to post what you have even if you believe it to be wrong.

So If i read this right a code with 9 records would be divided between the first three but a record with 10 would be divided between the 4?

--step 1...

Your syntax looks fine. [id] must be in the result set in order to do a join.

I don't know if this will help in your situation or not but i had a similar problem with ssns. I used a combination of truncation and soundex to find...

Oh - I see what you are saying. I use that all the time on my personal computer for SS and Mysql but at work Tsql is not considered programming so...

Thank you for your help.

I am checking on the first. Where do you turn on the Debug SQL flag?

Nevermind - Yes you can. There is a section on this in a book called SQL Server XML Distilled (curlingstone press)

Essentially use...

I'm a newbie too - so maybe someone knows different. You can't do it with Bulk Insert Task. You can do an xml Bulk insert with SQLXML bulk load though.

Try this:

DECLARE @n int

SET @n = (

SELECT min(no)

FROM test

)

WHILE @n is not null

BEGIN

SELECT * FROM test WHERE no = @n OR no = @n + 1

/** Choose: (wasn't...

If you have some sort of date or identity col you could use a dynamic task to assign the max value to a global variable before the insert.

The...