drweb
Last Activity: Mar 17 '08, 04:29 AM
Joined: Jan 20 '08
Location:
-
I know how to create a stored procedure but i have to make one query instead of two views... -
I dont want any view....
i only want is to make one query instead of these two's.
and after that i'll make it a stored procedureLeave a comment:
-
By combining these two views iam getting a result...
I am developing a complete webbased solution in which i am required to have all the sql quries in procedures not in views....
so i simple want to combine into one query and make a stored procedure.Leave a comment:
-
Join these 2 views and make one stored procedure
i have made 2 views and concted them and my query is working find, but i want to make a 1 stored procedure from these 2 views ...
View 1
View 2Code:SELECT dbo.page_information.page_id FROM dbo.user_pages INNER JOIN dbo.page_information ON dbo.user_pages.page_id = dbo.page_information.page_id WHERE (dbo.user_pages.e_id = 32)
...Code:SELECT dbo.page_information.page_id
No activity results to display
Leave a comment: