Lynn Pettis (3/20/2013)

---

Sean Lange (3/20/2013)

---

I think that the above would miss Claim 7149 which as I read your issue should show up on the list. This is easy enough to...

xgcmcbain (3/20/2013)

---

common practice in my noodle, I say nolock when I don't care if I know its read only or don't want to interfere with anyone, and I don't use...

I think that the above would miss Claim 7149 which as I read your issue should show up on the list. This is easy enough to correct by changing @StatusDate...

xgcmcbain (3/20/2013)

---

trust me this business logic allows all nolocks allowed. this is a read only database. its only written to overnight.

Thanks for the answer as it seems the...

Don't worry about it....

You are welcome.

The...

Jeff Moden (3/20/2013)

---

Lynn Pettis (3/20/2013)

---

Sean Lange (3/20/2013)

---

Sure this isn't too hard using a tally table.

insert #y

select #x.DocID, t.N

from #x

join tally t on t.N <= #x.pages

select * from #y

You...

You should read this article from Gail.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

Also be VERY careful with all those NOLOCK hints. That hint is incredibly dangerous when you don't understand all the real issues with it....

montse 22199 (3/20/2013)

---

Hello all,

I need to delete a record that is duplicate between 2 tables.

The query looks like this:

Delete from request_form_table_testing as t1

where EXISTS

(select tEmail from request_form_temp_emails as t2...

Sure this isn't too hard using a tally table.

insert #y

select #x.DocID, t.N

from #x

join tally t on t.N <= #x.pages

select * from #y

You can read about a tally table...

xgcmcbain (3/20/2013)

---

sometimes a sp can get out of hand if this if that etc where I saw a developer go over 9k lines.

allot of the code was re-use, the fields,...

Sounds to me like this app you are working on would be an excellent candidate for SaaS (Software as a Service). In other words, you create the application and lease...

Michael L John (3/20/2013)

---

This is probably one of the "worst practices" in a trigger.

For starters, you need to elevate secutity.

Secondly, the amount of overhead that occurs with...

meadow0 (3/20/2013)

---

I find the article conceptually and technically difficult to understand as I've only been working with SQL for about two weeks. I will certainly attempt to give it a...

meadow0 (3/20/2013)

---

I'm actually noticing now, that your originally revised query string does not allow for multiple parameters in @system_Status. I can enter as many arguments as I want, and it'll...