What you wrote should work.

Note that you can re-write this query as a JOIN:

SELECT t1.*

FROM Table1 t1

JOIN Table2 t2

...

MattW2010 (6/4/2010)

---

------------------------------------------------------------------------------------------------

Does anyone know how to do the following (?):

•If the number of insurances is > 3 for a given OrderID, only include the first 3?

•If the number of insurances...

Dominic Gagné (6/4/2010)

---

well, our Enterprise Edition is already installed on my XP Pro PC and it works great, so why shoudn't be able to install it on a Windows 7...

You would order by the column alias - in this case, "Created Date".

ORDER BY [Created Date]

How about some input from fellow Threadizens on Who physically maintains your servers?

I think this might do it for you.

UPDATE a

SET ColumnA1 = CASE WHEN b.SomeTypeID = 1 THEN 1 ELSE a.ColumnA1 END,

...

I bet if you put PivotTable in there, it would work.

Right before: EXEC SP_EXECUTESQL @PivotSQL

Put a "PRINT @PivotSQL" statement, then post the results.

Actually, if you look at it, I'll bet you can see the problem.

Another tip... if you add a...

Minimum 4 hour 😀

You're welcome. Did it do what you want it to do?

Are you saying that if ColumnB has a decimal portion, that you don't want it?

You know, the people that help out here are all un-paid volunteers, so please HELP US...

If you have separate tables for each of the Field7 #'s, then you can:

1. get rid of adding the extra columns to #csvtest.

2. get rid of the dynamic sql.

3. duplicate...

Your block of code:

SET @PivotSQL = N'

SELECT

DataTable.*, (SELECT AVG(InclGST)

FROM Mobile

WHERE Month = ' + @CurrMonth + '

AND Year = ' + @CurrYear +') AS CurrMonthAvg

FROM

Needs to be:

SET @PivotSQL = N'

SELECT

DataTable.*,...

I think the last part of the where clause needs to be <, not <=.

Also, you might want to look at the "Common Date/Time Routines" link in my signature for...

SELECT DISTINCT

docno,

notetitle,

Notetext = STUFF((SELECT ' ' + NoteText

...