I'm going to say no it doesn't meet the requirements for Step 1 and here's why.

If...

ChrisM@Work (4/3/2013)

---

Thanks for the ddl and dml, it makes a real difference. I'd recommend you split this into two steps. It will make the end result easier to understand, test...

I'm in the process of testing the queries supplied by Rals and Chris.

I'll post back my findings.

Thanks again everyone,

Sqlraider

vinu512 (4/2/2013)

---

Is there a relationship between the "Attend" table with the "Terms" table??.....

By what you have shown in the Expected Output it sure seems there is but its not visible...

Not sure what you are asking here. You get the EndDate (Date datatype)...

Grant Fritchey (3/25/2013)

---

Sqlraider (3/25/2013)

---

Grant Fritchey (3/23/2013)

---

In addition to backups, if you're developing the databases, I'd get the source for the structures and code into a source control management system. I'm...

Grant Fritchey (3/23/2013)

---

In addition to backups, if you're developing the databases, I'd get the source for the structures and code into a source control management system. I'm pretty sure there...

David Webb-200187 (3/22/2013)

---

Just for ease of use and potentially quicker response, I tend to script out things like logins, database users, procs, triggers, and views that I might need to...

Shawn Melton (3/22/2013)

---

This can depend on how you document your systems. You do document them right? 😀

I support a branch of the military, and the organization I support right now...

Thanks, I was...

I use Simple and do a Full backup each night. I also import the daily changes into a seperate database in Simple mode and do a Full backup each night...

I wanted the empty string.

Thanks this works.

But if you are keeping personnel info & you have storage issues the 'date' format is the way to go IMHO.

No one hardly ever puts the 'time' in on...

This gets me the desired results.

Thanks...

drew.allen (9/28/2011)

---

It's because you're doing a string comparison. For example, since the character '4' comes after the character '2', any string that begins with a '4' is greater than...