... QualificationRef
001 00101
001 00102
002 00201
-- Qualification Ref is a unique number using the
-- Employee Number concatenated with a 2 digit sequence
-- number ...
... - USE ARROW KEYS OR MOUSE):
As you can see from the screenshot above, there are modules concatenated with one module an "X" and then the name of the linked module. A module called "Opportunities_X_Products" ...
... (dummyIndex INT);
-- Alter temporary table structure to match given table
SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF(
(
-- Code to concatenate column names and data ...
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 ...
... version because I find myself needing to group concatenate more often from another table then using data from the same table.
MySQL
SELECT
(
SELECT
GROUP_CONCAT(column_to_return_as_string) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.