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.

SELECT DISTINCT

A

,(SELECT t2.B + ' '

FROM (SELECT A, B, ROW_NUMBER() OVER(PARTITION BY...

jpSQLDude (3/8/2012)

---

Chrissy321 (3/8/2012)

---

>>and then in SSIS I can also put the farm name in another column

Can you use the extended properties of a database.. Right-click on the database and go...