Viewing 4 posts - 1 through 4 (of 4 total)
Thanks stax68 that is exactly what I am after.
Thanks for all the help for all those who posted.
Craig
June 19, 2003 at 1:22 pm
#462258
Muliple View are not a feasible option. The WHERE cause is being built dynamically on a web page and the number of columns possible are over 20.
Go back to...
June 19, 2003 at 12:27 pm
#462231
Cant do that because the WHERE must be done before the GROUP BYs that the VIEWS contain(granualarity of data issue).
I know it sounds like a job for a SP but...
June 19, 2003 at 10:03 am
#462190
Brian thanks a lot that answer is a life safer.
My only other issue : Does account with datareader have enough access to execute it. My initial test seems to...
June 6, 2003 at 12:27 pm
#460248