apat (10/4/2010)

---

This is a QA sever. Can other developers use the server to query database while the SP2 installation is in progress?

Do I need to restard SQL Server or reboot...

Chad Crawford (10/4/2010)

---

GilaMonster (10/4/2010)

---

Chad Crawford (10/4/2010)

---

Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one...

SELECT EmployeeID,

DataYear,

YearlyWage,

FiveYearWage = (SELECT SUM(YearlyWage)

...

I'd do it after. That...

I prefer to use the...

Welcome!

Yes, reading BOL and using search engines are powerful tools to have in your arsenal. The only thing I'd add to your excellent post is that when you have exhausted...

WayneS (10/2/2010)

---

Jeff Moden (9/30/2010)

---

WayneS (9/26/2010)

---

Jeff - just saw this thread after returning from my vacation. If needed, I can run this on a Vista Ultimate 64-bit laptop, on 2005 /...

Craig Farrell (10/4/2010)

---

WayneS (10/2/2010)

---

Craig Farrell (9/29/2010)

---

... I've gotten a list of questions that I always ask the employer. One of the top 3 is "What's your average employee's work...

http://msdn.microsoft.com/en-us/library/ms189275.aspx

BrainDonor (10/4/2010)

---

Paul White NZ (10/2/2010)

---

Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. And...

That depends... do your requirements specify sometimes doing some of this, and at other times not doing it? If so, then it would be needed.

blacklabellover2003 (10/3/2010)

---

Hi all,

I've got sections of code I'd like to transfrom into a single stored procedure. At the moment, we run each of the five sections separately, the first...

How about:

1. Use an Execute SQL Task to run a bulk insert to read the first line (column headers) into a #temp table (1 column).

2. Prepare a variable to...

Glad to be of assistance! 😀

Seriously, I do like Luke's suggestion of using grouping and the JOIN function within SSRS. The solution I posted might reduce network traffic and server...

Paul White NZ (10/2/2010)

---

Just locally, 5km or so. The new place is on the hillside overlooking the Tasman Sea and Kapiti Island.

Clicky Map...