It may have let your query run but I don't think it solved your issue. The problem is that the order by specifies a case sensitive sort order but the...

This is one of the reasons it is generally considered best practice to always include schema when referring to any object. And if the schema is not in dbo it...

I am not exactly sure I understand your question but the SUM function takes only 1 parameter and you are passing it two. If you can post some ddl(create table...

I still say you are asking for nothing but trouble trying to keep this stuff stored like this but if you are insistent on doing it then I would make...

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, 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)

...