Grant Fritchey (9/19/2008)

---

Chirag (9/19/2008)

---

GilaMonster (9/18/2008)

---

Chirag (9/18/2008)

---

another way is to right click on the proc in SSMS and select view dependencies. It will show all objects that depend on the...

Hey i thought the answer is "They are the same".

Hi

I have'nt gone thru your post in detail.. sorry for that 🙂

You could take a look at CTE 's for fetching hierarchial data.

That way you wont have to worry abt...

GilaMonster (9/18/2008)

---

Chirag (9/18/2008)

---

another way is to right click on the proc in SSMS and select view dependencies. It will show all objects that depend on the proc and also...

Are you sure that there is a table or index named VBMOD.

You need to pass a table name to sp_autostats.

another way is to right click on the proc in SSMS and select view dependencies. It will show all objects that depend on the proc and also all objects...

what are u passing to @WhereString ?

"Why do people point to their wrists when asking for the time, but don't point to their crotch when they ask where the bathroom...

I think it shud be..

WITH temp (Id, ParentId, iteration)

AS

(

SELECT Id, ParentId, 0 AS iteration

FROM OrgTable WHERE ParentId IS Null

UNION ALL

SELECT a.Id, b.ParentId, a.iteration + 1

FROM temp a

...

u hv to use dynamic queries for this.

Declare @sql varchar(1000)

SET @sql = 'SELECT *

FROM Person.Address where AddressLine2 '...

What happened to op?

"declare @@TheKey int". should'nt it be declare @TheKey int.

selecting top 1 may not be very random.

If this is the scenario...you want execute a procedure named proc1 and the db that you want to execute the proc is dynamic, keep the proc in all the...

in english please if possible...:)

Can u post the whole query?

select ParentTable.ParentID, ParentTable.SomeDataCol,

CASE WHEN A.Parent > 0 THEN 1 ELSE 0 END AS Bitcolumn

FROM ParentTable

LEFT OUTER JOIN (select parentid as parent from ChildTable where bitcol...