Jeff Moden (2/14/2011)

---

Ok... I'll be the one to ask...

Why not validate and mark all the failures at once using set based SQL? Then you could actually create a report...

Tam Le 7 (2/14/2011)

---

Hi if your getting the following error your subquery contains more than one record:

Subquery returned more than 1 value. This is not permitted when the subquery follows...

The case is the following:

On a .NET app I have a button with which a SP is executing and creates an XML Exported file.

So I created a SP with a...

Thank you for your answers.

My initial question is:

How can I check every value which returned from my subquery and return a RAISERROR for every check from inside the SP.

You tell...

Yes, i want to:

2) Raise one error per subproject with a null start date

I'm catching every RAISERROR from .NET application

(catch (SqlException ex)

I want to check IF EXIST a NULL SUBPROJECT START DATE (checking all SUBPROJECTS) and THEN to RAISERROR.

Thanks

It returns 25.00 with "." separator.

I want to have comma separator (",")

Any help?

OK, I found the solution.

It's really a recursive query, but easier that you make it:

SELECT e1.RES_UID, e1.RES_NAME, e1.RES_TIMESHEET_MGR_UID, e2.RES_NAME AS TimesheetManagerName

FROM MSP_RESOURCES e1 LEFT JOIN MSP_RESOURCES e2 ON e1.RES_TIMESHEET_MGR_UID =...

The solution is not working for some reason, so I'm still having problems.

I don't know why.

Any further help?

More info:

Table name: MSP_RESOURCES

EmployeeID: RES_UID (PK, UID(uniqueidentifier)

EmployeeName: RES_NAME (NAME(nvarchar(255)),not null)

EmployeeApprover: RES_TIMESHEET_MGR_UID (UID(uniqueidentifier),null)

Do I need to create a new table and select from there?