Thank you, very close but ideally all categories should have a parent (or two) so if there's a category3, then category1 and category2 should not be null, etc. I managed...

Thanks for the feedback. I've been trying to apply the above to my data set but somehow it won't roll up properly when I do the grouping, I didn't do...

• This reply was modified 1 years, 4 months ago by Mr. Holio.

Thanks for your response.

Thank you, that makes sense. I got confused because the deadlock graph suggested that each process was a "delete". If I leave the query as is and remove the NOLOCK...

It does, thank you!

Thanks!!

Is there a way to query sys.dm_exec_text_query_plan so that it only returns plans that performed at least one seek on index IX_SalesOrderDetail_ProductID? For example under <OptimizerStatsUsage> I can see all...

Thanks for the replies. I tested with repeatable read and did a waitfor delay 30 seconds as the last statement in both cases - then I realized without wrapping the...

Thank you for your input!!

Perry Whittle (10/26/2012)

---

I saw an advert for a contract here in the UK only last week and the agency stated

Now, remind...

Thanks ALL for your time,

Lynn, SPOT ON!! cheers!!

Sean Lange (5/23/2012)

---

I have no idea what the @param has to do with it but the following query will produce the results you stated you need.

select *,

case IsActive when...

http://www.codeproject.com/Articles/15778/Generating-Insert-or-Update-statements-from-table

is there a clustered index on that table?;-)

Thanks very much for your reply

Will check this thing out once I'm back in office tomorrow. My idea is just to hide the empty cols in SSRS rather than generating...

Use UNC path instead and make sure the sql service account has full control on the shared folder.