how 2 insert the value from a SP into a tmp table

can any one advice me on how to insert the results of a SP into a temp
table
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!INSERT INTO #tmp (col1, col2, ...)
EXEC procname
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Emil Henrico" <emil@.interres.co.za> wrote in message
news:u%23myVz9HFHA.3332@.TK2MSFTNGP14.phx.gbl...
>
> can any one advice me on how to insert the results of a SP into a temp
> table
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Something like
[script]
create table #MyTable(column1,column2,...,columnX)
go
insert into #MyTable (column1,column2,...,columnX) exec MyProcedure
[/script]
Cristian Lefter, SQL Server MVP
"Emil Henrico" <emil@.interres.co.za> wrote in message
news:u%23myVz9HFHA.3332@.TK2MSFTNGP14.phx.gbl...
>
> can any one advice me on how to insert the results of a SP into a temp
> table
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Emil
INSERT INTO #Temp EXEC sp
"Emil Henrico" <emil@.interres.co.za> wrote in message
news:u%23myVz9HFHA.3332@.TK2MSFTNGP14.phx.gbl...
>
> can any one advice me on how to insert the results of a SP into a temp
> table
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||
evry ting
execp the SP returns 10 vals and i only need to use 2 of them...
how do i do that
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Delete the others from the table after the INSERT. Or, a nasty workaround, i
s to call back to the
SQL Server as a linked server using either OPENQUERY or OPENROWSET and do SE
LECT TOP 2 from that
table valued function.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Emil Henrico" <emil@.interres.co.za> wrote in message
news:u46$uU%23HFHA.1476@.TK2MSFTNGP09.phx.gbl...
>
> evry ting
> execp the SP returns 10 vals and i only need to use 2 of them...
> how do i do that
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||let my try and explain better...itonly returns one row..with 10
Columns..i onle need 2 of those ..not all 10...
thisis my question ...
create table #test
( mktcode int, rttotal float,
)
insert into #test (mktcode, rttotal)
exec sp...but the reslut gives me culmun a,b,c,d,e,f,g,
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Well, with INSERT EXEC you get all. How about modifying the stored procedure
, or extracting the
relevant part of the procedure to make another suitable procedure. Or re-wri
te the procedure into a
table valued user defined function?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Emil Henrico" <emil@.interres.co.za> wrote in message
news:exVfFo%23HFHA.4076@.TK2MSFTNGP10.phx.gbl...
> let my try and explain better...itonly returns one row..with 10
> Columns..i onle need 2 of those ..not all 10...
> thisis my question ...
> create table #test
> ( mktcode int, rttotal float,
> )
> insert into #test (mktcode, rttotal)
> exec sp...but the reslut gives me culmun a,b,c,d,e,f,g,
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Create a temporary Table Variable, say @.Tmp,
Declare @.Tmp Table (
Col1 Varchar(20),
Col2 Varchar(20),
Col3 Varchar(20),
..
Col10 Varchar(20))
Only make the column definitions match the output of the stored proc.
Then Insert @.Tmp Exec SP -- This inserts all ten values into @.Tmp
Then Insert from @.tmp into your real table.
Insert #test (mktcode, rttotal)
Select Col3, Col 7 From @.tmp -- WHichever 2 columns you want
"Emil Henrico" wrote:

> let my try and explain better...itonly returns one row..with 10
> Columns..i onle need 2 of those ..not all 10...
> thisis my question ...
> create table #test
> ( mktcode int, rttotal float,
> )
> insert into #test (mktcode, rttotal)
> exec sp...but the reslut gives me culmun a,b,c,d,e,f,g,
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
>

Hotfix needed

Does anyone know how I can get the hotfix for 830466?
The kb article (http://support.microsoft.com/?kbid=830466)
says to contact microsoft customer service. When I ask for
free online support it asks for the product id. When I try
to check where the pid is, it's not listed. Our licenseing
folks have no idea what our pid is for sql server.
You can find the product ID in the registry key
HKLM\Software\Microsoft\Microsoft SQL Server\80\Registration\ProductID
Jacco Schalkwijk
SQL Server MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.
|||You can get a newer fix (878), which includes the fixes for 852, here:
http://support.microsoft.com/?kbid=838166
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.

Hotfix needed

Does anyone know how I can get the hotfix for 830466?
The kb article (http://support.microsoft.com/?kbid=830466)
says to contact microsoft customer service. When I ask for
free online support it asks for the product id. When I try
to check where the pid is, it's not listed. Our licenseing
folks have no idea what our pid is for sql server.You can find the product ID in the registry key
HKLM\Software\Microsoft\Microsoft SQL Server\80\Registration\ProductID
--
Jacco Schalkwijk
SQL Server MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.|||You can get a newer fix (878), which includes the fixes for 852, here:
http://support.microsoft.com/?kbid=838166
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.

Hotfix needed

Does anyone know how I can get the hotfix for 830466?
The kb article (http://support.microsoft.com/?kbid=830466)
says to contact microsoft customer service. When I ask for
free online support it asks for the product id. When I try
to check where the pid is, it's not listed. Our licenseing
folks have no idea what our pid is for sql server.You can find the product ID in the registry key
HKLM\Software\Microsoft\Microsoft SQL Server\80\Registration\ProductID
Jacco Schalkwijk
SQL Server MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.|||You can get a newer fix (878), which includes the fixes for 852, here:
http://support.microsoft.com/?kbid=838166
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.

Hotfix

http://support.microsoft.com/kb/916812/en-us

Does anyone know where I get the hotfix mentioned in the above article.

Thanks

-JW

From that article...

To resolve this problem immediately, contact Microsoft Product Support

Services to obtain the hotfix. For a complete list of Microsoft Product

Support Services telephone numbers and information about support costs,

visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

Note

In special cases, charges that are ordinarily incurred for support

calls may be canceled if a Microsoft Support Professional determines

that a specific update will resolve your problem. The usual support

costs will apply to additional support questions and issues that do not

qualify for the specific update in question.

|||

Yeah I read the article too. I was just hoping someone had a link to a download.

Thanks

-JW

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
TerryIt's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
>
> > We are looking at the possible deployment of the SQL 2005 hot fix
> > described inhttp://support.microsoft.com/kb/916002#appliestoto
> > resolve connection issues with .net to SQL. However, we are unable to
> > determine if this hot fix has any prerequisites (such as sp1), or if
> > it fixed in sp1 or even in sp2. I have searched extensively online,
> > and I do not see this as fixed in any service pack documents (although
> > the lists are seldom complete), and the prerequisites are missing in
> > the KB article.
> > Any help would be appreciated.
> > Terry- Hide quoted text -
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps :)
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...that
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product that
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps :)
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
> > The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> > this is not a SQL hotfix?
> > Terry- Hide quoted text -
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
TerryIt's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
>
>
>
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...th
at
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product th
at
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
>
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
Terry
It's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegro ups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>
|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegro ups.com...
>
>
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry
|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>
|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...that
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product that
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
>
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry