weelly — 2013-03-19T15:56:10-04:00 — #1
sorry to bother you but it's asked to me (my pm)
to create a view from a select like this
SELECT count(id) FROM mytable where field1 IS NOT NULL AND field2 > 1
I put 1 but it can be any other number like 3 ... 1000
All in all it worth create a view for a simple query ?
Thanks in advance.
r937 — 2013-03-19T16:28:26-04:00 — #2
in my opinion, no
besides, a view cannot accept a runtime parameter (e.g. value for field2), so you'd have to write a stored procedure instead
weelly — 2013-03-19T16:43:03-04:00 — #3
thanks it's also my opinion but .... ^^