Ok so the characters between the quotes are:

< / t a b l e >

It seems that the forum code lets it through and it causes strange formatting because it...

Steve Jones - Editor (7/15/2009)

---

No idea, what's wrong there. Usually it's an embedded HTML code, but I don't see on there. Definitely something...

I chose char(1), but having skimmed the various replies think that there's also an argument for nchar(1). The question is a bit vague as to the supported character set.

What's clear...

byron.vanwyk (6/3/2009)

---

I couldn't quite understand exactly what you did 🙂 but took some stuff you used and added it to my query. The result ..... exactly what I was looking...

To show how to extend it, using the same test data, the following computes the distribution in hourly bins.

select

date,

datepart(hh,(convert(datetime,time,108))) as 'hr',

sum(acd_calls) as 'acd_calls per hr',

sum(aban_calls) as 'aban_calls per hr',

sum(sum(acd_calls)) over(partition...

In the absence of a full set of sample date, I used part of your array as follows

create table #t (date datetime,

time char(5),

acd_calls int,

aban_calls int,

expect_percent float)

insert #t values('01-may-2009', '07:30', '0',...

Interesting. The 2 I've regularly used are BIDS and SQL server agent jobs. I've hardly ever used dtxec and wasn't sure about the dtexecui option!

It just shows how different people...

Alvin Ramard (6/1/2009)

---

Derek Dongray (6/1/2009)

---

Alvin Ramard (5/28/2009)

---

Lynn Pettis (5/28/2009)

---

At the rate things are going I'll have that many spam emails in my spam folder by the end of the day....

Alvin Ramard (5/28/2009)

---

Lynn Pettis (5/28/2009)

---

At the rate things are going I'll have that many spam emails in my spam folder by the end of the day. Some spammer is using...

GilaMonster (5/21/2009)

---

Mine never bring me anything. Only once they brought a bird in and...

Does anyone else feel like...

Paul White (5/12/2009)

---

Any budgetary constraints Jeff?

If I win the lotto this weekend, I know which one I would buy.

(NZ)...

Bruce W Cassidy (5/6/2009)

---

[font="Verdana"]Algol 68 was a later revision to the language. However, it may have been the first version of PL/1. Been, er, 20 years since I...

GilaMonster (5/4/2009)

---

Luke L (5/4/2009)

---

Or perhaps that seeing the name might be enough to jog your memory, although I wasn't sure since you're from South Africa. Not sure how...

Far too easy!

Since 1 works, the answer had to include 1. Hence it had to be 1,2,4 without needing to actually check the others. 🙂