Tag Archives: sql server

Clear Up SSRS Subscriptions

Posted on June 12, 2018 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 … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment

Simple SSRS Menu

Posted on May 24, 2018 by

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 … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Remove Characters in String T-SQL with No Loop Part 2

Posted on May 10, 2016 by

Okay, expanding on what I did yesterday. I Built a table, called ExclusionList with one field, ExcludedText E.g. Then created a function: You can then use like this:

Posted in Programming | Tagged , , , , | Leave a comment

Remove Characters in String T-SQL with No Loop

Posted on May 9, 2016 by

Ok, I’ve seen many ways to do this using loops, but nothing in plain T-SQL Let’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 … Continue reading →

Posted in Programming | Tagged , , , , , , | Leave a comment

Showing Two Different Scales on Y Axis SQL Server Reporting Services (SSRS)

Posted on July 26, 2013 by

Long time, no post… I was asked to create a graph showing throughput of bags on a conveyor grouped into 5 minute intervals.  One of the requirements was to show two scales on the Y axis, bags / 5 minute … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment

Search for Value in Multiple Columns SQL Server T-SQL

Posted on December 4, 2012 by

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: (@SCAN_ID is a variable declared earlier) I ended up with: Maybe not a massive improvement, but personally … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment

Browse for SQL Server 2008 R2 Installation Media

Posted on December 3, 2012 by

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 … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

SQL Server 2008 R2 Maintenance Cleanup Task Not Deleting bak Files

Posted on November 30, 2012 by

I noticed that my old backup files were not being deleted despite my Cleanup Task being set to delete all bak files more than a day old. Having checked, and double checked the path, file age, etc. I decided it … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Multiple OR’s in T-SQL WHERE Condition SQL Server

Posted on November 30, 2012 by

Just been rewriting some SQL Server stored procedures for a client. There were a lot of SELECT statements like the one below: I’ve seen this quite a few times, and I’m not suggesting this is wrong, however I find that … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment

Parametrised SQL Server Stored Proc From ASP.net / C# / OLEDB

Posted on November 14, 2012 by

Lets assume that we have a stored procedure that is defined in the following way, it doesn’t really matter what the actual body of the SQL is: We want to be able to call this procedure from an ASP.net page … Continue reading →

Posted in Programming | Tagged , , , , , , , , , | Leave a comment