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 |
|
joe8079
Posting Yak Master
127 Posts |
 Posted - 2012-05-31 : 11:38:41
|
| Has anyone seen a situation where SSRS query designer can pull different results than management studio even though the code is exactly the same? The code is using temp tables and I'm not sure if the SSRS query designer looks at temp tables differently than management studio. It almost seems like the data in the temp table is getting dropped in SSRS query designer. just wondering if anyone has ever seen this before. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-31 : 16:08:28
|
| nope...the resultset should be same in SSMS as well as in SSRS query designer. Only issue will be if you've multiple resultsets coming from SSMS in which case query designer will only take first resultset.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSRS Query Designer pulling different results