Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

This made me spill my ESB all...

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

This made me spill my ESB all over the Pub...

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Where have you...

David Burrows (10/1/2015)

---

Many many moons...

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

Here is a quick solution that fits nicely for simple usage.

😎

Your plan shows a seek for a double-wildcarded parameter...must play with this at home. Thanks...

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Where have you found ESB on...

It might be more efficient to aggregate just the data you need to:

select --distinct

'On-Demand' as 'Business Line',

o.OrderID as 'Order #',

isnull(d.DisplayCode,'UNK') as Hub,

isnull(rz.RouteID,'UNK') as 'Default Route',

'On-Demand' as 'Assigned Route',

o.DestAddress,

o.DestZip,

C.LocalName,

C.CustID,

DATENAME(dw,o.OrderDate) as 'DoW',

DATENAME(ww,o.OrderDate)...

BWFC (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

jasona.work (10/1/2015)

---

I do...

Mmmm...

Sausage (breakfast sausages) with syrup on them is goooddd.

As for a maple ale /...

Eirikur Eiriksson (10/1/2015)

---

The Ale&Pie ...

Where have you found ESB on draught?

jasona.work (10/1/2015)

---

I do...

Mmmm...

Sausage (breakfast sausages) with syrup on them is goooddd.

As for a maple ale / beer, I...

mihir.nasikkar 40164 (10/1/2015)

---

SELECT DISTINCT mv.meetID,

mv.FundID,

CASE WHEN vcv.vote IS NULL

THEN mv.VoteFlag

ELSE (CASE WHEN vcv.vote IN ('<Unknown>','Refer','','Did Not Vote','None') Then...

Eirikur Eiriksson (10/1/2015)

---

Here is a quick solution that fits nicely for simple usage.

😎

Your plan shows a seek for a double-wildcarded parameter...must play with this at home. Thanks for posting, Eirikur.

Brandie Tarvin (10/1/2015)

---

BrainDonor (10/1/2015)

---

I've been to Canada more times than I can recall - maple with pretty much...

zedtec (10/1/2015)

---

Hi,

I have a date column (not datetime) in SQL Server and the dates are in the format yyyy-mm-dd

I need to replace the date values with zero's so it looks...