It's called the Dunning–Kruger effect http://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect

We had a kid a few years out of college who couldn't program his way out of a wet paper bag, and yet couldn't tell...

Jeff Moden (8/23/2011)

---

What's really spooky to me is how little a lot of job applicants know about the basics and how many of them don't know what they don't know....

shew (8/23/2011)

---

Several years ago, I worked with SQL Server extensively, and this web site was one of my most useful tools. One of the best things about it was that...

Your query that defines the cursor cleans up to this

SELECT

BudgetUnit,

POChartOfAccount,

'Encumbrance' ShortDescription,

SUM(UnitPrice * UnitsOrdered) ExtendedPrice

FROM

Requisition r

INNER JOIN

PurchaseOrder po on r.POID = po.POID

INNER JOIN

RequisitionLineItems rli ON...

One thing at a time, you don't want a sub select here

--Obtain the next control number

...

nadabadan (8/15/2011)

---

troe_atl (8/15/2011)

---

As for nadabadan your response was awful. I don’t expect you to read my mind and I didn’t need or want your rude response. There are...

troe_atl (8/15/2011)

---

Hi everyone.

I have a store procedure that has a summary query that return 4 rows but only inserts 2 rows into my table. Please take a look at the...

nested query derived table

qualify the derived table too, look how it makes it easier to see where the column is coming from

SELECT h.invoice_id,

...

Probably talking about a CTE.

http://msdn.microsoft.com/en-us/library/ms190766.aspx

With winash's suggestions and also aliasing the companies table, your query becomes this

SELECT h.Invoice_id AS Invoice_Id,

...

Maybe this can help you:

select floor(13.77777*10)/10

You're saying "assign" and "populate" but you're only running a select. Are you trying to update?

UPDATE

C

SET

C.Warehouse_Aisle =

CASE BS.Warehouse_Segment

WHEN 'Gourmet' then 1

WHEN 'Commercial' then 1

WHEN 'Consumer' then 2

END

FROM...

If you guys need a sub, I'd like to play. 🙂

bopeavy (7/13/2011)

---

Ignoring any potential logic problems, the syntax error is caused by not naming the derived table, like so

Select SUM(L_VALUE), SUM(B_VALUE) FROM (SELECT DISTINCT ID,C_NO FROM MYTABLE GROUP BY...

Ignoring any potential logic problems, the syntax error is caused by not naming the derived table, like so

Select SUM(L_VALUE), SUM(B_VALUE) FROM (SELECT DISTINCT ID,C_NO FROM MYTABLE GROUP BY ID,C_NO)...