Posted by 
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...
0
Barnsite's Blog
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...
As part of a basic guessing game I wanted to be able to shuffle an array of n chars into a random order.
The method I decided to use was the following.
Create a loop to iterate n times (where n is the number of elements in the array). Randomly select one array element and add this to a new array. Replace the removed item with the last item in...
The method I decided to use was the following.
Create a loop to iterate n times (where n is the number of elements in the array). Randomly select one array element and add this to a new array. Replace the removed item with the last item in...
Just a quick example of loading data into a data reader using C#. My data source is MS SQL Server in this case, although you would just need the correct OLEDB connection string to use any other data source.
//database connection string & SQL Statement to return SERVICE_LEVEL_ID and DEFINITION from a table called property.SERVICE_LEVEL
string...
//database connection string & SQL Statement to return SERVICE_LEVEL_ID and DEFINITION from a table called property.SERVICE_LEVEL
string...
If you’re here you have probably found that if you’ve deployed a report to your server updating the default parameter values and redeploying has no effect on the server report.
E.g. I had a report with an integer parameter with a default of 25 that had been deployed to the server. On my development machine I updated the default value and...
E.g. I had a report with an integer parameter with a default of 25 that had been deployed to the server. On my development machine I updated the default value and...
Quick example of how to display an image control that loops through a folder of images.
Firstly drop a timer control onto your form (name: tmrNextImage), set the Interval to 1000 milliseconds (1 second) and set enabled to true.
Next drop a PictureBox control onto your form (name: imgPicture) and set SizeMode to Zoom (this will force your image to fit the...
Firstly drop a timer control onto your form (name: tmrNextImage), set the Interval to 1000 milliseconds (1 second) and set enabled to true.
Next drop a PictureBox control onto your form (name: imgPicture) and set SizeMode to Zoom (this will force your image to fit the...
In my earlier post () I showed how you can iterate through folders and add the folder names to a list (lstDirs). The problem with this code was that if you encountered a folder you didn’t have access to it all fell over. Below I’ve added a function to test the folder access (canReadDir()), if the folder is inaccessible the path is added to...
Having to write some SQL SELECT’s on some un-normalized tables left me thinking there has to be a tidier way. I started with:
SELECT
*
FROM bags.SAC_LOG
WHERE [SCANNERID_1] = @SCAN_ID
OR [SCANNERID_2] = @SCAN_ID
OR [SCANNERID_3] = @SCAN_ID
OR [SCANNERID_4] = @SCAN_ID
OR [SCANNERID_5] = @SCAN_ID
OR [SCANNERID_6] = @SCAN_ID
OR [SCANNERID_7] =...
SELECT
*
FROM bags.SAC_LOG
WHERE [SCANNERID_1] = @SCAN_ID
OR [SCANNERID_2] = @SCAN_ID
OR [SCANNERID_3] = @SCAN_ID
OR [SCANNERID_4] = @SCAN_ID
OR [SCANNERID_5] = @SCAN_ID
OR [SCANNERID_6] = @SCAN_ID
OR [SCANNERID_7] =...
When running the SQL Server Installation Centre I was receiving the above error. This seems to be caused by the software being installed to a temp folder which is subsequently deleted post install.
Mine had been installed from a folder on the network. Even pointing to this folder when prompted didn’t resolve the problem.
Solution that worked for...
Mine had been installed from a folder on the network. Even pointing to this folder when prompted didn’t resolve the problem.
Solution that worked for...
Recent Entries
My Picture
0 user(s) viewing
0 members, 0 guests, 0 anonymous users
