I totally agree with Eugene. I thought I might have a go at it just...

I will try one more time. Post some ddl (create table scripts) and sample data (insert statements). Incomplete sentence fragments and disjointed explanations will not generate much activity. I suspect...

There are a few ways to do this. I see that you are new around here and don't know about posting ddl (create table scripts) and sample data (insert statements)...

Take a look at the first link in my signature about best practices.

I am going to...

Lynn Pettis (9/20/2012)

---

Okay, a non-cursor way to accomplish this same task:

declare @SQLCmd varchar(max);

select @SQLCmd = (select 'exec insert_sp ' + cast(md.sid as varchar) + ';' + char(13) + char(10)

...

manub22 (9/20/2012)

---

Sean Lange (9/20/2012)

---

Yes it is true that sometimes you can't the code and that is exactly why I said he may be stuck with it. I would vehemently disagree...

manub22 (9/20/2012)

---

@sean-2, Cursors were never on bad performance, its upto you when and how you use them. Some developers use them very early rather than creating complex set based queries,...

F8R (9/20/2012)

---

Thank you for all hint and sugestion, I think I need to unlearn my 'old' knowledge, :D.

I'm new to Sql Server and honestly, I'm not very good at Database...

rocky_498 (9/20/2012)

---

Once again thanks and i understand what you saying, Here is the PROBLEM.

I can't convert or paste my store procedure here (8 Pages S.P) lot of logic involve....

If i...

The other possible query I can think of is SELECT INTO. This wont guarantee Atomicity and Consistency as the INTO table might still be created even if the transaction was...

rocky_498 (9/20/2012)

---

Hi guys thank you for your reply, I created below CURSOR and its work fine,

DECLARE @sidint

Declare InsertSID Cursor For

Select DISTINCT Sid from MDB

where ADate = dateadd(day,datediff(day,1,GETDATE()),0)

...

I am not...

Cursors are notoriously bad for performance and should be avoided except for maintenance tasks if at all possible. I suspect you don't need a cursor for this at all. If...

Can you try to explain a bit more clearly what you are trying to do? Take a look at the first link in my signature about best practices.

erics44 (9/20/2012)

---

Luis Cazares (9/20/2012)

---

At this moment, I wish I didn't post any response.

Your answers have been rude to someone that is trying to help you by giving a good advise.

This...