tbabs25 (5/14/2012)

---

Can anyone help me in coverting the output I am geting when a type in my select statement.

I get a number in return instead of data.

select va_title

from contact

and...

How are you getting all...

"The Guru's Guide to Transact-SQL", this is a good book for TSQL.

Try downloading the ebook.

Jeff Moden (5/12/2012)

---

Understood on there being thousands...

pgmr1998 (5/13/2012)

---

I do wish to post sample data, but, however, my employer has very private info and this would stir trouble. Can we please take this one step at a...

Thanks for posting the DDL of the tables. But you might as well do one last thing and that is post some sample data for the tables as a string...

Dev (5/12/2012)

---

Divide and Conquer.

Split the SP’s logic in few steps, create new SPs for each step and call each SP from application. Each SP can provide its own status (success...

Please check out the link in my signature and post the DDL, Sample Data and the Expected Result Set, the way it is mentioned in the link.

The...

Matthew Darwin (5/11/2012)

---

This is reminding me of a script I saw from a colleague to call a slow stored procedure several times over with different parameters; so instead of optimising...

Thanks for the link Lynn.

I'll see what can be done and get back to you.

Lynn Pettis (5/11/2012)

---

Unfortunately, can't give you much more as no one here can see what you see. Unless you show us what you are working with and how you...

Lynn Pettis (5/11/2012)

---

Even if it is possible, I am going to go out on a limb here and say it may not be practical to do so.

It all comes back...

Try this:

--Creating Table

Create Table Ex

(RecNum Int,

Patient_ID int,

Patient_FirstName varchar(10),

Emp_ID int,

Emp_FirstName varchar(10),

App_Datetime DateTime )

--Inserting Sample Data

Insert Into Ex

Select 1, 1234, 'John', 9876, 'Adam', '5/12/2012 9:00 am'

Union...

Lynn Pettis (5/11/2012)

---

Explain why you want delays inside your procedure(s) instead of having them finish as quickly as possible. What you are asking for really makes no sense from...