Thinky Night (4/27/2012)

---

declare @Table table (name varchar(15),cnt int,value int,xString varchar(16))

insert into @Table values ('00025#',4,250,'Pedro'),

('00027#',10,40,'Marco')

SELECT

n.RowNum,

Image.name

into Test2 --initial insert

FROM (

SELECT name,cnt

FROM @Table

) Image

CROSS APPLY (

SELECT TOP (cnt) RowNum = ROW_NUMBER() OVER(ORDER...

You are welcome,...

Yes, you need your versions to be close, or to match. You can install only client tools from the media, however if these are both SQL Server 2005, likely you...

Enjoy, and view it as an opportunity. I did a little MySQL work years ago, and it was fine. Works well as a base engine, some differences, but it's the...

So I'm confused. Did you use SSCM or do the steps listed?

You should use Configuration Manager as is handles the security needed if you change accounts.

Every version needs to accounts...

Are you executing this in a command prompt? BCP doesn't run in SSMS.

Is this a one time operation or something run regularly? If it's the former, I might do a cursor and let it look inside based on the number of products.

If...

Does this help: http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html

You could try upgrading them to SSIS: http://www.mssqltips.com/sqlservertip/1224/upgrade-sql-server-dts-packages-to-integration-services-packages/

Probably early...

analoglife23 (4/27/2012)

---

Anyway - I'll be leaving this work and changing my career as soon as my debt is paid off. I don't care how much money I make, as...

Jim McCoy-259251 (4/27/2012)

---

...

Believe me it is definitely less stressful and maybe I will retire from this job some day, just not sure when that day will come as I...

Jeff Moden (4/26/2012)

---

Wow! Seriously??? Who checks these things before...

I received an apology from the author. I suspect it was a lack of understanding, and plan to let it go.

Took the words out...

Flip this to a SELECT or run your subquery for a range of data and see where you return more than one row. The error you mention is exactly the...