Any reason this has to be a Word doc? Why can't you use Reporting Services? This looks like something it could do easily.

sabercats (5/10/2012)

---

This one i made up per your team request. I did not test with sandbox ?

CREATE TABLE #Testing

(

Location varchar(255),

OS varchar(255),

Starttime DATETIME,

Endtime DATETIME

)

INSERT INTO #Testing

(Location, Starttime, Endtime)

SELECT 'tampa','win7','2012-05-01 12:56:27.000','2012-05-01...

Elliott Whitlow (5/10/2012)

---

DTC will exist on all nodes, it CAN be clustered and then the DTC will be a resource withing the resource group that SQL exists in.

However, I have...

Elliott Whitlow (5/10/2012)

---

Eric M Russell (5/10/2012)

---

Elliott Whitlow (5/10/2012)

---

Lynn Pettis (5/10/2012)

---

Guess I'd fail here....

sabercats (5/10/2012)

---

Example, I need to get all the records weekly start from last 2 Sunday 00:00:00 AM to last Saturday 23:59:59 include any records start before last 2 Sundays but...

Sean Lange (5/10/2012)

---

Actually Lynn that part is fairly easy to correct. The real problem is the OP wants help with the original query and did not provide any details about...

Do you see anything wrong with the following? Have you tried running this in a sandbox database?

CREATE TABLE #Testing

(

Location varchar(255),

OS varchar(255),

Starttime DATETIME,

Endtime DATETIME

)

INSERT INTO #Testing

(Location, Starttime, Endtime)

SELECT 'tampa','win7','2012-05-01...

Nevermind. Just reread your original post and that you are going against pre-2005 databases. I am assuming that you are querying SQL Server 2000 databases/servers.

I'd say that you could still store 8 bits in a byte.

Stefan Krzywicki (5/10/2012)

---

RBarryYoung (5/10/2012)

---

Koen Verbeeck (5/10/2012)

---

Stefan Krzywicki (5/10/2012)

---

Yeah, I created the import package manually. I ended up getting the table structures by using an openquery in a cursor loop through...

themangoagent (5/10/2012)

---

Like I said, it's de-normalized. It has fields like ID, Value1, Value2, Value3...Value12, where Value should be in its...

RBarryYoung (5/10/2012)

---

You too Lynn! How was...

sturner (5/10/2012)

---

djackson 22568 (5/10/2012)

---

Management - In my experience, this is what usually causes most of the issues. Team building does not work when you create an atmosphere that makes...

Eric M Russell (5/10/2012)

---

Elliott Whitlow (5/10/2012)

---

Lynn Pettis (5/10/2012)

---

Guess I'd fail here. First...

Don't see any attachment.