bitbucket-25253 (4/30/2012)

---

Steve thanks for scheduling another QOD that I had submitted.

And hey I want to brag a bit, well maybe not a bit, but a great deal, since...

No apology needed. Good rant, and good points.

Nice to see so many people enjoying their jobs. That's a good sign when we often hear in the media about people working too hard and not enjoying their work.

Lynn Pettis (4/30/2012)

---

Okay Steve, I submitted my QotD this morning. You may need to do some fiddling with the image. If you have any questions, drop me an...

Evil Kraig F (4/29/2012)

---

SQL Saturday out here in Phoenix was a lot of fun, and of particular interest I met a LOT of good people, including finally getting a chance...

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...