dwain.c (8/8/2013)

---

I've been hearing a lot of Tok Pisin for the last week. ...

That's well sneaky Stefan! This mod should make it quicker, too:

;with cte1 as (

-- get all interesting months

select

FirstDay = dateadd(month, N, '20100101'),

qq = dateadd(month, 1, dateadd(month, N, '20100101'))

from...

Borrowing from Luis' test...

GilaMonster (8/8/2013)

---

ChrisM@Work (8/8/2013)

---

Sounds like a Sisyphean task, similar to those given to raw recruits of some services - "Get me a Portuguese handpump and bring a bucket of steam with...

Sounds like a Sisyphean task, similar to those given to raw recruits of some services - "Get me a Portuguese handpump and bring a bucket of steam with you".

Hi James

The table alias 'c' is now used in the APPLY subquery and is not visible to the outer SELECT list. If it were in the SELECT list of the...

This is an exact match for your stated requirements and results. However, if I were a betting person, I'd put money on it being wrong - because you've missed out...

HowardW (8/8/2013)

---

Check out the strap-line under the logo on the website as well. Comedy...

Howard - the name of the guy made me chuckle, given the pidgin English 😀

Has anyone else had issues with posting image links? I've used Postimg before and it's...

This is a real stab in the dark;

SELECT

MT.[Organisation ]

,MT.[Assignment Number ]

,MT.[First Name ]

,MT.[Last Name ]

,MT.[Position Title ]

,MT.[Site Name ]

,MT.[Date of Expense ]

,MT.[Reason ]

,MT.[Expense Item ]

,MT.[From ]

,MT.[FromPostcode ]

,MT.[To ]

,MT.[ToPostcode ]

,MT.[Step...

You will need to include both tables in your query:

FROM employers

LEFT JOIN superusers

Luis Cazares (8/7/2013)

---

wolfkillj (8/7/2013)

---

Sean Grebey (8/6/2013)

---

Thanks for the replies. Out of curiosity, this is the approach I took. Is there an issue with it?

select ROUND(sum(ContractValue),2) ContractValue, MONTH(ContractDate), YEAR(ContractDate)

From Reporting.dbo.PrgSum

Group by...

1970's toilet graffiti: on the left-hand side of the cubicle is written "see other side...

It works?

rajg (8/7/2013)

---

I am really not sure but this is that table structure with data that is given to me. Would really be a great help if someone can help....