Bitbucket:

Thanks for you assist, but i think i'm looking for something that deals directly with exporting in the excel format from SSRS 2005. When ever i export a report that...

I just want to give each worksheet tab a name other than Sheet1, Sheet2, Sheet3.

oh quite nasty!!!

Thanks!

Yeah, i'm totally with you on that, but the problem is this is a stored proc & if i do what you suggest, i receive an error because i'm doing...

Is there any way to get a @variable to work as a table name?

i.e.

Select * from @tablename

:unsure:

Hi:

I have a kinda sorta similar situation.

insert @Tmp SELECT SignalID from ReportLogConfig WHERE OPCPath is not NULL and Location = @Location

EXCEPT SELECT SignalID from @lTableName

I'm trying to...

Yeah, i figured out a way to do it that might not be as fast as i want, but it does the trick.

thanks for the idea

Jack:

thanks for your reply!

heres the dataset:

CREATE TABLE #TempStorage (

[pkRecordKey] [char] (17) ,

[SignalID] [smallint] NOT NULL ,

[LocalTime] [datetime] NULL ,

[fValue] [float] NULL ,

[bValue] [bit] NULL ,

[sValue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...