Ray K (2/22/2012)

---

Slight problem: I would be passing it the degree IDs, and I'd need to return both the degree and the person's name. (Sorry, I didn't specify that...

Thanks for the excellent setup. You're close, you just need to use grouping and having.

SELECT

p.ID,

p.[name]

FROM

#Degree

join #DegreeJct on #Degree.ID = #DegreeJct.DegID

join #People AS p on #DegreeJct.UserID = p.ID

where Deg...

sudhirnune (2/21/2012)

---

This is how the security is designed in the Sql server.

> Windows Group is created and added it as part of Login (SO that any user part of the...

One other piece of discussion that noone's brought up yet.

WHERE isnumeric(score) = 1

This cannot be trusted to go first. It's quite possible to end up with conversion errors...

Ow. Sorry to hear.

Execution Plans for both? Time to execution and statistics? Data volume of the core tables and sub tables, vs. resultant volume in the temps? Indexes?

The query itself...

David Walker-278941 (2/22/2012)

---

Is there any way to use the T-SQL language in a data transformation, such as a derived column transformation? T-SQL is not the world's best programming language...

Koen,

Thanks for the information. I think I puzzled out why the engine and not the component was complaining. Since the column wasn't mapped inside the component, the component...

If you drop the object to recreate it you...

Yeah, precisely the scenario...

I ended up forced to go to SSIS to enforce a table to table BULK with minimal. I can't for the life of me figure out a direct way...

GSquared (2/17/2012)

---

bitbucket-25253 (2/17/2012)

---

Way way back Virginia Tech was working on a system with a buried cable in each lane, a sensing mechanism on the front of your can, automatic steering...

Hey guys, I'm having trouble getting minimal logging with BULK to work via T-SQL. Can anyone who's more familiar give me a hand here: http://www.sqlservercentral.com/Forums/Topic1253552-338-1.aspx

ColdCoffee (2/16/2012)

---

I thought u wanted to have the table "mirrored" in the same server ; so i thought of passing along the back-up to the source server and restore it...

Boredom