Just so you know, sometimes it is better to break things up like you have then trying to do it all in one query. Trying to do everything in...

Hey, long time no see! How are you doing?

SQLRNNR (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

OMG! What a surprise! I told him that in my response back showing him how he could execute the stored procedure and see what values...

I don't know if the answers are getting worse, but I can see that there seems to be a lack of comprehension when it comes to reading some of the...

Have you fixed the code you posted earlier to create your test procedure and try running it with the code I gave you?

OMG! What a surprise! I told him that in my response back showing him how he could execute the stored procedure and see what values were being returned....

itskanchanhere (3/23/2012)

---

No there is soem syntax problem in the create procedure .. i dint try it before posting.. Anyways what id the calling application is a separate group that does...

Also, look up EXECUTE (EXEC) in Books Online if you want more info on how it works and its syntax.

Create your stored proc (after fixing your create statement) and give the code I gave you a try. You asked...

You should be concerned that your code...

I created your procedure in my Sandbox database (by the way, your create proc statement is missing something).

You can run the procedure like this to see what is being returned.

DECLARE...

I got it wrong, but I was sure I had clicked the two correct answers. Guess I just thought I had.

Good question.

Or you could do this from Books Online:

J. Using TABLESAMPLE to read data from a sample of rows in a table

The following example uses TABLESAMPLE in the FROM clause to...

Read the first article I have referenced below in my signature block regarding asking for help. It will give you step by step instructions on what and how to...

emmettjarlath (3/21/2012)

---

Hi,

I have attached a snippet of the stored procedure. I inherited this database when I started this job. When the stored procedure runs it pulls information from table A...