I've only had to do it once, and that was almost a year ago, so I'd pretty much have to dig through MSDN and online searching to do it. ...

Cursors are just a tool. The problem with them is misuse.

Lots of devs seem to want to use a drill press to cut plywood sheets. Can...

al_kessler (12/2/2009)

---

Goal: Attach these two boards.

Tool: Hammer, Resource: Screw

Hmm?

Yeah, it will work but not the best. However, if you are out of other options (no nails and all the...

Let me guess, you upgraded to a 64-bit system from a 32-bit system?

If so, it's pretty much just a matter of downloading and registering the necessary drivers.

Join the table with itself on ID.

Would look something like:

select *, datediff(day, EventA.Time, EventB.Time) as Days

from dbo.MyTable EventA

full outer join dbo.MyTable EventB

on EventA.ID = EventB.ID

...

Brandie Tarvin (12/2/2009)

---

GSquared (12/2/2009)

---

A very common practice is to deny all rights in a database except the right to execute certain procs, then have those procs do all the DML...

Brandie Tarvin (12/2/2009)

---

Nope. That did NOT work. I even did a DENY INSERT on schema dbo and had the user's default schema as MySchema and had the proc saved in...

Denying insert and datawriter doesn't override the permission on the proc. If you grant execute rights on the proc, the assumption by the security engine is that you are...

Personally, I'd cache the query results in a table, and have a job periodically check the table and send any results it finds. That way, you're not slowing down...

Microsoft has a set of steps you have to take to install SQL 2005 or 2008 on Vista. 2005 needs SP 2 if I remember correctly.

I have both 2005...

Best and worst are both imaginary concepts with no real-world existence. They can only be defined as "best I've seen yet" or "best that I know of in this...

BaldingLoopMan (12/1/2009)

---

----------------------------------------------------------------------------

--Lynn and I are agreeing with you. john scott miller is the one making odd statements about hair, good guys, and disagreeing with Lynn that cursors have any use...

If the reads are that different, then either the table is different, or the data is different, or it's a different query. I'm not sure that's related to the...

Yes, you can manipulate the data in a temp table in ways you can't in a cursor.

However, in 9 years of SQL, I've never yet run into a situation where...

Individual joins and union statements is how I'd initially go too. Easier and more performant than case statements in join clauses.