Brandie Tarvin (10/3/2013)

---

And does this document help? I found it searching on "SQL 2005 licensing structure" but couldn't get an actual link (nor find it on Microsoft's website even though...

You may want to look at BULK INSERT:

http://msdn.microsoft.com/en-us/library/ms188365(v=sql.110).aspx/html

My Google-fu is failing me. Any help here would be greatly appreciated.

enriquezreyjoseph (10/2/2013)

---

Jeff Moden (10/2/2013)

---

If it's strictly an ETL...

Sean Lange (10/1/2013)

---

haha. I picked the band, the food and the tuxedos. Other than...

I really hate to rain on everyone's parade but it isn't necessary to use a CASE to accomplish what is asked.

Please look at the solution I posted in my original...

I'm kicking myself for taking Brady instead Peyton Manning. I had a choice between them both.

Jack Corbett (9/30/2013)

---

Jeff Moden (9/28/2013)

---

GilaMonster (9/28/2013)

---

Jeff Moden (9/27/2013)

---

Speaking of "Are the posted questions getting worse"?... I was going through some old responses to some posts and I came...

Have you tried what I posted earlier?

Bhuvnesh (9/30/2013)

---

use msdb

select 'ALTER LOGIN [' + name + '] WITH DEFAULT_DATABASE = YOUR_DB; ' from sys.syslogins where language = 'us_english'

...

I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!

Well, my oldest daughter is in the hospital. She is having her second baby boy!!

ssurekha2000 (9/27/2013)

---

i have a SP with where condition

as where id=@id and month=@month and Eid=@Eid

wht i need is if @Eid=0 i need to display all the reocrds

if Eid>0 then display...

Okay, then based on the info above, your code...

What are the correct data types for the following columns:

sexID

statusID

firstname

middlename

lastname