What kind of result is your SP returning??....If you are doing it for the whole table then may be you can change the SP to a Table Valued Function and...

Let me put some more light on the requirement 🙂

One book may have many authors and co-authors which...

Yes, the output list contains the Author/publisher Names from a Table named "LibraryInfoMaster". The Where Clause uses the Views "View_LibraryBookAuthor" and "LibraryBookPublisher".

The difference here is because I want to select...

Hi guys,

Thanks for all the replies. I solved the problem. Well, technically... I didn't solve it, I took a Work around.

My Procedure had the following Query:

SELECT Distinct a.BookCode, b.MaterialType, a.BookName,

dbo.FN_GetLibraryBookAuthorPublisherNameNew(c.AccessionNo,a.BookCode,'AuthorName')...

O.K. no replies yet...that means I did something wrong.

I've simplified the requirement further.

The following query runs in 4 seconds on the above mention table having 40,000+rows bringing back the same...

Yes. The best option is always Count(). I agree on that with everyone.

This was not a Work related requirement. This was just a conceptual thing that I wanted to clear.

Someone...

Thanks for the reply Lowell.

I was looking for something a little more simple.

I started playing a little and came up with the following two queries of doing it without Count():

--Creating...

Cadavre (6/20/2012)

---

Well, I doubt I'd be the developer I am today (or have the job I currently have) without Jeff and a lot of other people from this site (way...

Very Nice Dwain.

I can swear by anything right now that we are thinking the same stuff.

I was working something like the query you posted and as soon as i open...

Hi,

Welcome To SSC!!!!

You table design seem good. No problems with it.

Regarding the Query you require for the result set, as Sean said it would be best to do it at...

There is very less information. You could may be post DDL and some sample data to elaborate on your requirement a little more.

From what I understand you are trying to Update the table.

You have two entries for the Code 'f'. So, these questions come to my mind:

1. You want to update both...

Yes, seems like it. Its good. 🙂

Ohh....Ok...so the last part is for the '&i&'.

Now I understand what the last part does.

But, still don't understand how it does it though.

Anyways, thanks a lot Dwain. It was really...

Oops!!!!....Sorry Dwain....didnt see your post...I guess...we were typing at the same time. 😀