Can't See My EXEC Results

[mickeyj2]

Hi,

I have the following which works fine, but I can't see the result set. I've been reading some of the posts and it appears that to see the result set requires a tiny miracle. I'm running this in Query Analyzer for now. Is there an easy way to see my result set, as I'm in the middle of testing things for now.

CREATE PROCEDURE GetCableList
( @CableList nvarchar(250) )
AS
BEGIN
SET NOCOUNT ON
DECLARE @SQL nvarchar(500)
SET @SQL =
'SELECT CableID, BoardModelID
FROM CableMapping
WHERE CableID IN (+ @CableList + )'
print @SQL

END
GO

EXEC GetCableList '1,2,3,10'

Thanks in advance for any help you can provide.

mickeyj2

 

[nice95gle]

CREATE PROCEDURE GetCableList
( @CableList nvarchar(250) )
AS
BEGIN
            SET NOCOUNT ON
            DECLARE @SQL nvarchar(500)
            SET @SQL = 
            'SELECT CableID, BoardModelID
            FROM CableMapping
           [s] WHERE CableID IN (+ @CableList + )'[/s]
            WHERE CableID IN (' + @CableList +' )'
print @SQL

END
GO

EXEC GetCableList '1,2,3,10'

Well Done is better than well said
- Ben Franklin

 

[SQLDenis]

>>but I can't see the result set.

maybe because you don't have exec (@SQL) in your code?

yes, no, maybe so?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[mickeyj2]

That worked to give me the SQL that its running, and I just stuck the full SQL into my Query Analyzer and ran that. Thanks for your help.

 

[philhege]

You know that what Denis means is to replace "PRINT @SQL" in your SP with "EXEC(@SQL)", right?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.

 

[nice95gle]

I think what the OP was trying to do was show the sql string via the print command to make sure it was formatted correctly. He was not concat'ing the string correctly so he was seeing something like SELECT * FROM contact WHERE CableID IN (+ @CableList + ), instead of SELECT * FROM contact WHERE CableID IN (1,2,3,10).

Well Done is better than well said
- Ben Franklin

 

[mickeyj2]

Thanks all, but I think the easiest thing for me to do was to leave off the EXEC and just run {stored proc} {parms}.

Thanks for all of your help!