-- use an INNER JOIN if the data permits

-- i.e. if every header has at least one line, and always will.

-- Option 2

SELECT

h.GroupHeaderID,

h.GroupName,

MemberCount = COUNT(*)

FROM table_A h

LEFT JOIN table_B l...

Frost.

Very pretty morning in Warwickshire, England.

Yes but I used DBCC TIMEWARP to get it and Windows...

You're welcome 🙂

Gianluca Sartori (11/24/2010)

---

WayneS (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

Craig Farrell (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

Depends on...

No problem:

DECLARE @Today DATETIME, @nMonths TINYINT

SET @Today = GETDATE()

SET @nMonths = 12

SELECT MonthEndDate = DATEADD(dd, -1, DATEADD(month, n.n + DATEDIFF(month, 0, @Today),0))

FROM...

How many months do you want, is it 12 or 13?

Cheryl McLaughlin-385812 (11/23/2010)

---

...This is important because this will determine who...

DECLARE @startdate DATETIME, @enddate DATETIME

SELECT @startdate = '15 - dec - 2009', @enddate = '16-march-2010'

--Output should be Jan - 31, Feb - 28, March - 31

SELECT MonthEndDate = DATEADD(dd, -1,...

CirquedeSQLeil (11/23/2010)

---

Topic changer:

I want to bring up the age old question related to books.

If you were to buy a SQL book, what would you buy? If there is a...

a_ud (11/23/2010)

---

Hi Chris,

@eventsList is a TABLE type with several fields. It is defined as the RETURNS value of a function (all this comes from a function. The final goal is...

What's next?

Fantastic Rich, well done mate. Top work.

a_ud (11/23/2010)

---

Hi Chris,

@eventsList is a TABLE type with several fields. It is defined as the RETURNS value of a function (all this comes from a function. The final goal is...

a_ud (11/23/2010)

---

I can't run the instruction PRINT (@SQL) on a separate query. The reason for this is that I can't reproduce (or don't know how) the values of the @eventsList...