But, I also think this is what you are looking for:

create table #foo (

accountID int

, headerID int

, headerText varchar(40)

);

insert into #foo(accountID, headerID, headerText)

select 1, 1,...

I'm only missing one thing to really help you, what is the expected results based on the sample data provided above?

Jeff, since you want to see it in writing, check this path on your system at home, you should fing a copy of the EULA for the developers edition there:

C:\Program...

mtucker (7/30/2009)

---

Since it's impossible to prove the non-existence of diety, the denial of said existence is just as much a question of faith as the assertion of the opposite. ...

How about showing us what you did to fix the problem? Someone else may have a similar problem and seeing what you did may help.

For the last 4 years I have been working for a Public School District. We are not a 7x24 hour shop, I don't worry about being on-call (but I...

Duplicate post. Please continue with any additional replies here.

Does this mean your perspective is changing for the better?

Been through a lot these last few days myself, though most likely not what you have been going through.

Looks like some of us are in agreement regarding the concept of Equal Pay for Equal Work.

Unfortunately, I do know a few people that would agrue that the...

Okay, nice name change A...

jcrawf02 (7/30/2009)

---

It was the younger guy, Hire A, wasn't it - because us younger folks feel more entitled, since inflation caught up with us....

And as long as any one who is making actual changes to database objects (altering tables, sprocs, views, etc) has a licensed copy of Developer Edition ($50.00 USD isn't bad)....

But I just noticed a slight problem with both. Looks like we need to do a left outer join to a tally table calculating the date/time in 10 minute...

Michael Valentine Jones (7/30/2009)

---

select

Order_10_Minute =

dateadd(mi,(datepart(mi,orderdate)/10)*10,dateadd(hh,datediff(hh,0,orderdate),0)),

...

I love it when people bring up equal pay for equal work. How do you justify it, and how do you enforce it?

Please respond to the following scenario:

Hire A...