Un-concatenating row values
/* Anith Sen's achievement, in his article 'Concatenating Row Values in Transact-SQL' has been to list and illustrate the many ways...
2008-10-06
1,747 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Never say 'never' to the WHILE loop.
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,217 reads
IT Project Euthanasia
A guest editorial from Phil Factor on the kindest way to dispose of unwanted IT projects.
2008-05-26
155 reads
Every DBA's nightmare
When a copy of all 25 million of the UK’s child benefit records, including bank details, went missing in the post, whilst being sent to the NAO (National Audit Office) on 18th October, the UK government must have known that a cover-up was impossible. This sort of incident is every DBA’s nightmare.
2007-11-26
170 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers