...

Also, to be able to "make the best use of the underlying DB engine" you must acquire a deep knowledge of the DB engine, and I am not interested in...

In short: No, there is no way, without stopping your "software" to change your original query.

fmuzul (3/11/2013)

---

...

Maybe you live in a different world than mine. For me the redeploy of an application is not a problem, I just need to replace a .exe file, and...

Is wiki independent enough for you? http://en.wikipedia.org/wiki/Stored_procedure

Typical...

It prefers to start with curios, little elephants, actually......

Calling statement! :w00t:

I'm afraid you will not find many SQL...

Van Heghe Eddy (3/10/2013)

---

Using stored procedures has also the following benefits.

Security : dba can determine who can execute what

Tuning : mostly stored procedures are written by sql developpers who mostly...

Curiosity is a great thing!

Without it, elephants wouldn't have trunks...

What does the Crocodile have for dinner?...

:hehe:

Ok, if the data and output requirements OP provided this time are right, then the following should work for him:

DECLARE @UnitConvert table

(

ID int identity(1,1),

ConvertUnitOne...

dwain.c (3/11/2013)

---

Of course, I could be wrong as Eugene has proven in the past.

I think his query may be workable. All you'd need to do is UNPIVOT the two...

vahid.arr (3/11/2013)

---

I want to combine this select statement and a variable(@EndUserDel) to get result.how can i do that?

declare @EndUserDel nvarchar(20)

select * FROM [dbo].[Service]

i want this...

UNION ALL SELECT 2000,1000

UNION ALL SELECT 2000,700

doesn't look like a chain to me, is it valid combination? Can ConvertUnitOne point to two different ConvertUnitTwo?

If it's not valid, than you...

Eugene Elutin (3/11/2013)

---

You can also create new clustered index with DROP_EXISTING option, except it will happen in one transaction, so it may not safe too much of time. I guess...

You can also create new clustered index with DROP_EXISTING option. I guess it's equivalent to dropping and re-creating non-clustered indexes manually. However, if index you're going to drop is participating...

And what is the problem?