jbalbo (1/27/2015)
Thanks for the info, definitely helps...I was also wondering if I was using the view Gui interface where I can pick tables or other views if I can point it to another database so the choices that come up are from that database. So lets say I am writing views on "reporting" database but I am getting my data from "data" databse. Whne I start my view and choose the gui the list of tables comes from "Data" but I am writing it in" reporting" databse Its not a big deal just wondering if I could set it to look at the other databse
No. And honestly you shouldn't be using the gui to generate views. You should write them in code, you have a lot more control. It may be a little bit slower at first but pretty soon you will be able to write queries much faster than the gui wizards can.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/