I agree with Gail. Further, it seems like a SurveyId would be a great candidate for the leading edge of the clustered index on most tables. This would store the...

No, it's pretty clear. Here's the first statement that jumps out:

And then,...

WOO HOO!

Another well deserved reward. That's terrific. Congratulations Gail. Holy cow, all the cool kids seem to be hanging out here now.

You're going to be at PASS?

You've got a beverage-of-your-choice coming from me. Track me down.

No way in the world to even suggest a solution without at least the execution plan.

Great. If you did need to pursue the CASE statements, you can't use "= LIKE." So you'd have to change

AND lc.locstring =

to

AND lc.locstring LIKE

Several problems where. A horizontal line is formatting. That's not what TSQL is all about.

Also, a UNION query doesn't necessarily return the rows from table 1 and then the rows...

Johann Montfort (7/2/2008)

---

Dear All

How can I write a stored procedure based on condition. At the moment, my code is not working. Here is my example

ALTER PROCEDURE [dbo].[FindStrings]

(

@uid bit,--...

It depends on the severity of the error. Higher severity errors cause a disconnect of the offending process. Those cannot be trapped.

For the other procedures, in SQL Server 2005, you...

That sums it up very well.

By the way, you're posting a SQL Server 2000 question in the SQL Server 2005 forum. While this question was fairly generic and the answer...

A full and hardy congratulations to you both. You deserved it and you earned it.

Yeah, yeah, I used the "depends" right at the beginning and added weasel words "in all likelihood"

I covered my behind.

😛

You have to put a "GO" statement between these two scripts. This seperates the two scripts into seperate commands so that they are processed independently by the server. That allows...

SrikanthSv (7/1/2008)

---

use views when the amount of data is less

If the amount of data which the stored procedure hits is huge then use the temp tables. Using temp...

We've got some development teams advocating for it's use right now. I'm trying to build a strong case on either a correct usage (and that DOES NOT mean object databases)...