Assuming joel is required, the following 656 results were found.
-
Some memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO --...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
So I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
T-SQL DateTimestampshttps://joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html
My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Drop If Object Existshttps://joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html
What? Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
What? This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB