Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
halexic
Starting Member
8 Posts |
 Posted - 2007-12-16 : 09:46:57
|
| Hello,I have a View that I use to get all values from User table and all type Names for that User from simple type tables (UserTypeName by User's SUserTypeId, StatusName by User's StatusId...)I have a table UserFeature which is ManyToMany table between Feature and User tables.I want to use one View named UserView in order to get somehow ali User's fields, Names from types table and all UserFeatures for every User record because I am using search and need to search also by UserFeatures and would like to this with one view if it is possible?Can I have variables and memory tables in View declaration? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-16 : 10:53:43
|
provide:1. DDL for all tables involved2. sample data for all tables. sample data should be in form of INSERT statements.3. expected output of view given sample data
elsasoft.org |
 |
|
|
halexic
Starting Member
8 Posts |
Posted - 2007-12-16 : 11:13:26
|
| Thanks I quit doing it in that way. Solved it in C# code after retrieving. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-16 : 11:16:18
|
good luck with that.
elsasoft.org |
|
|
|
|
|
|
View and child table