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 |
|
leon_irl
Starting Member
8 Posts |
 Posted - 2007-07-20 : 11:48:13
|
| I have migrated from 2000 to 2005 and I am seeing some strange behaivour .I run a Stored ProcedureSELECT a.Field1, b.Field2, c.Field3FROM a Inner Join b Inner Join c......If I run the SP in Management Studio I get the correct results set. But when I run it from an ODBC connectio (SQL Native) I get the 3 fields and also the Fields that the tables were joined on...?I do not get this if I run it through the standard sql server ODBC..Any Ideas |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-20 : 13:48:12
|
what is the full query? are you sure there's no * on the end of the select list?
elsasoft.org |
 |
|
|
leon_irl
Starting Member
8 Posts |
Posted - 2007-07-20 : 16:46:19
|
| jezemine, The Sql doesnt matter. It happen with even the simplest sql join and in all my Stored Procedures. It seems to be retuning the Identity fields of the joined tables.Im pulling my hair out at this stage..! |
|
|
|
|
|
|
Strange Behaviour