3. Profit! 🙂

Michael Valentine Jones has the correct solution so I'd suggest you change your view accordingly. But, since you already have the view you can change your select from the view...

SQL does not have a "first" row. Sets...

You could try with and with out a derived table and see if you get a different query plan or execution time. But, it shouldn't make any difference to SQL.

maybe:

SET DATEFORMAT DMY

iruagawal (9/3/2009)

---

Hey guys, I have a question about money data types, if his "shippingcost" is to large to be held by the "money" data type what is a better (bigger)...

Is thr FROM clause ommited or missing?

igngua (9/2/2009)

---

Hi!

I dont know why this trigger aint working.

Scenario:

Data gets inserted, trigger gets fired, i take all the data from INSERTED...

I see what you want to do now.. Try something like this:INSERT INTO _tbl_Target (account_name,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec)

SELECT

ACCOUNT_NAME,

SUM(CASE WHEN Period_name = 'Jan' then AMOUNT else 0 END) AS JAN,

SUM(CASE WHEN Period_name =...

As montioned there is no order in a set, so I added an IDENTITY column to mainatain that order. In the real world you would have some sort of order...

If you wanna post some sample data and expected output, I'm sure we can help you come to a reasonable solution:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

As far as I know you'd have to return N number of separate columns or use dynamic sql. But, if you are trying to do a pivot you might be...

Lynn Pettis (9/2/2009)

---

I know what the problem is. Here is your code:

select top 1000

convert(varchar(30), convert(money, isnull(sum(shippingcost),0))) as "Total Navigation"

from

dbo.NavAttempts

The problem is...

I don't think it helps your particular issue, but you could change the order of COALESE and SUM to get rid of that warning message:select top 1000 convert(varchar(30), sum(coalesce(shippingcost,$0.0)))...

kabaari (9/2/2009)

---

Good morning All,

Is there a reason this statement is returning NULL?

WHERE tbl_Assembly_Holds.WorkOrder = LEFT(tbl_Assembly_Production.WorkOrder, 5) AND tbl_Assembly_Production.dateProd Between '8/3/2009' AND '8/31/2009' AND tlkp_Defects.Defect_Title = 'Jar To Cover Leak' AND...

Strange. any chance the SUM is larger than a MONEY datatype can hold?

Why convert money to money?

select top 1000 convert(varchar(30), coalesce(sum(shippingcost),$0.0)) as "Total Navigation"

from dbo.NavAttemptsAlso, why convert...