Viewing 15 posts - 31 through 45 (of 53 total)
Hi There,
You shouldn't need to filter the dataset, that should be handled with a WHERE clause in your query. The user then selects from a list of Fee...
September 21, 2018 at 7:30 am
Are you not able to back up and restore the database, assuming you want the data as well?
Alternatively you could generate scripts for objects and then execute the...
September 21, 2018 at 7:22 am
Do you have SSRS installed? You could create a simple report based on the output of the query.
You could then either set up a subscription which could run...
September 21, 2018 at 6:22 am
Hi Jon,
If this doesn't exist you could use this example to build triggers to handle auditing then you would see what is being updated.
https://www.mssqltips.com/sqlservertip/4055/create-a-simple-sql-server-trigger-to-build-an-audit-trail/.
However check...
September 18, 2018 at 9:24 am
Hi Jon,
Just re-reading you OP you say you have a large table containing a list of countries with some being UNITED KINGDOM and some United Kingdom. Do they all...
September 18, 2018 at 9:11 am
Hi Jon,
You should be able to run a SELECT statement using that WHERE clause, and it should show you what you are about to update.
September 18, 2018 at 8:58 am
Hi There,
Have a look at this link. It looks like it details how manage subscriptions in your scenario.
https://ginameronek.com/2012/10/08/ssrs-subscription-administration-part-1/
Thanks
September 12, 2018 at 9:25 am
Hi There,
Do you actually want to sum the qty sent, and then end up with one row per client ID rather than trying to hide rows?
If...
September 12, 2018 at 9:18 am
Using the method above there doesn't need to be a gap. You can just call job b as soon as job a finishes.
Unless there is a valid reason...
September 6, 2018 at 4:24 am
You say that one job runs after another, therefore you could add a final step on the first job which calls the next job you want to run after the...
September 6, 2018 at 3:38 am
Could you not work it that final step of the first job calls the second job. Then they won't bump into each other?
September 6, 2018 at 3:10 am
Do you have SSRS available to you? If so it looks like a fairly straightforward report to build using that.
See example attached on building a matrix report with...
September 6, 2018 at 2:57 am
Do you have an incremental ID field or a datetime field with a datetime stamp in it? If so you could use an ORDER BY clause sorted descending on those...
September 5, 2018 at 9:21 am
In your flatfile what is the delimiter?
You should be able to reset columns within the flat file connection manager, and then choose the relevant delimiter.
September 3, 2018 at 9:13 am
Viewing 15 posts - 31 through 45 (of 53 total)