Viewing 15 posts - 7,861 through 7,875 (of 9,643 total)
You would use an Execute SQL Task, but it sounds like you could do this in a simple SQL Server Agent Job, unless you need the parameters to be set...
August 19, 2008 at 7:12 am
You can use nested IIF's or a Switch in the expression for background color on the control. Switch would work like this:
=Switch((colA*colB)/colA =25, "Yellow")
Of course I believe that...
August 19, 2008 at 7:09 am
Are you using RS 2000 or 2005?
I have tried your solution in 2005 and it is working for me. Try trimming the string, maybe there is whitespace at the...
August 19, 2008 at 7:01 am
What control(s) are you using?
In a table you could add this to your a group (the details row has a group as well):
=RowNumber(Nothing) Mod 100 = 0
If you...
August 19, 2008 at 6:52 am
There are no DMC's for SQL 2000. Another option is the SQL Health and History Tool (SQLH2) available from MS for free. I have not used it in...
August 19, 2008 at 6:38 am
Hey Jeff, good article. It's funny I have answered several forum questions recently using a Case embedded in an aggregate. They weren't crosstabs exactly, but similar. So,...
August 19, 2008 at 6:35 am
I can only recall having seen it once and that was in an index so you can drop and recreate the index to repair it.
August 18, 2008 at 2:52 pm
One of the rules I learned early was to limit round trips. Think about it this way. If I use 2 datasets that each return 1000 rows and...
August 18, 2008 at 2:30 pm
The issue is now making 2 round trips to the database, caching 2 execution plans. If you can avoid round trips your report will scale better. I have...
August 18, 2008 at 2:08 pm
Do you mean what permissions you should grant on his server or on the one he wants to connect to using a linked server?
In order to create a linked server...
August 18, 2008 at 2:05 pm
You need to include the user accessing the view across the linked server rights to the database and the view. A basic user does not have access to INFORMATION_SCHEMA.
August 18, 2008 at 1:42 pm
I don't think Chris was suggesting you use a temporary table, I think he was just using a temporary table to hold the test data so he could give a...
August 18, 2008 at 1:39 pm
Looks like the data is the number of seconds since 1/1/1970 so using the DateAdd function should work. Look up DateAdd on BOL for details.
August 18, 2008 at 1:11 pm
Why not have the function pass it back as a correctly formatted string? Are you doing more math with the result?
August 18, 2008 at 1:00 pm
Viewing 15 posts - 7,861 through 7,875 (of 9,643 total)