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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-09-20 : 05:09:40
|
| Hi All,I am designig simple report where I am calling one stored procedure.but I am getting one error like"TITLE: Microsoft Report Designer------------------------------Could not generate a list of fields for the query.Check the query syntax, or click Refresh Fields on the query toolbar.------------------------------ADDITIONAL INFORMATION:Invalid object name '#AuditCode'. (Microsoft SQL Server, Error: 208)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476------------------------------BUTTONS:OK------------------------------"I have checked in SP where logic is that create temp table and do some logical work and again drop that temp table...Whats wrong with it???T.I.A |
|
|
|
|
|
Cannot handle temp table in running SP in Reports?