Often people use a dateadd/datediff combination to remove times, or to set to a base time.

SELECT DateAdd(Day, Datediff(Day,0, GetDate() -1), 0)

returns midnight of yesterday. That might be what you want....

The way in which queries are formatted is very subjective. Some people like this:

select col1, col2, col3

from mytable

inner join myothertable on col1 = myfk

where time < getdate()

others prefer more indentation.

select...

I'd also ask people in the company. It's possible someone runs SSIS or performs manual imports from their workstation.

Alvin Ramard (11/25/2015)

---

Steve Jones - SSC Editor (11/25/2015)

---

The spam problem is tough. Believe me, no matter what we do, people will find ways around it. Much of the spam isn't...

You could track the times in sys.jobactivity. You would need to create an average, or max, or whatever statistical calculation you want. Then you'd need to track the current execution...

The spam problem is tough. Believe me, no matter what we do, people will find ways around it. Much of the spam isn't a user clicking and posting like you....

I know this is old, but did you recover things?

Also, please don't set emergency or use repair allow data loss. You have errors in low numbered system objects, which are...

Thanks for noting that I mirror Keith poorly. :hehe:

DonlSimpson (11/24/2015)

---

Yeah but isn't that using a butter knife as a screwdriver? Certainly you can, and many people and organizations do, use the database server as the staging area...

I was using window functions, and this appeared to work, but it's a small sample size, so perhaps there's a flaw here:

SELECT t.*

FROM ( SELECT top 10

...

IMHO (11/24/2015)

---

I think they call...

swwg69 (11/24/2015)

---

Corporations allow the owners to have limited liability. That also makes the guys making the BIG money more casual about these problems. If someone took 100 million...

don't drop your framework or view on table design.

If I'm staging data here, pulling from unclean sources, do I need a PK or non-nullable columns? It's a perfectly valid design,...

What's previous?

The order of rows has no meaning in SQL Server. The way you insert them doesn't matter.

Right now your second row has a larger id and a later last...

I'm not sure it's that hard to go from 2005 sp4+ to 2016. The core features are there and not much has been removed, though lots deprecated. I suppose if...