TomThomson (5/26/2014)

---

That...

SQLRNNR (5/20/2014)

---

paul.knibbs (5/20/2014)

---

Maybe this guy saw that story about the programmer who outsourced all his own work to China for a fraction of his salary and...

I think you would have enjoyed my Select Statement. 😀

Just tried to get them to ask a real question.

Then we might understand how much help is needed.

Ding, Ding, Ding....

How many...

Post some ddl, your query, sample data, and expected results.

Otherwise, you...

If ignoring weekends, is there any consideration for normal business hours?

For example, 8am to 6pm are normal business hours.

If start is 4:30 pm on Thursday, and end is 9:15am on...

Sounds like you need to install Analysis Server.

I would verify which version - 2008 R2 or 2014, they are different.

And I would also do this in a test environment, not...

Use Excel in Reporting Services, or just Excel 2010 or above.

Generally, this would be something posted under Reporting Services or a BI / Data Warehousing topic.

Ed Wagner (5/14/2014)

---

Sean Lange (5/14/2014)

---

I almost spit my coffee on the...

Grant Fritchey (5/14/2014)

---

Greg Edwards-268690 (5/14/2014)

---

Grant Fritchey (5/14/2014)

---

Since you now know that you need to replace the one character, you could try using the REPLACE T-SQL statement on the string (not...

Grant Fritchey (5/14/2014)

---

Since you now know that you need to replace the one character, you could try using the REPLACE T-SQL statement on the string (not on the column) to...

Probably a rounding error.

Could also be server synching time with domain controller, if this happened between start and end of trace.

You can also have a cell referenced in the worksheet, and when changed, it will reresh the query.

Luis Cazares (4/8/2014)

---

Since you're correcting this code, why don't we make it simpler and faster?

WITH UnloadDates AS(

SELECT ShipmentID,

MIN(starttime) StartTime,

MAX(Endtime) EndTime

FROM tblInvoice O

WHERE O.startTime IS NOT NULL

AND O.EndTime IS...

GilaMonster (4/28/2014)

---

TomThomson (4/25/2014)

---

Steve Jones - SSC Editor (4/24/2014)

---

On the shed-dyule for Bits, and planning on...

Brandie Tarvin (4/22/2014)

---

Jeff Moden (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

The easiest method I've seen was shown to me by a prawn fisherman in Ullapool and I've only tried it with herring but it would...