marksquall (4/25/2012)

---

To Thomas Stringer and Lynn Pettis:

Thank you very much Sir and Mam. It works. :w00t: ... 😀 ... :kiss:

Perfect combination...

QUESTION: why [font="Courier New"]SCOPE_IDENTITY()[/font] was used? Is...

The Dixie Flatline (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

The Dixie Flatline (4/25/2012)

---

Hi, Lynn.

Just... walk... away.

Don't look back again. Delete all those threads from your notification list.

Don't look at it and...

Yes. This -> message Report item not linked to a dataset

I'm not reposting any of my responses. You'll have to go to that thread to see what I have done.

Table variables...

Silver spoon time:

CREATE PROCEDURE ADDSTUDENT

@num NVARCHAR(20),

@fn NVARCHAR(50),

@mn NVARCHAR(50),

@ln NVARCHAR(50)

AS

BEGIN

...

Duplicate post (with a little more info). Please direct all replies here.

Please do not start new threads for problems you have already posted.

This problem

This stored procedure parsed correctly, but...

marksquall (4/25/2012)

---

Hello SQLCentral.com members and administrators,

A greeting of peace.

I want to ask help because I am having a problem in my stored procedure.

Before we head to the problem, these are...

The Dixie Flatline (4/25/2012)

---

Hi, Lynn.

Just... walk... away.

Don't look back again. Delete all those threads from your notification list.

Don't look at it and it will go away. ...

What is the exact error message you are getting?

Cut and paste it into this thread so that we may see it.

MisLead (4/25/2012)

---

There are many ways to accomplish the task, be it through T-SQL or SQLCLR, and while I empathize with your situation all methods are irrelevant if they do not...

Getting what error? You showed me the code like I asked, but I know nothing about the temporary table you are attempting to insert data into. For all...

capn.hector (4/25/2012)

---

SQLRNNR (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

I know that some of us have perhaps gotten a bit forceful when asking for additional information regarding problems that have been posted, but the questions...

I know I am going to regreat this, but, care to show us? Can't tell what you are doing based solely on your post.

I know that some of us have perhaps gotten a bit forceful when asking for additional information regarding problems that have been posted, but the questions in question have been...