Did you still have the other nonclustered index? Then, yes it would still use that index and it is fine. The reason it is faster is there is...

PHXHoward (11/23/2015)

---

A vendor script is doing a query like this:

use databaseABC

select column5 from table10

where '_' + cast(pk as varchar) = '_10000'

pk is and integer primary key so it has a...

Interesting that the table updates every 20 minutes but you can schedule jobs to run every second.

If the job is scheduled to run every 5 minutes but is still running...

cory.bullard76 (11/20/2015)

---

Ok, below is the case statement that is in my query. Works just fine. But, now I found out that the patient has to sign a Hippa...

ken.mulvihill (11/19/2015)

---

I am working with a view in SQL Server 2012

Calculating student age as of one of two reference dates

For fall term use reference date 1

For spring term use reference...

Jeff Moden (11/19/2015)

---

Eirikur Eiriksson (11/19/2015)

---

So to recap, here are 9 different methods for getting the current time, any additions anyone?

😎

SELECT

GETDATE()

,SYSDATETIME()

,SYSDATETIMEOFFSET()

...

Ed Wagner (11/18/2015)

---

I hope...

Cool, I just found a thread that reminds me on the Bankers Rounding Function threads.

Nice that some one else is in the flame war with this particular adversary.

Jacob Wilkins (11/19/2015)

---

There are a couple ways to do this.

Let's say you're wanting only rows where the time portion is greater than or equal to 22:15 in the date range...

Only thing I would suggest is this: and minute(create_dtim) >=...

Alvin Ramard (11/19/2015)

---

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 "...,...

SoHelpMeCodd (11/17/2015)

---

Passing a delimited string certainly works. But I am currently working an issue where one sproc uses STUFF FOR XML to create a delimited string. A second sproc accepts...

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 you are...

Well, I suspected but hoped I was wrong. You did post your question...

Now, assuming that you are looking for all data where the create_dtim is greater than or equal to 2015-01-01 and less than 2017-03-01 where the TIME portion for each day...