Click on the word "this".

Based on personal observations, I believe the schedule also gets update at the completion of every job run.

Lynn Pettis (11/19/2015)

---

Let's ask a question in a SQL Server 2012 forum when it is really about Access. Oh, and I even prefaced my answer with "..., and if...

Union...

Luis, I'll include you with me. 🙂

vantuan02t1 (11/19/2015)

---

I have a table: Table_1 as below:

IDDescription

1College 1 kaká

2University 1

3College 2

4University 2

I use sql select: Select * from Table_1 where Description like N'%College%'

=> Result:

IDDescription

1College 1 kaká

3College 2

But 'College' always...

robert.sterbal 56890 (11/16/2015)

---

One of the things that makes people turn away from a forum is when bed behavior isn't addressed.

I'd agree that a +1 shouldn't be the first thing in...

Brandie Tarvin (11/13/2015)

---

ScottPletcher (11/12/2015)

---

He wants to do nothing himself. I tried to walk him thru the logic of how to code #4 in his original q, here:

http://forums.sqlteam.com/t/need-help-case-statement-should-work/4070

but he refused,...

anjaliagarwal5 (11/12/2015)

---

I did that. Now I am getting an error saying:

The conversion of a datetime datatype to a smalldatetime resulted in a out of range value.

The testDate column in the...

Lynn Pettis (11/12/2015)

---

nexus2vijay (11/12/2015)

---

Hi,

It's a test actually.

Nope infact i don't have setup to test the same. I have just given the logical approach.

Appreciate if you could help me with that...

Phil Parkin (11/12/2015)

---

nexus2vijay (11/12/2015)

---

Hi,

From the attached 4 Tables Schema Diagram

Will the below query Reduce me the ListPrice by 20% if i didn't receive the order for the last 2 years...

It accumulated 100 million tables and NOBODY noticed? :w00t:

That's ok Jason, as long...

I'm not 100% sure of exactly what your situation is, but it looks like you should keep on using that key values pair table. Just make sure you have a...

What data type is flg_attendance?