Dominic Gagné (6/4/2010)

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

...

I would prefer the full-featured... but the time limit needs to be a least a month. Like you mentioned, all it takes is getting caught up in a few things...

If you have all of the record types, we can probably work something out. 🙂