dramon14 (1/7/2016)

---

because the process must be automatic, you must run at 7am and be the data must be ready in the database for analysis. I also thought the process by...

amar_kaur16 (1/7/2016)

---

I have a table of tests where I have data in the tabular format:

English 8:30 9:00 9:30

Reading...

Just thinking ... would be interesting if one could create an infinite LMGTFY loop. 😀

Hoppy New Year to you too.

Jeff Moden (1/6/2016)

---

SQLRNNR (1/6/2016)

---

Jeff Moden (12/29/2015)

---

That picture has always struck me... it's either a picture of Grant's back yard when he's BBQ'ing or a picture of Detroit on...

Sean Lange (1/6/2016)

---

Steve Jones - SSC Editor (1/6/2016)

---

Sean Lange (1/6/2016)

---

Wow. I rarely have to deal with user issues but I was just on a phone call with one of our...

Jeff Moden (1/6/2016)

---

Brandie Tarvin (1/6/2016)

---

djj (1/5/2016)

---

There all over the internet.:-P And...

I don't think you can assign the condition(s) to a variable like you're trying to do.

Eirikur Eiriksson (1/4/2016)

---

Alvin Ramard (1/4/2016)

---

Eirikur Eiriksson (1/4/2016)

---

Jeff Moden (1/4/2016)

---

Lynn Pettis (1/4/2016)

---

Good question. Just one minor thing, I'd use the following the end of the calendar year:

SELECT DATEADD(DAY, -1, DATEADD(YEAR,...

Eirikur Eiriksson (1/4/2016)

---

Jeff Moden (1/4/2016)

---

Lynn Pettis (1/4/2016)

---

Good question. Just one minor thing, I'd use the following the end of the calendar year:

SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) +...

Post your SQL statement here, preferably with a sample of the data you have been using.

Sean Perkins (1/4/2016)

---

I've been waiting for the process to finish for several hours now. When I first ran the kill command after seeing the SPID in rollback status, I...

If you monitor the CPU usage when your PowerShell tool is running or is not running, you should be able to tell if your tool is causing the issue(s).

I have a Lenovo Yoga 2. I like it so much that it's pissing me off! I can't justify getting a Surface Book as long as it's working.

joeshu26 (12/31/2015)

---

I would like to SELECT only dates from my dimDate table that are less than or equal to the latest date in my factTable. Any syntax for this...