bawinkley (7/23/2013)
I'm pretty sure you cant use variables in views, I have decided to take them out which isn't the end of the world.I haven't worked out how to create a table on a scheduled task yet but i think the above method is better for this purpose.
Thanks
As Gail already suggested you can use inline table valued function and can pass those two parameteres in that..........
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/