Database

WITH NewUserDetail (UserID, ManagerID, FullName)
AS
(
   SELECT UserID, ManagerID, FirstName + ' ' + LastName As [FullName] FROM tblUserDetail u1 WHERE u1.UserID=12
   UNION ALL
   SELECT u2.UserID, u2.ManagerID, u2.FirstName + ' ' + u2.LastName As [FullName] FROM tblUserDetail u2 Inner Join NewUserDetail AS Manager ON u2.UserID<>Manager.ManagerID
)

Msg 530, Level 16, State 1, Line 1
The statement terminated. The maximum recursion 100 has been exhausted before statement completion.

u2.UserID<>Manager.ManagerID

u2.UserID=Manager.ManagerID

r_mohd wrote:

System.NullReferenceException: Object reference not set to an instance of an object.
at FinAcct.FrmMainMdi.FrmMainMdi_Load(Object sender, EventArgs e)

select Q.ID, Q.item, Q.vendor, Q.Quote, V.phone, V.fax
from (
  select ID, item, min(quote) AS MinQuote
  from quote_tb
  where ID = 11
  group by ID, item
) AS MinQ
inner join quote_tb Q
  on Q.ID = MinQ.ID
  and Q.item = MinQ.item
  and Q.quote = MinQ.quote
inner join vendor_tb AS V
  on V.name = Q.vendor
order by Q.ID, Q.item

...
from (
  select Q.ID, Q.item, min(vendor) AS MinVendor
  from (
    select ID, item, min(quote) AS MinQuote
    from quote_tb
    where ID = 11
    group by ID, item
  ) AS MinQ
  inner join quote_tb AS Q
    on Q.ID = MinQ.ID
    and Q.item = MinQ.item
    and Q.quote = MinQ.quote
  group by Q.ID, Q.item
) AS MinS
inner join quote_tb Q
  on Q.ID = MinS.ID
  and Q.item = MinS.item
  and Q.vendor = MinS.MinVendor
...

SELECT f.item, f.vendor, f.quote, v.phone, v.fax
	FROM (SELECT item, min(quote) AS minprice FROM quote_tb WHERE ID='11' GROUP BY item) 
	AS x INNER JOIN quote_tb AS f ON f.item = x.item AND f.quote = x.minprice
        inner join vendor_tb as v on f.vendor = v.name

SELECT f.item, f.vendor, f.quote, v.phone, v.fax
	FROM ((SELECT item, min(quote) AS minprice FROM quote_tb WHERE ID='11' GROUP BY item) 
	AS x INNER JOIN quote_tb AS f ON f.item = x.item AND f.quote = x.minprice)
        inner join vendor_tb as v on f.vendor = v.name