Viewing 15 posts - 2,236 through 2,250 (of 3,489 total)
Might just be me, but I'm not entirely sure I'm following. Could you please post some sample data and the expected solution? Are you allowed to write stored...
September 30, 2015 at 12:45 am
Wouldn't you use Integration Services for that?
Create a package that does what you want, and then create a schedule for it.
September 30, 2015 at 12:40 am
You could try using BCP OUT with a format file...
https://www.simple-talk.com/sql/database-administration/working-with-the-bcp-command-line-utility/
September 29, 2015 at 9:26 pm
Why not
=IIf(Fields!GrandTotalBillableRatio.Value >= 2.0, "Green",
, IIf(Fields!GrandTotalBillableRatio.Value >= 1.75, "Yellow",
, IIf(Fields!GrandTotalBillableRatio.Value >= 0, "Red", "Silver")))
September 29, 2015 at 8:23 pm
write a stored procedure to insert the results of the DMV into a table in your database and then call it from the command line?
September 29, 2015 at 6:03 pm
Are you reporting against a live database or a read-only copy?
September 29, 2015 at 11:29 am
Huh? This has nothing to do with the problem.
September 28, 2015 at 4:12 pm
execute a select statement with the same filter to make sure you don't get any false positives, and when you've fixed that part, use the filter/where clause in your update...
September 28, 2015 at 3:58 pm
It should. It will update every record that would be selected by the filter, though. So you may update more records than you intended to.
September 28, 2015 at 3:46 pm
What happens if you go into SSMS and attach? Right-click on the databases folder and choose Attach... then do you see your files when you browse?
September 27, 2015 at 6:47 pm
Probably the easiest way to do this is to have an auxiliary Calendar table that you use to make this really easy. There are several articles here with examples...
September 25, 2015 at 10:13 pm
If you can find the code from one of the sadly dead and gone Access <version> Developer's Handbook: DESKTOP, you might find the code for it. If I recall...
September 25, 2015 at 12:26 pm
Okay, that's weird. Works if I create SQL for the query in Access then paste it into the Query window. Otherwise, doesn't seem to work. Maybe the...
September 24, 2015 at 7:50 pm
Multi-valued fields are evil.
Break the multi-valued field into a separate table and use that.
September 24, 2015 at 2:51 pm
Helpful explanation. Makes thing easy!
Note: I have a Report parameter that is of type Date (so when it runs you can pick a date from it...), it's called "prmOrderMonth"
This...
September 24, 2015 at 12:18 am
Viewing 15 posts - 2,236 through 2,250 (of 3,489 total)