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 |
|
Suhi100
Starting Member
14 Posts |
 Posted - 2015-02-22 : 14:59:36
|
| Hi,I am reading about stored procedures and i have looked at some them in a database,which was designed by a colleague. The concept is clear,but there is one piece of code,which I do not understand.There is an insert into statement:insert into DWH.[Employee](column1,column2,column3)select column1,column2,column3 from [database].[dbo].[VIEW_Employee]neither the table into which the statement perform the insert into ([Employee]) nor the other thable from which the column are selected are in the database. They not listed in tables or in views. They are not declared in the stored procedure either.Has anyone got some hints how tables/objects can be referenced if they not present in the database within table/views?many thanks |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-22 : 15:03:13
|
| Could it be that you do not have any permissions in the datatabase and/or the DWH schema and or the Employee table? |
 |
|
|
Suhi100
Starting Member
14 Posts |
Posted - 2015-02-22 : 15:48:12
|
| NoI have admin rights,I checked several times but those tables are not in the db.I know i can use TABLE as data type but there is no object declared as table in the stored procedure. |
|
|
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2015-02-22 : 16:39:28
|
| Why don't you go to the source (your collegue) and ask him/her? |
|
|
|
Suhi100
Starting Member
14 Posts |
Posted - 2015-02-22 : 16:43:05
|
| I certainly will when i canThanks |
|
|
|
Suhi100
Starting Member
14 Posts |
Posted - 2015-02-23 : 04:57:36
|
| Hi,sorry for your time on this topic I should have wait before posting this question because, those tables were deleted that's why not found.thank you |
|
|
|
|
|
|
Insert into schema.[table]