Here's a real-life challenge I was faced with at work: my company (a talent agency) needed me to create a report listing all of our actors that we represent - and for each actor, a comma-delimited string of each production that they've starred in. Simple enough, right......except that, within the comma-delimited list of productions, they […]
2003-04-11
765 reads
This is a follow-on to info's script to strip the time portion of a datetime or smalldatetime, leaving only the date. I found info's script interesting! When I had to do this I converted the date to varchar and back again instead of to float. Seems to work fine for me.
2003-04-03
116 reads
User Defined function to parse a string with known delimiters and return back the substing in the position.Takes string,delimiter and position as parameters. Can be used directly in TSQL code.
2003-03-27
328 reads
Brian Knight recently had the basic need to retrieve a record from the database at random. What seemed to be an easy task quickly became a complex one. This case showed an interesting quirk with T-SQL that was resolved in an equally quirky way. This quick article shows you a method to retrieve random data or randomize the display of data.
2003-03-26
9,369 reads
Each week you are required to run various reports based on table entries made during the week preceding latest Sunday. Use this SQL7/2000 procedure (can be a UDF in SQL2K) to retrieve the latest midnight of a specified day of the week as illustrated below: Declare @StartDate datetime, @EndDate datetime Exec DBAservice.dbo.uspGetLatestWkDayMidnight @pDate = '1998-05-06', […]
2003-03-13
308 reads
Do you hate using bitwise operands? I do, a lot. I wrote the following function to try to minimize the need for using them. When testing 'status' variables in the 'sysobjects' table, for example, I decided there just had to be an easier way to see if bit 31 is set than asking if STATUS […]
2003-03-07
715 reads
You can use this procedure to find any word or sentance, which u used in procedures, views, triggers and function. This procedure is basically a modified form of system procedure "sp_helptext". Now its upto you to use that and modified that. To execute the procedure, first create it in your Database and then execute it […]
2003-02-24
144 reads
This is a little script I wrote before I saw Steve Jones write up on Tame Those Strings Part 7. This is a slightly diffent approach. It will take a string up to 255 chars and case every word first letter upper and the rest of the word lower. This ain't the best way but […]
2003-02-20
403 reads
Ever wanted to know how to reuse identity values after they're deleted? In this example by Dinesh, he shows you two methods to reuse the wholes in identity rows.
2003-02-18
8,704 reads
Steve Jones recently got bit by a bug the reminded him of the Y2K fiasco. Read about the problem and how Steve solved the problem.
2003-02-17
4,612 reads
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Hi If value is 21000030 it should return 4 not 5 . In first...
This is one of those things very hard (for me)to explain in words. See...
Comments posted to this topic are about the item Feeling your age? How would...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers