Yes, I believe so.

ghelyar (5/16/2008)

---

I have a library for my application's use in ASP.net (C#) for 2 versions. The library can handle the rather complex conversion already and I would rather use that...

Crud, I got two problems mixed up.. just talked with my DBA on the phone... she says that the Bulk Insert to TempDB problem is because of the Windows Authentication...

No, I sure don't. All I have is an email from my DBA when I ran into the problem when we switched to windows authentication. I'll see if...

robertcaustin (5/15/2008)

---

Thanks to all the replies but I think my logic and reasoning is the opposite to normal programming. I live inside SQL and only write or use outside programs...

Very cool, JackO... that's very good to know. Thanks for posting your findings.

If ya wanna have some fun, make as much performance improvement as you can to the first query found at the following URL... result must be functionally identical to the...

GilaMonster (5/13/2008)

---

Agreed. There are legit cases to store just one...

Welcome aboard, Mark,

Hey... since you're a "newbie", take a look at the URL in my signature line. It'll help you and folks like me a lot in the future.

On...

I have no idea why MS does certain things. 😛

Just curious, what does the CLR do?

Will DOugherty (5/15/2008)

---

I know this is a forum by and for SQL Server bigots but there is also the possibility that those of us who are strong in the .Net...

I can't actually blame them... they look at all the different forums and think they stand a better chance of...

Cool! Show us the code that proves it because non of the rest of...

Yes... it's possible... give it a whirl.

I'd recommend you post the code... I've not seen Order By in an execution plan with so many columns ever before.