Hi and welcome to SSC! Best thing you can do is get a copy of sql express. Then get a copy of adventureworks database. You can find both of those...

capn.hector (4/17/2012)

---

Sean Lange (4/17/2012)

---

hbtkp (4/17/2012)

---

OK ,IF I CANNOT HEN how can i store my logic which include execute sp and returns 1 value

i need to call this value in case...

sqlfriends (4/17/2012)

---

This is hard for me too everytime to post on T-SQL forum, try to make it simple to get some hint, and not post all complicated table structures...

Hi and welcome...

hbtkp (4/17/2012)

---

ok. i will go through book.

right now i need 1 solution

i have created 1 sp, and in that i am calling another sp.

now

this sp returns 1 float value

that...

That's the way I read it too Lynn. Pretty clear that is how the assignment was made.

Or even better get rid of that cursor entirely. There does not appear to be any reason for a cursor from what you have posted. If you want some help...

What is the question?

Does this help?

PiMané (4/17/2012)

---

Sean Lange (4/17/2012)

---

When looking at your query again...do you have anything resembling even medium amounts of data. Your where clause has at least 2 UDFs. The performance will degrade...

If at all possible you should not use ntext. It deprecated and the performance is horrendous. Instead you should use nvarchar(max).

When looking at your query again...do you have anything resembling even medium amounts of data. Your where clause has at least 2 UDFs. The performance will degrade exponentially as the...

It sounds like all you need is a join to that table. Without ddl and some sample data it is pretty hard to tell.

I agree. Unless this is an extremely complicated report there really shouldn't need to be queries that take more than 30 seconds. More often than not when devs start exploring...

Not sure I understand. You are wanting to copy production dbs back to dev? Just back them up and restore them on dev.

Just a shot in the dark because it is pretty unclear what you want for output.

SELECT main.dq_src_id,

main.dq_org_dist_id,

...