Viewing 15 posts - 1,216 through 1,230 (of 2,010 total)
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...
January 13, 2009 at 2:12 pm
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,...
January 13, 2009 at 2:08 pm
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...
January 8, 2009 at 1:09 pm
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
...
January 8, 2009 at 12:58 pm
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.
January 8, 2009 at 12:48 pm
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...
January 8, 2009 at 12:29 pm
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...
January 8, 2009 at 12:23 pm
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.
January 7, 2009 at 7:42 pm
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...
January 7, 2009 at 7:41 pm
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...
January 5, 2009 at 1:53 pm
heh, guess that's what happens when I forget to check previous posts after the phone rings...
-Luke.
January 5, 2009 at 1:46 pm
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...
January 5, 2009 at 1:45 pm
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...
January 5, 2009 at 1:21 pm
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.
January 5, 2009 at 1:13 pm
Viewing 15 posts - 1,216 through 1,230 (of 2,010 total)