Matt Miller (#4) (2/6/2010)

---

Jeff Moden (2/6/2010)

---

The Dixie Flatline (2/6/2010)

---

Thank you for that helpful information, George. I apologize.

Can someone tell me if it makes a difference whether or not...

Another option

declare @productcategoryid

set @productcategoryid = 4

Select pav.ProductAttributeValueID,pc.CategoryName, pca.ProductCategoryAttributeName,pav.AttributeValue

From ProductAttributeValue pav

...

Your...

Would a sequential guid work in place of an int?

It should be less of problematic and it doesn't necessarily need to be the primary key (it could be a unique...

No problem with encrypting communications to the server.

Another method is to establish an ssl certificate on both the client and the server.

HAHA

The Dixie Flatline (2/6/2010)

---

I don't understand why you have to be so disrespectful and make this so complicated. I am a certificated past grandmaster DBA and can put...

I see what you are saying now.

A recursive CTE using the query I provided you inside the cte should get that for you. Just use the parentcategory...

I don't follow...

I neglected a critical piece of my post - it is the sequence in which the parameters are passed to timewarp.

One must still use all of the parameters - it...

I like what Grant added. Many of us are working in trimmed down shops with plenty of responsibility and duties for three dbas each. Being detail oriented, you...

Dave Ballantyne (2/3/2010)

---

When i started in this business it was a science , i still try to see it like that.

Unfortunately that does not seem to be the case...

extraction

Thanks - nice script.

Alvin Ramard (2/6/2010)

---

CirquedeSQLeil (2/6/2010)

---

Don't be too sure about that (evil...