Uhm, ..., yeah sure, let's...

Glad I could help.

Glad we could help ... 😉

And here's how to use a View like a function:

SELECT

*

, (SELECT TopUnit FROM OrgLevels WHERE OrgUnitID = @OrgUnitID) as TopUnit

FROM YourTable

WHERE ...

Here's a correction to my View that should help:

CREATE VIEW OrgLevels AS

WITH cteRecur AS (

SELECT r.OrgUnitID, o.Parent, 1 as Lvl, r.OrgUnitID as TopUnit

FROM RSUNew r

LEFT JOIN ISC_OrgUnits o ON r.OrgUnitID...

You can call a view from any where in SQL, why wouldn't you want that?

SELECT * FROM YourTableName WHERE 1=0

Like this:

Set @ months = (SELECT ADateFiled from TableA WHERE ...)

The reviewers wouldn't necessarily have to be anonymous in the forum itself, as long as no one else could get into the forum. All you should need is what...

jbarker4682 (8/12/2009)

---

Jack Corbett (8/12/2009)

---

RBarryYoung (8/12/2009)

---

If you want to test for a network/display type issue, then change your SELECT query to a SELECT .. INTO #temp and time that. If...

Jack Corbett (8/12/2009)

---

RBarryYoung (8/12/2009)

---

If you want to test for a network/display type issue, then change your SELECT query to a SELECT .. INTO #temp and time that. If it...

clarence.cheng (8/12/2009)

---

Strange though, this setup has been working for like 2 yrs at least, the only change I can indentify is that we did a upgrade to windows server 2003...

Steve:

I like the idea of volunteers reviewing the submissions, but I share some of the concerns others have mentioned also. But as I see it, ultimately, this...

If you want to test for a network/display type issue, then change your SELECT query to a SELECT .. INTO #temp and time that. If it is significantly faster,...

clarence.cheng (8/12/2009)

---

It works from my account, my account is sysadmin. But the stored proc is run through SQL Agent job and is owned by a user with no sysadmin..............