You can just place your code surrounded with special tags which you can see on the left side of the text box where you're typing your post...

Jayanth_Kurup (3/15/2012)

---

I wud go with the instead of trigger if this wasnt a frequent activity. else i wud create a new column called is modifiable. and update it with 0...

To get time as HH:MM:SS from seconds, you don't need to calculates hours, minutes and seconds, format and concatenate them separately. You can just use one of standard CONVERT options:

DECLARE...

And also securing your job for few...

logavina (3/14/2012)

---

This query was working on SQL 2000 but on SQL 2008 is giving me the error "Divide by zero error encountered.":

UPDATE T_PRICE

SET VAR =

CASE

WHEN PRICE <> 0 AND...

mayur birari (3/14/2012)

---

@r.P.Rozema

Thanks for the reply.

The foreign key of A goes into 2 more tables just like table B. But those are not huge tables like table B. So idea...

SQLKnowItAll (3/13/2012)

---

Well, I'd like to turn the topic to why this would be used. Would I do a top 100 with a FAST 100? It seems needless to...

Kill them! Kill them! Kill them!

😀

That what I've thought from the beginning...

Look's like nothing better to discuss on Tuesday evening :hehe:

SQLKnowItAll (3/13/2012)

---

Ok, let's settle this. Its not about returning found rows faster or immediately. Its about FINDING the n rows faster (possibly), which as a direct result will...

No, you didn't! However, if you try to populate data in...

Or, even simpler:

delete post

from swap Pre

join swap Post

on Post.id = Pre.pre

and pre.id = Post.post

and...

I'm not sure if I'm correctly understood your reqs...

Still my try:

delete Post

from swap Pre

join swap Post on Post.id = Pre.pre

where exists (select 1 from swap linked

...

ok, let's correct my words:

It does not make query to run any faster! It just makes query to return required number of rows (n) immediately as they were found.

The...

It's defined as PRIMARY KEY CLUSTERED in the OP posted DDL...