It is really hard to help with what you have posted. The code you posted is poorly formatted it looks like a big bowl of spaghetti. I took the liberty...

What is your primary key for customer? It seems like you should be passing in the CustomerID instead of the customer name. What happens when you have two customers with...

/facepalm

I guess I got hung up on the OP using the order by and went the...

Grant provided an answer already on your post at ask.ssc.com.

http://ask.sqlservercentral.com/questions/103091/report-of-all-views.html

In your reply you indicated that you do not have any trace or extended events running. That means you basically have...

hehe...

kl25 (5/30/2013)

---

RedBirdOBX (5/30/2013)

---

I use a few different methods of creating a view. I can Right Click on the Views folder in SSMS and simply select New View. I...

No problem. It is best to only post your question once. Otherwise people will find one or the other and your responses will be fragmented and difficult to follow.

Lowell (5/30/2013)

---

it's a quote,...

And Gail is the winner!!!

duplicate post. direct replies here.

http://www.sqlservercentral.com/Forums/Topic1458422-391-1.aspx

duplicate post. direct replies here.

http://www.sqlservercentral.com/Forums/Topic1458422-391-1.aspx

j-1064772 (5/30/2013)

---

I was used to ssql2k when I did not need no smelly semi-colons.

Not clear yet as to why this was added to the language.

And yes, you are right about...

Well actually a CTE requires...

RedBirdOBX (5/30/2013)

---

I use a few different methods of creating a view. I can Right Click on the Views folder in SSMS and simply select New View. I can...

j-1064772 (5/30/2013)

---

Sean Lange:

Actually, the following SQL

[font="Courier New"]

SELECT #INV.InvNo, #INV.Currency, #INV.Amount AS GrandTotal, #PAY.Paid

FROM #INV LEFT OUTER JOIN #Pay ON #Pay.InvNo = #INV.InvNo

ORDER BY #INV.Currency, #INV.InvNo

[/font]

Produces the following results set: ...