Glad you got your answer. Thanks for doing that, Eirikur. 🙂

Shaun2012 (7/24/2014)

---

Hello All,

I am using sort on two tables before using merge join but it is effecting the performance. I am loading aroiund 1 millions records and taking enormous...

Sorry I fell off this discussion a bit.

How does adding 1,000,000 rows at once in a single insert differ from adding them 1,000,000 times in a loop if you want...

sqlvogel (7/25/2014)

---

I think students new to databases would be well advised to stay away from Access until they know what they are doing. It ought to be considered an advanced...

The second piece is a CTE Tally Table. If you just need a list of 1 through 5, that's usually faster than accessing a random table, particularly since you...

It's late but I just wanted to drop a note. You're not forgotten, I'm just overloaded the past two days. I'll try to get to this tomorrow if...

Ah,...

Have you already converted content_document to type TEXT before attempting that? Otherwise, you're attempting to append "0x" to a binary value, which it fails. If you're trying to...

You misunderstand. You're using apostrophes...

windows_mss (7/24/2014)

---

Hi Evil,

Thanks for your reply, when i prepend 0x in script it's working. But when i tried the same in SSIS using derived column I'm getting exception(i have attached...

mallikachowdhary 98955 (7/24/2014)

---

I have a job defined in SQL server 2008 which runs a stored procedure of select query which fetches around 230000 rows . One one server this job...

You lack research, young padawan. Let us show you where you errored.

so we decided to create a...

An older article of mine, but it may help.

http://www.sqlservercentral.com/articles/Career/71608/

That said, it's in the perceptions of the bestower to decide if a title is worth it for a person. Said...

Just a confirmation before I attempt to recreate the issue, please confirm you're actually in 2k5 and didn't just post on the wrong board.

I'd say the majority, if not most, of the main posters on this site are self-trained and have taken specific training courses, but not a full degree. Hopefully someone...