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 |
|
asif372
Posting Yak Master
100 Posts |
 Posted - 2011-04-23 : 16:07:27
|
| i have developed a procedure naming i want to insert its data to temporary table i have worked like this but exception coming"EXECUTE cannot be used as a source when inserting into a table variable."i have worked like thiscreate proc asasasselect USERID,CHECKTIME from CheckInouti call procedure like thisdeclare @ttt table (USERID int,CHECKTIME datetime)insert into @tttexec asaskindly help Thanks In Advance |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-23 : 16:14:30
|
| I'm guessing you're using an old version of sql server. Can't remember when this came in.You'll probably have to us a temp table rather than a table variable.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
asif372
Posting Yak Master
100 Posts |
Posted - 2011-04-23 : 16:23:47
|
| i am using sql 2000 kindly help me how to solve this problem using sql 2000 thanks |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-23 : 16:26:20
|
| Use a temp table rather than a table variable.create table #ttt (USERID int,CHECKTIME datetime)insert into #tttexec asas==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
asif372
Posting Yak Master
100 Posts |
Posted - 2011-04-25 : 01:37:08
|
| I have Tried This but Same Problem Occurs that execute cannot be use in Insert Function |
|
|
|
youky
Starting Member
5 Posts |
Posted - 2011-04-25 : 02:34:56
|
| unspammed |
|
|
|
|
|
|
insert procedure data to temporary table