August 10, 2011 at 9:17 pm
Hi All,
I want to have a general statement which depending on the parameter I provide will create a view with the column names from the tables.
This can be any number of ciolumns and from any number of tables.
Please share teh script.
"More Green More Oxygen !! Plant a tree today"
August 11, 2011 at 8:10 am
Minaz Amin (8/10/2011)
Hi All,I want to have a general statement which depending on the parameter I provide will create a view with the column names from the tables.
This can be any number of ciolumns and from any number of tables.
Please share teh script.
You want a script that will generate a view for any given table or tables? You mention any number of tables. Are you suggesting you want a script that can dynamically build all your joins because you pass in several table names? If you are wanting the general syntax for creating a view you can find it here.
_______________________________________________________________
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/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply