SSRS 2008 - multiple select in store procedure

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

SSRS 2008 - multiple select in store procedure

Author

Topic

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2012-08-28 : 13:53:14

How can i display this 3 columns in SSRS dataset?
cause In my dataset I see only the first field "number"

create proc a
as

select 1 number
select 'daniel' name
select 'yyy' company

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2012-08-28 : 14:22:35

[code]create proc a
as

select
1 AS number,
'daniel' AS name,
'yyy' AS company[/code]

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-29 : 13:05:31

quote:
Originally posted by basicconfiguration

How can i display this 3 columns in SSRS dataset?
cause In my dataset I see only the first field "number"

create proc a
as

select 1 number
select 'daniel' name
select 'yyy' company

for hardcoding values you can even set this up in ssrs itself rather than using a proc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources