Also, it seems like your date calculations are starting to get rather complex.

For what you are trying to do there are some much more efficient ways...

Perhaps the following may...

You could theoretically have 2 additional params like @start, @end of type datetime that are defaulted to NULL.

Then you could do something like

if @timeframe = 'userdefined'

SELECT DefaultstartTime = @start,...

sorry about that, I guess that's what I get for reading things too quickly.

Can you put that info in the table header in your subreport and pass the project number...

You should be able to do this with a simple case statement...

Something like the following...

Update mytbl

SET col3 = CASE WHEN col1 >= col2 THEN col1

...

in a sub-report you don't get any header/footer info, only things from the body of the report that is your subreport.

-Luke.

Time to bust out the old tried and true It Depends...

It depends on how you are using the data in your table...

The normalization gurus will say that if all of...

Elaborating on Ray's reply...

You could create an SSIS Package and then you could call that from the stored procedure, by various means... using XP_Cmdshell, usign TSQL to add it to...

So I take it that's a no?

-Luke.

Please do not Cross post. This is the exact same post that was answered here with only 5 minutes in between posts... http://www.sqlservercentral.com/Forums/Topic632041-150-1.aspx

-Luke.

You should be able to use a Mod 2 to alternate the rows in your table. If this is a Matrix it becomes a bit more difficult, but if...

Can you open the spreadsheet using the \\NetworkPath\D22ml.xls bit from your machine, possibly from the run command? that will verify you have the appropriate rights to the share.

No chance...

heh, guess that's what happens when I forget to check previous posts after the phone rings...

-Luke.

Why cast to a varchar? If you're going to change to a different datatype, use something that doesn't allow a decimal like an int (bigint etc depending on your...

Even if you have a pretty decent automated install script, it would take a goodish amount of time. Just the resources consumed by that many instances all running the...

While I'm not a terribly active poster/responder I also use Gmail for this functionality and I'd have to agree it works really well.

-Luke.