Database

laziale wrote:

the value is 'noordzeeweg' but the think is that we don't know exactly in which table or column exactly is the record, and we have around 30 tables with lots of columns and records inside.

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

SELECT * FROM NewUserDetail

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "u1.ManagerID" could not be bound.

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

SELECT * FROM NewUserDetail

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

SELECT * FROM NewUserDetail

Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'WHERE'.

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)