Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
passing values of dynamic select statements into a variable
It creates a temporary table and of an insert of the result from the stored procedure. Example: create proc test as set nocount on select au_lname from pubs..authors go create table #test ( au_lname varchar(40) not null ) insert #test exec test select * from #test I expect to have helped.- dnascim
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Connections Passive Counter
It is utilizing the performace monitor for verify the NT40 with sp6 and Sql7 with sp3. In the counter "connection passive" the number they are very big and is adds to each 1 minute. What may be happening?
