Calling a Stored Procedure from a View

Question

Post reply

Calling a Stored Procedure from a View

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

CrazyMan SSChampion Points: 12560 More actions · Answer 1

Got you, but let me ask my Java architect, wether he can cache a function,

Thanks Gial

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

Caching if any rows exist in a table does not seem like it would be very useful. Why are you trying to cache this information? What caching mechanism is being used that cannot execute a stored procedure?

I would take a good-hard look at the proposed architecture. It sounds like it has some holes.

GSquared SSC Guru Points: 260824 More actions · Answer 3

CrazyMan (7/22/2008)
Sorry i dint mention , i am passing 2 parameters to the table,
the View has to check on this 2 conditions and then return the 2 values and the status as a result

You can't pass parameters to a view. It'll have to be a proc, udf, or the front-end (or data connection layer) will have to build the query dynamically.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

CrazyMan SSChampion Points: 12560 More actions · Answer 4

Hi Earl

Thanks for the Post 🙂

I am not sure about Java side, this is what i got from my Java architect, he said that caching cant be done if it is not in a form of table, so view is the way, he said that he cant cache SP, i have created a UDF that returns a table and accepts parameter and he can use a select statement to execute the view,

Can SP cached on Java?? please let me know if this is the case.

let me see whats the reply, waiting for his mail

Cheers

🙂

CrazyMan SSChampion Points: 12560 More actions · Answer 5

Thanks for all the post, I have created a UDF and my java architect is going to use that to cache into his code

Cheers

🙂

phderop Grasshopper Points: 12 More actions · Answer 6

If you need the values of a temp table you first want to create through a sp, then why don't you use a common table expression.

WITH cte AS

(

SELECT your fields

FROM table

)

SELECT ...

FROM cte

Note: I believe this is only possible as of SQL2005