Thanks, I solved my own question.

Here is what I did;

SELECT [2010AFE].AFE, [2010Projects].DirectorID, Director.DirectorID AS Expr1, [2010Projects].AFE AS Expr2, [2010Projects].ManagerID, Manager.ManagerID AS Expr3,

...

Well you are right then. I cannot use DateDiff for that.

What I need is to be able to compare the changes to the datebase from yesterday or day before to...

Thank you. I know it had to be something simple!

Me too. I greatly appreciate your assistance. And it is always good to learn something new at the same time.

Thanks,

YES!!! You are the Man!

Worked like a charm. I thank you for teaching me quite a bit in one little stored procedure.

Thanks for all of you time, and knowledge.

Brian

If I run the StoredProcedure from the ASP.NET page, it fails to complete because it runs out of memory.

I modified the Select statement to read the TOP 100 and the...

EXEC yourProcedureNameGoesHere 'Redondo East'

Ok, the StoredProcedure part now runs without an error while in SQL server, however it is not returning just the location specified. It returns all of the...

If I delete the AND name = @WaySide it completes with the location name in the Wayside column.

It works with the same results. Wayside column results with NULL.

Ok, With the query looking like this;

SELECT ( SELECT name + ',' + state

FROM ...

Or did you mean to put the actual name of a location where the @Wayside is?

If I run the query this way, it works.

SELECT ( SELECT name + ',' + state

FROM...

Gianluca Sartori (4/22/2010)

---

Try defining the parameter as varchar(50) and filter it in the query like this:

( SELECT name + ',' + state

...

I am passing the name of...

I chose VARCHAR for the SP, and compared it to the...