I will try to replace NOT IN with LEFT JOIN and filtering out with left column of left table IS NOT NULL. It had helped me in many cases.

dwain.c (4/7/2015)

---

Walton (4/7/2015)

---

Hello All,

I have one stored procedure being called by the job that runs everyday. It generally takes 2-3 minutes to run. But sometime, for some reason it hangs...

Its a same data and there is not blocking issues. When I take our the code and run manually (Out side the stored proc) on the same server(prod), it has...

Hi Sean,

Here are the DDL and sample data.

Thanks a lot for spending your time on it

CREATE TABLE #temp

(set_id INT

,product CHAR(5)

,attribute INT)

--insert set 1

INSERT INTO #temp

(set_id, product, attribute)

VALUES

(1,'A',10)

,(1,'A',11)

--insert set 2

INSERT INTO...

Sean Lange (8/19/2013)

---

Walton (8/19/2013)

---

Hi all,

I need a help on getting the distinct set.

My Data look like this:

SET 1

SET ID Product Attribute

1 ...

Thanks Lowell

It helped me to solve the problem.

I am still wondering, if there is any other way to store the superscript on the table without using HTML.

Thanks again.

Trying to do "SM" as superscript. No lucks yet:(.

It was an interview question. And no other information was provided.

Thanks Jon Fox. It worked perfectly.

I am talking about the store proc on SQL Server. Store proc is passing the numeric value always. But looking at the numeric if it is INT(meaning numeric value without...

Thank you Sean,

We are not running the query SSMS we put query itself in some application which will take select statment only.

Thank you guys. I don't think it doable. But I was giving a try if there was way arround.

Just to clarify the proc will take one parameter, process that...

Here is what I want.

exec @return_value1=my_proc @para1

exec @return_value2=my_proc @para2

exec @return_value3=my_proc @para3

I have a situation where I can run only one select statement which will have all return value from the...

Yes it does. Thank you guys!!!

Thanks.

It's been while I started working on SQL. But never faced this minor thing:-D

Thanks a lot.