Posted by 
One of the things with SSRS subscriptions is that they create a load of Agent Jobs that don’t clearly link back to specific reports.SQL warns you not to mess with these directly, so you need to find the report and remove or edit the subscriptions via the SSRS interface.We had loads that were expired, but the question was, what reports to t...
0
Barnsite's Blog
Following on from exporting a DataGridView to a CSV file someone asked this week if it’s possible to copy the contents to the clipboard for pasting into another application.The code below copies the content of the passed DataGridView to the clipboard inserting the specified delimiter between each column.The basic idea is to scan each row a...
This post assumes you know how to create a basic SSRS report and link it to a SQL Stored Procedure.We were starting to build up a fair number of SSRS reports that the users were running on an ad hoc basis. Initially I was emailing links to each individual report and people were saving them to their favourites. It wasn’t long before I realised...
There are many phone scams where someone will ring you claiming to be from Microsoft, Dell, Apple, or some other known IT company.They will tell you that they have detected issues with your computer, normally “security” issues.They will often ask you to open the “Event Viewer” on your computer to show you the errors.They will then ask you to go...
There are many phone scams where someone will ring you claiming to be from Microsoft, Dell, Apple, or some other known IT company.They will tell you that they have detected issues with your computer, normally “security” issues.They will often ask you to open the “Event Viewer” on your computer to show you the errors.They will then ask you to go...
Okay, expanding on what I did yesterday.I Built a table, called ExclusionList with one field, ExcludedTextE.g.Then created a function:CREATE FUNCTION [dbo].[udf_clean_string] ( @string VARCHAR(100) ) RETURNS VARCHAR(100)ASBEGIN SELECT @string = REPLACE(@string,ExcludedText,'')FROM ExclusionListRETURN @stringYou can then use like this:SELECT d...
Okay, expanding on what I did yesterday.I Built a table, called ExclusionList with one field, ExcludedTextE.g.Then created a function:CREATE FUNCTION [dbo].[udf_clean_string] ( @string VARCHAR(100) ) RETURNS VARCHAR(100)ASBEGIN SELECT @string = REPLACE(@string,ExcludedText,'')FROM ExclusionListRETURN @stringYou can then use like this:SELECT d...
Ok, I’ve seen many ways to do this using loops, but nothing in plain T-SQLLet’s say we have a string that may contain illegal characters, in my case it was project identifiers that needed to be used as file names for exporting. However, many had / or * in the names.One thing I hate in T-SQL is loops, so having only found looping ways...
Ok, I’ve seen many ways to do this using loops, but nothing in plain T-SQLLet’s say we have a string that may contain illegal characters, in my case it was project identifiers that needed to be used as file names for exporting. However, many had / or * in the names.One thing I hate in T-SQL is loops, so having only found looping ways...
I wanted to be able to populate menu items from a database, i.e. I had a Print Document top level menu item and I wanted to be able to populate the children from the database dynamically with each available document.
The theory was this:
1. Use the MouseHover event for the main menu item
2. When the user hovers over the item, get the list of...
The theory was this:
1. Use the MouseHover event for the main menu item
2. When the user hovers over the item, get the list of...
Recent Entries
My Picture
0 user(s) viewing
0 members, 0 guests, 0 anonymous users
Tags
Categories
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download
