Something like this?

case when getdate() < TermStart then 'R'

when getdate() > TermDate and getdate() < Term then 'C'

when getdate() > TermEnd then 'H'

else 'X'

end

Ed Wagner (6/20/2014)

---

Sean Lange (6/20/2014)

---

braces (also different meaning in UK and...

braces (also different meaning in UK and US English). 😀

You're welcome. Glad I jump in late and help. 😛

GrassHopper (6/20/2014)

---

Only 1 thing i just noticed.

in my loop I declare the @SEQ. I use this to give me the starting number. So if I want to start...

The crazy amount of spam lately has been quite shocking. Thank you for staying on top of it. It is challenging to deal with this sort of thing and not...

trapnell (6/20/2014)

---

I need a query or procedure which will take FIRST_NAME, MIDDLE_NAME, and LAST_NAME as inputs and produce a list of similar names.

For example, 'Thomas', 'Woodrow', and 'Wilson' would produce...

I know what you mean there. I can...

barry 50045 (6/20/2014)

---

using t-sql, where and how would the connection to the access db be? Is there any way you could give me an example? Please believe me,...

Chord77 (6/19/2014)

---

Possibly, but the more I talk to the people on the team I think it was a misunderstanding/miscommunication.

During the morning meeting with a few of the...

Mile Higher Than Sea Level (6/19/2014)

---

Thanks! I didn't think about that. (where is my V8 icon).

I was busy cobbling this together when you responded.

The Rule Engine components...

Ed Pollack (6/19/2014)

---

Sean Lange (6/19/2014)

---

Ed Pollack (6/19/2014)

There's a bunch of fun ways to do this and in thios one case I went explicitly for the shortest, quickest, and dirtiest :-)...

barry 50045 (6/19/2014)

---

You're not saying insert the data from one sql table directly into its corresponding access table via t-sql....are you? If so, I didn't know you could do...

As I said before.

Basically you will...

Ed Pollack (6/19/2014)

There's a bunch of fun ways to do this and in thios one case I went explicitly for the shortest, quickest, and dirtiest 🙂 Not the least...